Skip to main content

Posts

Showing posts from August, 2010

Login failed for user 'sa'. Reason: The account is disabled. SQL Server

As the error says the particular login is Disabled. Thus, we need to enable the user. Follow these steps to enable the user. Go to start -> programs. Open Sql server management studio Login to the SQL server (using windows authentication). Expand the security tab. Expand the Login folder. Select the user for which you got this error. In this case 'sa'. Right click and select properties. Enable the user. Save settings. Now it should work fine. Hope this will help.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 2 - Connection was terminated)

I told you about the problem faced by my friend while trying to install DotNetNuke for Windows Web App Gallery. He got Login Failed For User 'sa' error. For resolution check here . After resolving the error he tried again to install DotNetNuke and this time he got the error -   A connection was  successfully established with the server, but then an error occurred  during the login process. (provider: Shared Memory Provider, error: 2 -  Connection was terminated) The reason for this was that he forgot to restart the SQL server service after he changed the configurations as explained in my last post.  I am posting it separately as I have seen many of us searching for this kind of error. Hope this will help.

Login Failed For User 'sa'. SQL Server

One of my friend was trying to install DotNetNuke from Windows Web App Gallery. While installing he was prompted for SQL server administrator user ('sa') credentials. He was clueless about this as he never gave a password for it. He tried using his system password (he was working on his personal system) and got the famous  error - Login failed for user 'sa'. Reason: Actually while installing SQL server he had used windows authentication and now he was trying to use SQL Server authentication. To resolve this -  Go to Start-> Programs  and open SQL server management studio. Connect to the SQL Server you want to change user authentication for (using windows authentication). Right click on the SQL Server and select properties. Now select "Security"and select SQL Server authentication Save settings. Now go to Administrative tools and restart the SQL Server service to let the change take effect. Hope this will help yo