May 10, 2012 at 1:48 pm
When I install SQL2008 R2 using window authentication.
How to change to sql authentication with sa and password to login?
May 10, 2012 at 2:25 pm
In SSMS, open the Properties page for the server. On the Security tab/screen, change Server authentication to SQL Server and Windows Authentication mode. Click OK, and then restart the server.
Then in SSMS go to Security, open Logins, and then double-click the sa login. On the Status tab/page, ensure that the Enabled option is selected and Permission to connect is granted. Then click OK.
You should be good to go as long as SA has a valid password.
May 10, 2012 at 2:30 pm
I did the same way as you said but got an error: 233.
provider:Shared memory provider, error:0-no process is on the other end of the pipe
May 10, 2012 at 3:26 pm
I am thinking you are accessing the server via SSMS from a different box than the one with SQL Server installed. If this is the case, you need to configure the server to accept remote connections and make sure that the other protocols (TCPIP and/or named pipes) are enabled.
You change the remote connection setting in the DB properties' Security page.
The protocols are maintained by using the configuration manager.
Both changes require a SQL Server restart.
May 11, 2012 at 6:47 am
You are right. Before install 2008 R2, I uninstall 2008 express version but it look like not complete uninstall.
How to complete uninstall express version?
May 11, 2012 at 7:05 am
After modified registry data (delete all for SQLExpress), it works in SQL authentication mode.
Thank all of you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply