C# connect to database

In a C# 2008 windows application I found out the following when the application is executed for a task scheduler:
The windows username and password are exactly the same as the sql server username and password.
Thus if the following is in the connection string in an app.config file, the following will use the sql server login and not the
windows user login correct?

connectionString="Data Source=dev;Initial Catalog=DEV2;User Id=myUsername;Password=myPassword;"
providerName="System.Data.SqlClient" />

Also can you tell me if there is any way for the windows user name and password to be used when connecting to the
sql server 2008 r2 database? If so, can you tell me what the connection sting would be so I know to avoid that connection string?

1 Reply

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

Jignesh Trivedi13y ago
hi,
To connect sql server with windows authentication, must use following connection string

"Server=MyServer;Database=DatabaseName;Trusted_Connection=Yes;"
Or
"Initial Catalog=DatabaseName;Data Source=MyServer;Integrated Security=SSPI;"
Please refer
http://msdn.microsoft.com/en-us/library/ff647396.aspx
hope this will help you.