Home / server / Questions / 105125
Accepted
Justin
Asked: 2010-01-22 10:25:38 +0800 CST

SQL SERVER Express Connection String for User Instances same on SQL Server Standard

  • 772

So SQL Server 2005 Express edition has the following connection string by default, which enables user instances instead of Concurrrent Multi-User Access:

Data Source=.\SQLExpress;
   AttachDbFileName=|DataDirectory|\dash.mdf;
   Integrated Security=True;User Instance=True

So my question is just simply is this the same for SQL Standard, or SQL Enterprise?

I know the database development aspect, but implementing on a server, I am a rookie.

So on that note, any learning resources you can offer would be highly appreciated!!

Thanks

sql-server sql-server-2005 ssms database-administration

1 Answers

  1. Best Answer

    No, that's an Express specific connection string. The AttachDbFileName directive is only supported by Express.

    For a comprehensive reference have a look at ConnectionStrings.com

    • 0