Connecting with SQL Server authentication

Question

Connecting through Sql Server's Management Studio works, however, it will not connect through the web.config connection string.

<add name="cnString" connectionString="Data Source=(local); Initial Catalog=MyDB; User ID=andrewbb; Password=myPassword;" providerName="System.Data.SqlClient" />

It returns: Login failed for user 'andrewbb'. Reason: Password did not match that for the login provided. [CLIENT: ]

Both the password and user id are lowercase. Ideas?

Is it a windows ID or a SQL ID? If its an sql ID You may need to add "Integrated Security=false" — BugFinder
– BugFinder, Commented Sep 19, 2012 at 6:49
did you set the password and user name respectively of the MyDB database in the Sql Server's Management Studio? — user1430484
– user1430484, Commented Sep 19, 2012 at 6:49
are you in a domain? Is your SQL Server set to Windows Authentication mode only? (This can be checked in the Sever-Properties -> Security) — konqi
– konqi, Commented Sep 19, 2012 at 6:49

Community · Accepted Answer · 2017-05-23 12:14:41Z

1

Your log-in details need to keep all the time. Include following in connection string to keep security info.

Persist Security = true

Refer : Difference Between Persist Security Info And Integrated Security?

edited May 23, 2017 at 12:14

CommunityBot

11 silver badge

answered Sep 19, 2012 at 6:49

Prasanna

4,7432 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrew Over a year ago

Yes, this was the solution. Thank you.

Kapil Khandelwal · Accepted Answer · 2012-09-19 07:22:03Z

0

Try adding NETWORK SERVICE account to the database

How to: Use the Network Service Account to Access Resources in ASP.NET

Check This

answered Sep 19, 2012 at 7:22

Kapil Khandelwal

16.2k3 gold badges49 silver badges55 bronze badges

Collectives™ on Stack Overflow

Connecting with SQL Server authentication

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related