help.. error on connection string

basim salih

8y880

hi ...

i have a database with sql server 2012 authontication called "box"

i build an aplplication in c#.. what i want to do is :

attach this database file into client matchine to run an application without setup sql server.

1- from mycomputer --> manage--> i stoped the sql server serviice

2- i copy database files (box.mdf and box_log.ldf) inside application directory.

3- build connection string to connect with database as:

(

this work correctly: conn.ConnectionString = "Data Source=BASIM-PC\\SQLSERVER2012;Initial Catalog=box;Persist Security Info=True;User ID=basimbox;Password=f1977";

but this error:conn.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=box;Persist Security Info=True;User ID=basimbox;Password=f1977";

)

plz my friend help me!!!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anupam Singh8y ago
Accepted answer
Hi basim, actually BASIM-PC\\SQLSERVER201 is your instance name and this gets vreated when you install sql server. You can see all installed instances in sql server configuration manager. if you want to access like./sqlexpress go a head and install another instance.
0
basim salih8y ago
thank you my friend ... my major problem How can i make database file with (first connection string ) to be localdb to (user machine) and worked the steps in the question ...
how can i? and what is the connection string true to write that?
0