C# Establish SQL Connection

Question

I have a small problem with my SQL Server and the connection I want to establish to it.

Here's my server:

Now I've tried to establish a connection, but it does not seem to work:

SqlConnection myConnection = new SqlConnection("user id=Admin;" +
                                   "password=PleaseWork;server=SQLEXPRESS" +
                                   "connection timeout=1");
try
{
    myConnection.Open();
}
catch (Exception e)
{
    catchExceptionBox.Text = e.ToString();
}

Unfortunately, since I have not yet worked with SQL Server, I do not know how to look up the IP of my server. Anyways, the error message I receive is a standard failed-connection message (which I receive after 14 seconds of trying to connect).

Any help would be appreciated.

Well, if you don't know the IP of your server, that is likely your issue, isn't it? Also, "connection timeout=1" seems pretty low. — Glorin Oakenfoot
– Glorin Oakenfoot, Commented Nov 19, 2015 at 14:13
@GlorinOakenfoot Well, I thought using the name would suffice... I changed the timeout to 30, but still no change. Using localhost\\SQLEXPRESS also brought no change — Kohnarik
– Kohnarik, Commented Nov 19, 2015 at 14:17

Valentin · Accepted Answer · 2015-11-19 14:16:25Z

3

Are you missing ; after server=SQLEXPRESS?

answered Nov 19, 2015 at 14:16

Valentin

5,4882 gold badges28 silver badges38 bronze badges

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

1 Comment

Kohnarik Over a year ago

That brought indeed a change! Now it's just a failed login. Thank you very much!!

Karl Gjertsen · Accepted Answer · 2015-11-19 14:18:07Z

3

A SQL Server connection string should be along the lines of:

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

You are not specifying the database name. myServerAddress doesn't have to be the IP Address of your server and can be the name of your server instead.

www.sqlconnectionstrings.com/sqlserver is a good resource to use.

edited Nov 19, 2015 at 14:18

answered Nov 19, 2015 at 14:13

Karl Gjertsen

4,9588 gold badges43 silver badges64 bronze badges

6 Comments

Ernesto Over a year ago

He is using SQL Server Express, so more like msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx#sse

Karl Gjertsen Over a year ago

@Ernesto: I missed that. Good spot.

Kohnarik Over a year ago

Thank you for your input. Regarding the database, I have not yet set up one (except if it sets up one by standard, but then I wouldn't know the name).

Ernesto Over a year ago

You also might need to set Integrated Security=False;to use username password.

Karl Gjertsen Over a year ago

I think it is false by default. It is only switched on when you set it to true.

|

Collectives™ on Stack Overflow

C# Establish SQL Connection

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related