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;
   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!!



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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.