Tuesday 23 July 2013

Can not connect to dataase "test.mdf" .login failed for the user ''''''''''. with Windows authentication,SQLserver

This is the error we face, when we are normally try to connect with database(SQLserver )  under windows authentication.

Solution:

Check for your login under SECURITY folder in SQLSERVER object explorer.

If the login found,then mention the username and password in CONNECTION string as below

<add key="connectionString" value="Data Source=.\SQLSERVER;Initial Catalog=TestDB;;Integrated Security=True;user id=sa;password=123456/>


For more details about connections, go with the below 

linkhttp://www.connectionstrings.com/sql-server-2012




No comments:

Post a Comment