What is the name of the data source when we use SQL Server Express Edition?

 Posted by Ddd on 3/24/2011 | Category: ADO.NET Interview questions | Views: 2724 | Points: 40
Answer:

It is .\SQLEXPRESS
It is specified in the connection string.
The complete connection is like this:

Data Source=.\SQLEXPRESS;AttachDbFileName=c:\abc.mdf;Integrated Security=True;
User Instance=True


It is presumed that abc.mdf file exists in c drive. abc.ldf must also be there.
Integrated Security is used to authenticate SQL Server Express Edition.
User Instance=true. It starts SQL Server Express Edition using the current user's
account.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response