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 |
|
jitudavda
Starting Member
11 Posts |
 Posted - 2003-07-26 : 06:03:41
|
| Hi,Can you guide me? I'm getting following error, when I run a script or login using the query analyser.=======================Error Type:Microsoft OLE DB Provider for SQL Server (0x80004005)Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection./Click/TopTen.asp, line 77=======================Thankss to allJituJitu |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-07-26 : 07:07:00
|
| Looks like you're trying to use a local SQL account (sa) to login to a trusted (windows account) server.Make sure your SQL server allows local accounts and that the asp code specifies local account. (Use something other than the sa account for security) |
 |
|
|
jitudavda
Starting Member
11 Posts |
Posted - 2003-07-26 : 07:40:35
|
Thank you smccreadie,I changed the authentication to Windows and SQL server both, and it worked. Thanks again.Jitu quote:
Looks like you're trying to use a local SQL account (sa) to login to a trusted (windows account) server.Make sure your SQL server allows local accounts and that the asp code specifies local account. (Use something other than the sa account for security)
Jitu |
|
|
|
|
|
|
Not Associated with trusted SQL Server connection