C# SqlConnection ConnectionString

Question

Could someone please help me in finding the correct SQL Connection String to connect to my database in C#. The database I wish to connect to is shown in the following screenshot from SQL Management Studio

These are just your instances of SQL Server, you'll need to know the actual database names/servers/credentials in order to build a connection string. — Goose
– Goose, Commented Jan 3, 2014 at 21:59
Make sure that you have internet connection that allows you to connect to port 1433. Ones I was working from Starbucks and I couldn't connect to the sql server. — Salah Salah
– Salah Salah, Commented Jan 3, 2014 at 22:06

Termato · Accepted Answer · 2014-01-03 22:35:44Z

4

You can store your connection strings in you web.config or app.config file. I have placed an example string in a snippett here:

<configure>
<connectionStrings>
<add name="YOURDESIREDCONNECTIONSTRINGNAME" connectionString="Data Source=IPADDRESSorURL;Initial Catalog=DATABASENAME;User ID=YOURUSERNAME;Password=YOURPASSWORD" providerName="System.Data.SqlClient" />
  </connectionStrings>
</configure>

In your scenario, you are using SQL Express so use the following:

Data Source=.\SQLEXPRESS;

As far as you have described the question, this is the best answer I can give at the moment. I hope this helps and let me know if you have any questions.

edited Jan 3, 2014 at 22:35

answered Jan 3, 2014 at 22:07

Termato

1,6102 gold badges19 silver badges35 bronze badges

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

1 Comment

Doug_Ivison Over a year ago

The most helpful answer, in light of the C# tag, on the question.

Doug_Ivison · Accepted Answer · 2014-01-03 22:22:14Z

2

The instance of SQL Server that you have highlighted is SQL Server Express which is either connected to using:

.\sqlexpress

or

SERVERNAME\sqlexpress

You can try:

Server=.\sqlexpress;Database=YOURDATABASENAME;User Id=YOURSQLUSERNAME;Password=YOURSQLUSERPASSWORD;

or

Server=.\sqlexpress;Database=YOURDATABASENAME;Trusted_Connection=True;

As others have said take a look at http://www.connectionstrings.com/sql-server/ for further reference on sql server connection strings.

edited Jan 3, 2014 at 22:22

Doug_Ivison

6487 silver badges19 bronze badges

answered Jan 3, 2014 at 22:08

melodiouscode

2,0691 gold badge20 silver badges42 bronze badges

Comments

Ivan · Accepted Answer · 2014-01-03 22:02:58Z

0

This site contains everything you need: http://www.connectionstrings.com/sql-server/. In your case server addres is .\sqlexpress or serverName\sqlexpress.

answered Jan 3, 2014 at 22:02

Ivan

1386 bronze badges

Collectives™ on Stack Overflow

C# SqlConnection ConnectionString

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related