Connection string blues (C# -> SQL)

Peter

I'm learning SQL and how to access it from C#.

This is all on the same machine running XP Pro and .Net 2.0 - I've created a database in SQL Server Express and can manipulate it just fine from the SSMSE console. But when I try to open a connection to it in C# using the SqlConnection.Open() method it say's I'm "Not associated with a trusted SQL Server connection".

I've tried different things in the User Id and Password parameters in the connection string, including my PC login password and not using them at all (hoping it would take the default).

When I start up the SSMSE it lists the "User name" as "GEMINI\peter" (GEMINI is my PC) but if I use that in the connection string it just says GEMINI\peter is not associated with a trusted SQL Server connection.

How do I figure out what it wants? Thanks in advance!

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Peter17y ago
I got the answer on another forum but I'm also posting it here incase it helps anyone -

In my connection string I was using the User Id and Password parameters with my login. But the solution was to NOT use those paramters, and instead use the string "Integrated Security=True" in my connection string. So my new, working connection string looks like this:

"Data Source=GEMINI\\SQLEXPRESS;Initial Catalog=HWDB2;Integrated Security=True";
Jan Montano17y ago
could you post your connection string? including your block of code for opening the connection.
Peter17y ago
I'm not using any special SQL Server login. SQL Server Express Security | Login says that it's using the default "peter" login that I user when I log onto my PC. (this has full administrator priveleges).
Scott Lysle17y ago
If you are using an SQLServer ID and password, you will have to setup the database to allow SQLServer authentication; by default it should be set to windows authentication.