SQL Server 2008 R2 connection string error

Question

I have a SQL Server 2008 R2 running but when I try to connect to the server via my C# connection string I receive an error. I have no clue of what the problem is!

Here is my connection string:

_msConnection = new SqlConnection("Server=ServerIpAdress;Database=DataBaseName;User Id=NetworkName\\UserName;Password=PW;");

I hope some of you guys can help me?

Have a great day you all!

try with `Id=UserName` only instead of `Id=NetworkName\\UserName` — Milen, Feb 13 '14 at 10:06
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attepmt to continue. If you click Quit, the application will close immediately. ExecuteReader requires an open and available Connection. The connection's current state is closed — thijs1095, Feb 13 '14 at 10:07
you have actually forgot to open the connection, the problem is not with the connection string..!! after creating a connection you should open the connection created. — Amarnath Balasubramanian, Feb 13 '14 at 10:10
http://stackoverflow.com/a/9707060/3030434 refer the answer here..!! — Amarnath Balasubramanian, Feb 13 '14 at 10:12
"Unhandled exception has occurred in your application" - mybe learn some basic debugging and showing the real exception text? I mean, come on, people learn that part in week 1. — TomTom, Feb 17 '14 at 08:46
Solved it. Problem was windows authentication! Now i used own authentication:) — thijs1095, Feb 19 '14 at 12:50

score 0 · Accepted Answer · answered Feb 13 '14 at 10:11

Id=NetworkName\\UserName

sounds a bit strange, try

Id=username

Also if you can connect to the DB using MS VS, MS SMS or any other likely tools your app can connect passin exactly same paramenters.

Other things to check: Actual user running the app (IIS_USR maybe) In your SMS or VS you can get the actual connection string being used and just copy past it.

SQL Server 2008 R2 connection string error

1 Answers1