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

Question

Can I still 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 for 2008.

please don't put "SQL 2008 Express - C# - " in your title. Just leave that info in the tags. — John Saunders, May 26 '11 at 13:34

score 5 · Accepted Answer · answered May 26 '11 at 13:33

5

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

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

answered May 26 '11 at 13:33

Oded

Could I create an alias in Configuration Manager and use that as my datasource in my connection string? – tdjfdjdj May 26 '11 at 14:02
@user719825 - http://stackoverflow.com/questions/907851/change-sql-server-instance-name – Oded May 26 '11 at 14:03

score 0 · Answer 2 · answered May 26 '11 at 13:36

0

What is the final purpose of the app as it more conventional to include pc name.

answered May 26 '11 at 13:36

Enzero

2 Answers2