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

Question

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)?

Is the application deployed in IIS ? If yes, can you tell me what is your Application Pool Identity for this app ? — Gurwinder Singh
– Gurwinder Singh, Commented Aug 4, 2017 at 7:04
i have create the database in vs itself and only change the connection string and installed sql server express in client pc .. what shall i do ? — Essam Fahmy
– Essam Fahmy, Commented Aug 4, 2017 at 7:07

Uttam Neupane · Accepted Answer · 2017-08-04 07:14:39Z

1

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

answered Aug 4, 2017 at 7:14

Uttam Neupane

665 bronze badges

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

Comments

Essam Fahmy · Accepted Answer · 2017-08-04 20:25:06Z

1

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,

answered Aug 4, 2017 at 20:25

Essam Fahmy

2,32529 silver badges37 bronze badges