Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

1 Answer 1

up vote 0 down vote accepted

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

share|improve this answer
    
thanks for the help! –  Justin Jan 21 '10 at 18:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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