Post reply

cannot log into database after retore the database on another sql server

  • March 21, 2008 at 6:49 pm

    #121072

    Hi all,

    I just restore my sql server 2000 database on sql server 2005. Then I cannot log into the server anymore. I guess it is because even I can see the old user names under my databasename/security/user, since the server name is changed and is different, I need to add the my old user names to new sql server login right?

    How to add login for the new database server and If I want to look at the old usernames for log in in the database, which database table I should look into?

    I don't do this task very often, every time I need to somebody to help me.

    Thanks

    Betty

  • March 21, 2008 at 7:38 pm

    #792769

    Hi all,

    I just added one userid and password to the sql server 2005.

    Now how can I grant this user to a specific database and has a dbo role etc.

    thank you

    betty

  • March 21, 2008 at 10:13 pm

    #792774

    hi all,

    Now I do see the username I added in

    select * from sys.sql_logins

    select * from sys.syslogins

    but I didn't see the username I added in this table.

    select * from sys.sysusers

    what does that mean?

    Thank you.

  • March 21, 2008 at 10:16 pm

    #792775

    Hi all,

    If I see this error message through one of my web page,

    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myServerName\IUSR_WINDOWS2003'

    what does that mean?

    Thanks.

    Betty

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply