Unable to login to SQL Server instance from Management Studio   6 comments

Posted October 22, 2012 by Manish Upadhyay in SSMS, Tools

Tagged with ,

6 responses to “Unable to login to SQL Server instance from Management Studio

Subscribe to comments with RSS.

  1. I am confused. The issue was with SQL Login, so how its related to Windows Profile. So even if the user profile is corrupted, how it effects a SQL Login.

  2. Thanks for your time in reading this blog Azad. Here is the answer to your question.

    When we connect to SQL Server using SQL Login account the management studio will encrypt the password on the %appdata% Microsoft\Protect folder and the current logon windows account has to open the %appdata% on the run windows.

    This information is saved in HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\AppData.
    So you have wrong/corrupt value at this location or permission issue with this Protect folder it will not allow you to login.

    This is reproducible, you can test it on your own by either changing the permission or modifying the location. But one thing to note here if you remove this Protect folder manually SSMS will create it automatically hence re-login with new profile works fine!!

  3. Pingback: SQL Agent Job reports error “SQLServerAgent is not currently running ” Though Agent Service is runnig « SQLactions.com

  4. hi manish.
    i’ve got the same issue, but the solutions doesn’t work for me :/

    i’m working with windows 10 and sql server 2014, logged with a domian user.

    i create a local administrator user, then a use this user to rename de useraccount folder. and login again, but windows creates a “temp folder profile” not a new folder, and management studio working bad.

    ¿any other idea?

    ¿is there any microsoft issue for this?

  5. Hi Leandro,
    Are you able to login to SQL Server with local administrator user? You can run procmon and see where your Appdata is pointing to?

    • thank’s for your reply!

      yes, i can log into ssms with my Windows user as admin. and i can run procmon, but i don’t know what exactly to see there.
      the registry key *HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders\AppData* is ok and the folder exists.
      with procmon i see that ssms is traying to read some registry keys that doesn’t exists.
      the access to %USERPROFILE%\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0 seems to be ok.

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: