SQL connection string on domain C#

Question

I moved a webapp from my personal machine to my work machine, along with the database I've been using to test. When clicking the submit button that inserts the data, I get the error, can't find server/instance. I'm thinking that being on a domain here is part of the problem. Here is my connection string, and I've tried several forms of it already.

Data Source=\\bkirkland_lpt.domain.com\brandon;Initial Catalog=STATUS;integrated security=SSPI;persist security info=False;Trusted_Connection=Yes;");

That's not a valid Data Source. SQL Server isn't UNC.

SLaks
– SLaks

2012-02-13 20:07:10 +00:00
Commented Feb 13, 2012 at 20:07 — SLaks
– SLaks, Commented Feb 13, 2012 at 20:07

Dave · Accepted Answer · 2012-02-13 21:32:27Z

1

I see a couple problems here.

First, it looks like you are using the wrong data source. The data source should be in the format [ServerName]\[InstanceName]. Based on your code, I would suggest

Data Source=bkirkland_lpt.domain.com\brandon;Initial Catalog=STATUS;integrated security=SSPI;persist security info=False;Trusted_Connection=Yes;

Additionally, I notice you are using Integrated Security. This means that the user you are running under must be granted permissions on the database. My guess is that your domain user does not have access to the database that you moved.

answered Feb 13, 2012 at 21:32

Dave

11k3 gold badges45 silver badges54 bronze badges

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

2 Comments

RageQwit Over a year ago

I created the db and the instance. This is all on my local machine. My machine is bkirkland_lpt.

RageQwit Over a year ago

Removed slashes and it still doesn't work. I was able to add the db as a data connection with no problem. It shows up as, bkirkland_lpt\brandon

adontz · Accepted Answer · 2012-02-13 20:07:55Z

0

\bkirkland_lpt.servicesource.com\brandon is a shared folder path, not a host name. Try bkirkland_lpt.servicesource.com

answered Feb 13, 2012 at 20:07

adontz

1,43817 silver badges36 bronze badges

2 Comments

RageQwit Over a year ago

The instance name is BRANDON.

adontz Over a year ago

anyway you should remove leading slashes

Eray Balkanli · Accepted Answer · 2018-12-06 17:17:50Z

0

Try to enclose the server name in []. Try to replace the servername with localhost and see if it makes any difference (if it is all on your local machine). I also would use proper casing and True vs Yes as parameter value.

Data Source=[bkirkland_lpt.domain.com]\brandon;Initial Catalog=STATUS;Integrated Security=SSPI;Persist Security Info=False;Trusted_Connection=True;

Data Source=localhost\brandon;Initial Catalog=STATUS;Integrated Security=SSPI;Persist Security Info=False;Trusted_Connection=True;

edited Dec 6, 2018 at 17:17

Eray Balkanli

8,05013 gold badges60 silver badges94 bronze badges

answered Feb 23, 2012 at 16:22

demp

12.8k2 gold badges25 silver badges18 bronze badges

Collectives™ on Stack Overflow

SQL connection string on domain C#

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related