CODEWITHSUNDEEP
sql-serversql-server-2008authenticationwindows-authentication
Sainath
Sainath

Reputation: 999

change from windows authentication to sql server authentication

can anyone tell me how to change from windows authentication to SQL server authentication.I have been using this as my connection string

"server=.;Data Source=.;Initial Catalog=Work;Integrated Security=True"

Upvotes: 0

Views: 2615

Answers (2)

Serg
Serg

Reputation: 2427

Everything You Always Wanted to Know About Connection Strings But Were Afraid to Ask - www.connectionstrings.com

Upvotes: 1

Siddhant Swami
Siddhant Swami

Reputation: 327

The following connectionString format should do the job.

connectionString="user id=yourUsername; password=yourPassword;data source=yourServerName;initial catalog=yourDatabaseName;"

Upvotes: 0

Related Questions