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 |
|
vbjohn
Starting Member
32 Posts |
 Posted - 2004-11-15 : 13:14:08
|
| I am trying to create a USER in the "Users" area n SQL server 2000. When I try to create the User it tells me that there is already a user under that name. It does not show up under the "Users" area. So I go into the table called "sysusers" and it shows up in there. So when I try to log into the system from our ASP page it tells me that "Cannot open database requested in login '*****'. Login fails. "Please help. |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-15 : 13:40:40
|
| try sp_change_users_login procedure. read up on it in books online. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-16 : 00:22:27
|
quote:
Originally posted by crazyjoe
try sp_change_users_login procedure. read up on it in books online.
if this doesn't work, drop the user and recreate.--------------------keeping it simple... |
|
|
|
|
|
|
Database / Users...error