Windows form SQL Server connection string issue

Asked Mar 18 '15 at 02:18

Active Mar 18 '15 at 05:47

Viewed 448 times

I have a Windows Forms application written in C# using SQL Server 2012 Express as its database.

I need a connection string to work on any PC.

I try to put the .mdf file in DataDirectory or drive C: or C:\ProgramData

DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\mydb.mdf;Pooling=False;

In this case the error is:

Failed to update .mdf database because the database is read-only

If I try to use

user instance=True;

in the connection string, I get the following error :

System.Data.SqlClient.SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

If I try to put the .mdf file in user application data AppRoaming folder it's not supported and returns error :

An attempt to attach an auto-named database for file failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

So how to set my connection string and where should the .mdf file be stored?

Please help me

And thanks in advance

edited Mar 18 '15 at 05:47

marc_s

732,580
175
1,330
1,459

asked Mar 18 '15 at 02:18

Moayad Myro

in this case mdf file should be in – Moayad Myro Mar 18 '15 at 02:27
C:\Program Files\Microsoft SQL Server\MSSQL11.express\MSSQL\DATA – Moayad Myro Mar 18 '15 at 02:32
Maybe try a shorter path (like c:\test) and make sure nothing else has got the db open. – Hanlet Escaño Mar 18 '15 at 03:15
I try put the file is read only – Moayad Myro Mar 18 '15 at 03:22
there are no privilige to write database at that location.Can you install in another location and see? – Tharif Mar 18 '15 at 03:43
yes I try C:\ProgramData – Moayad Myro Mar 18 '15 at 03:48
I try Integrated Security=false;Initial Catalog= – Moayad Myro Mar 18 '15 at 03:49
give an error Additional information: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) – Moayad Myro Mar 18 '15 at 03:50
I think its should be Initial Catalog= but where I have put the MDF file ?? – Moayad Myro Mar 18 '15 at 04:03
Possible duplicate [mdf is read only][1] [1]: http://stackoverflow.com/questions/25026925/unable-to-update-database-mdf-is-read-only – nobody Mar 18 '15 at 04:24
I read all of them and not solve my problem I also try to set – Moayad Myro Mar 18 '15 at 05:37
Initial Catalog=file path give me error login failed for user System.Data.SqlClient.SqlException (0x80131904): Cannot open database requested by the login. The login failed. – Moayad Myro Mar 18 '15 at 05:38

Windows form SQL Server connection string issue

0 Answers0