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 |
|
jing
Starting Member
1 Post |
 Posted - 2004-10-21 : 22:19:19
|
| Hi everyone,I've got an error message in my asp.net development "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." when i am trying to connect execute the code "sqlconnection1.open".The scenario:1. i have my (computer 1) asp.net development pc and accessing the (computer 2) sql server from another pc.2. there's no problem when accessing the sql server locally (accessing in computer 2)3. there's no problem when im accessing the vb 6.0 from computer 1 to access the sql server from computer 2.4. but, but, when i use the asp.net, i've got that error message mentioned above. i tried to add my computer 1 account to computer 2 in the following (sql server, domain user, iis) and also set the sql server security to mixed mode. please help me. i have only 5 working days to complete my project. thank you so much.Jing BurayagPhilippine Rice Research Institute |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-10-25 : 12:27:14
|
| Is SQL Installed with Windows only authentication? (null) user usually means you have anonymous access on in IIS, and Windows Only Authentication. What is your connection string?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Not associated with a trusted SQL Server Connect'n