Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sbt1
Yak Posting Veteran
89 Posts |
 Posted - 2003-05-21 : 14:58:58
|
| I have a SQL Server 7.0 database that my application accesses thru OLE DB. Every time it makes a connection to the database, it passes the server name, username, password, and database name in the connection string. Works great.Now, I need to make the app run on another server (SQL Server 2000) and the administrator wants me to use Windows authentication. How does this work? Do I leave the username and password fields blank in the connection string, thus causing SQL Server to use Windows authentication instead? |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2003-05-21 : 15:09:35
|
| oConn.Open "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "Integrated Security=SSPI"More information on connecting with Windows Authentication is provided in KB article #247931Edited by - izaltsman on 05/21/2003 15:15:25 |
 |
|
|
|
|
|
Connecting using Windows authentication?