This might be a stupid questions but,
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment