Can I use datasource =. \\ SQLEXPRESS or do I now need to use: machinename \\ SQLEXPRESS

Question

Can I use datasource =. \ SQLEXPRESS or do I need to change it to: machine_name \ SQLEXPRESS for a local instance of SQL Server 2008 Express in C #?

My connection string worked fine in SQL Express 2005, but with the same settings no longer works in 2008.

+4

tdjfdjdj May 26, '11 at 13:31

2 answers

What is the ultimate goal of the application, since it is more arbitrary to include the name pc.

0

Enzero May 26, '11 at 13:36

Odded · Accepted Answer · 2011-05-26T13:33:52+0000

Assuming the instance name is really SQLEXPRESS , using .\SQLEXPRESS will work locally.

Use SQL Server Configuration Manager to find out the correct instance name.