+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / New SQL password now cannot connect to Sitefinity

New SQL password now cannot connect to Sitefinity

3 posts, 1 answered
  1. Rob
    Rob avatar
    70 posts
    Registered:
    08 Nov 2011
    25 Apr 2013
    Link to this post
    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
  2. Victor Velev
    Victor Velev avatar
    1345 posts
    Registered:
    06 Jul 2015
    26 Apr 2013
    Link to this post
    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
    Answered
  3. Rob
    Rob avatar
    70 posts
    Registered:
    08 Nov 2011
    26 Apr 2013 in reply to Victor Velev
    Link to this post
    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

       
3 posts, 1 answered