0

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

Justin
  • 189
  • 1
  • 8

1 Answers1

0

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

squillman
  • 37,883
  • 12
  • 92
  • 146