Re: Getting SQL7 to work -> SBS2003 Standard vs Premium

From: Steve Foster [SBS MVP] (steve.foster_at_picamar.co.uk)
Date: 05/12/04 

Date: Tue, 11 May 2004 21:17:23 -0700

Edmond Low wrote:

> Yes, we should have bought the Premium edition instead. Just happened
> that we were not briefed on the version of SQL that was currently in
> use.
>
> By unstalling SQL7, would it affect the logins and permissions for
> databases as defined in SQL7? Would I need to set it up again after I
> have put in SQL2000?

It would affect the logins, but not the permissions directly.
Permissions are associated with users. There are some issues to deal
with to re-associate logins to their users, but it's all covered in SQL
BOL. 

-- 
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... I am talking about SQL Logins, ... can go to the object and see that user X has permissions XYZ on that object, ... I then restored the databases and re-synched the users via the ...
    (microsoft.public.sqlserver.security)
  • Re: object level permissions being lost when migrating
    ... Just want to confirm that you are talking about SQL Logins and not windows Logins correct? ... As far as I know the compatibility level should not be an issue one way or the other but exactly how are you looking at the permissions? ... I first transferred the logins from the 2000 server to the 2005 server via ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • 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)
Quantcast