How to user SQLServer Authentication in SQL server management studio
-
I have installed visual studio 2008. Then I installed sqlserver management studio. I connect using windows authentication. But there is another option to connect using sqlserver authentication. Where will I get the login name and password to connect using sqlserver authentication. For test purpose I have connected using windowsauthentication and then created a login by right clicking the security folder and I have chosen sqlserver authentication and provided necessary information and clicked ok. But when I tried to login by this new login name using sqlserver authentication It shows the following error: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)" Am I in the right way to login using sqlserver authentication? If I am in right way why I am getting the error?? Please help to solve the problem. I really need to test the option: sqlserver authentication
-
I have installed visual studio 2008. Then I installed sqlserver management studio. I connect using windows authentication. But there is another option to connect using sqlserver authentication. Where will I get the login name and password to connect using sqlserver authentication. For test purpose I have connected using windowsauthentication and then created a login by right clicking the security folder and I have chosen sqlserver authentication and provided necessary information and clicked ok. But when I tried to login by this new login name using sqlserver authentication It shows the following error: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)" Am I in the right way to login using sqlserver authentication? If I am in right way why I am getting the error?? Please help to solve the problem. I really need to test the option: sqlserver authentication
-
1. Check that mixed mode authentication is enabled. 2. Check that the "sa" login is enabled; I think it's disabled by default.
Back in the blog beatch! http://CraptasticNation.blogspot.com/[^]
I have enabled the sa login. But how can I enable mixed mode?
-
I have enabled the sa login. But how can I enable mixed mode?
You can enable mix mode Authentication via connecting to SQL Server in Mamagement Studio via Windows Authentication then Open the Properties of the Server. Select Security Page listed in left panel. At this page, there is Server Authentication Block, Choose SQL Server & Window Authentication Mode. I hope it gonna help u.
-
You can enable mix mode Authentication via connecting to SQL Server in Mamagement Studio via Windows Authentication then Open the Properties of the Server. Select Security Page listed in left panel. At this page, there is Server Authentication Block, Choose SQL Server & Window Authentication Mode. I hope it gonna help u.
Thanks a lotzz!!! It's really great. It is working.... :)
-
Thanks a lotzz!!! It's really great. It is working.... :)
:)