Re: sql 7.0 to sql 2000 upgrade user/permissions

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 05/08/02 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Wed, 8 May 2002 08:24:41 -0500

It may be that the syslogins/sysuser mapping is out of sync due to the
restore. You might check out sp_change_users_login in the Books Online
to remedy the situation.

Hope this helps.

Dan Guzman
SQL Server MVP

-----------------------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------

"Richard J. Fowler" <richardjfowler@msn.com> wrote in message
news:e7o#ebi9BHA.2540@tkmsftngp05...
> I'm using a database restore to upgrade a sql 7.0 database to a sql
2000
> database. The public user has full permissions. I'm logged on as sa to
do
> the restore from enterprise manager. After the upgrade, I am not able
to
> change the permission using either t-sql or enterprise manager. The
commands
> seem to complete successfully but the changes do not get made. If I
add a
> user (Windows Group), I am not able to set the permissions for the
user.
> sysprotects does not get updated. I've tried changing the database
owner to
> sa but that does not help I cannot get the database to accept any
permission
> setting except for database permissions.
>
> Thanks - Rich F.
>
>

Relevant Pages

  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.programming)
  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)