How to make a connection string for sql server 2005 with a instance that works for all default sql express default instance?

Question

I have built my database in SQL Server 2005 Management Studio and in deployment on my C#.NET application I have added SQL Server Express Edition with the application ..

I was using connection string

server=My-PC\\SA;database=My_database;uid=sa;pwd=sql;"

Now on deployment it gives error of instance. So how to make a connection string defaultly that works for both SQL Server 2005 Management Studio and SQL Server Express Edition?

score 2 · Accepted Answer · answered Jul 25 '12 at 06:37

2

Hopefully this should work,

Server = .\SQLEXPRESS; Integrated Security=SSPI

answered Jul 25 '12 at 06:37

Anuraj

18,859
7
53
79

How to make a connection string for sql server 2005 with a instance that works for all default sql express default instance?

1 Answers1