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 |
|
bazz
Starting Member
26 Posts |
 Posted - 2003-04-17 : 05:39:50
|
| Hi. I'm trying to connect my web site to the MSDE and it kept giving me an error connot connect user MyComputerName\ASPNET I have tried adding the user using the system stored procedure sp_addlogin and sp_addremotelogin (don't ask me why) but it doesn't let you use the back slash (for NT users only) I can easily do it at work because i have MS SQL 2000. I add that user and everything is fine, but when i deleted that user it still connected, why is that? I guess i never really took the time to understand it. Can anyone help? Thanks |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-04-17 : 06:22:47
|
| You should use sp_grantlogin to add NT users. |
 |
|
|
bazz
Starting Member
26 Posts |
Posted - 2003-04-17 : 06:37:07
|
| Thanks Andraax you're a star |
|
|
|
|
|
|
MyComputerName/ASPNET Error