New SQL password now cannot connect to Sitefinity - Sitefinity - General Discussions

All Replies

Posted by Community Admin on 25-Apr-2013 00:00

Good day,
Recently we had to change the password for the sa account (MSSQL 2008R2). Now that is has been changed when anyone tries to login we get the following error:
[SQLException: Login failed for user 'sa'.]
.......
[AuthorizationException: Login failed for user 'sa']

If I go to SQL Server Management I have no problem logging into the database with the sa account

Thanks,
Rob

Posted by Community Admin on 26-Apr-2013 00:00

Hi Rob,

Can you verify that you have changed the password in Sitefinity as well, so that the system can properly authorize to the SQL server? The connection string can be found in the App_Data/Sitefinity/Configuration/DataConfig.config file or the webconfig depending on your project.

Greetings,
Victor Velev
the Telerik team

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

Posted by Community Admin on 26-Apr-2013 00:00

Hi Victor,
I remembered I had to supply the SA password when we installed Sitefinity but didn't know where to change now. Changed it in the dataconfig.config file and that did the trick.
Thanks for the help,
Rob

This thread is closed