CODEWITHSUNDEEP
c#sql-serverconnection
Essam Fahmy
Essam Fahmy

Reputation: 2275

C# : Application doesn't access database in client pc

I have installed sql server in client pc but the app doesn't access database.

this is my connection string :

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDB.mdf;Integrated Security=True;User Instance=True"

please, is there other apps must be installed in client pc (e.g., SSMS)?

Upvotes: 1

Views: 141

Answers (2)

Essam Fahmy
Essam Fahmy

Reputation: 2275

sql server express install with it the localDb.

i have install SSMS and it solve the issue !

now i realize that client pc must install 2 Apps :

1- Sql Server Epress

2- Sql Server Management Studio

thanks every one,

Upvotes: 1

Uttam Neupane
Uttam Neupane

Reputation: 66

Make that Integrated Security=False in connection string as below

connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\myDB.mdf;Integrated Security=False;User Instance=True"

This might be helpful for you

Upvotes: 1

Related Questions