How to create the Data Source property of the ConnectionString in ASP/net MVC?

Question

I can't find a decent tutorial/blog that has a solution for my problem.

On my laptop I run a Microsoft SQLServer named 'SQLSERVER'. There's a database in it called 'SalesDB'. I can't figure out how to fill in the Data Source property of the ConnectionString in the web.config file in my ASP.NET MVC 4 application to get my application connected with the database.

This is the default connectionstring:

<connectionStrings>
<add name="DefaultConnection" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-Labo7SQL-20131226161445;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-Labo7SQL-20131226161445.mdf" />

David · Accepted Answer · 2013-12-26 17:21:27Z

4

connectionstrings.com tends to be a pretty useful resource for formatting a connection string. For MS SQL Server, you have a few options. Such as:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

or

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

or

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

Using the last one as an example, yours might be something like:

Server=localhost\SQLSERVER;Database=SalesDB;User Id=myUsername;Password=myPassword;

answered Dec 26, 2013 at 17:21

David

221k42 gold badges245 silver badges338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Leo · Accepted Answer · 2013-12-26 17:27:12Z

0

The Data Source value should be the name (or ip address) of your sql sever. The Initial Catalog value should be the name of your database...SalesDB and you should remove the AttachDBFilename

answered Dec 26, 2013 at 17:27

Leo

14.9k2 gold badges44 silver badges59 bronze badges

Collectives™ on Stack Overflow

How to create the Data Source property of the ConnectionString in ASP/net MVC?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related