0

I have moved database to new SQL server, "Server2", and we did SQL Aliases in all SharePoint servers, like this post

Using SQL Aliases with SharePoint

It happened almost 1 year ago. Now I am trying to run SharePoint Configuration Wizard giving below error. But application is working fine.

enter image description here enter image description here

What could be the problem?

Update:

Log errors after ran wizard

SqlError: 'Cannot open database "SharePoint_Config" requested by the login. The login failed.' Source: '.Net SqlClient Data Provider' Number: 4060 State: 1 Class: 11 Procedure: '' LineNumber: 65536 Server: 'Server1' 07/22/2013 13:25:32.73 OWSTIMER.EXE (0x0724) 0x073C Windows SharePoint Services Database
880j High SqlError: 'Login failed for user 'Domain\sn_spappprod'.' Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 65536 Server: 'Server1' 07/22/2013 13:25:32.73 OWSTIMER.EXE (0x0724) 0x073C Windows SharePoint Services Database
6y63 Critical SQL Database 'SharePoint_Config' on SQL Server instance 'Server1' not found. Additional error information from SQL Server is included below. Cannot open database "SharePoint_Config" requested by the login. The login failed. Login failed for user 'Domain\sn_spappprod'. 07/22/2013 13:25:32.73 OWSTIMER.EXE (0x0724) 0x073C Windows SharePoint Services Database
880k High at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior) at

It suppose to connect alias databases.

Improve this question

2 Answers 2

Reset to default
0

Looks like a permissions issue with the DOMAIN\sn_spappprod account. Does it have a SQL login with the necessary rights? If you have a multi server farm, do you have an alias on every server?

A nice trick to see if your user has access is to use a testfile, see the bottom section of this article on how to do that. If that test returns no errors, your connection to the sql server is ok - be sure to use the alias name SERVER2 when running the test.

If the test returns an error, your alias probably is not configured correctly on the server.

It could also be that your account doesn't have the needed permissions to run the configuration wizard. Refer to the "Setup user administrator account" section in this article.

Improve this answer
3
  • How come application is working?
    – James123
    Jul 23, 2013 at 15:17
  • The application probably runs with different service accounts than the account you're using to run the configuration wizard - and they should be :)
    – Thomas Vochten
    Jul 23, 2013 at 15:20
  • OK. My admin is already out for the day. I will get back tomorrow.
    – James123
    Jul 23, 2013 at 15:44
0

You're probably on a 64bit OS while the Config Wizard is 32bit.

There is a 32bit and 64bit version of cliconfg. It is best to configure them in an identical way.

On a 64bit OS:

  • cliconfg (64bit): C:\windows\system32\cliconfg.exe
  • cliconfg (32bit): C:\windows\syswow64\cliconfg.exe
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.