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 |
|
pete67
Starting Member
1 Post |
 Posted - 2002-01-19 : 14:06:47
|
| I'm new to SQL Server. I'm unable to get a connection to the SQL Server's Pubs database through an ASP page I created. I keep getting an error message stating that this is not a "Trusted Connection".I'm trying to connect using the system administrator login "sa" login below:Set conn = Server.CreateObject("ADODB.Connection") conn.Provider = "SQLOLEDB" conn.ConnectionString = "SERVER=GENIUS; DATABASE=Pubs; UID=sa;Password=;" conn.OpenI simply need to connect to the Pubs database through an ASP page.Any help would be very much appreciated.Thank you kindly,Pete |
|
|
sica
Posting Yak Master
143 Posts |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-20 : 00:57:00
|
| Also, walk over to your bookshelf, find a heavy book, and smack yourself over the head with it while repeating this chant....CHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDCHANGE THE SA PASSWORDDamian |
 |
|
|
|
|
|
Connecting to SQL Server from ASP page