Is Computer Administrator role in XP Pro same as System Administrator role in XP Home Edition?

  • Thread starter Thread starter XIAN HUA LI
  • Start date Start date
X

XIAN HUA LI

I have problems on database connection on MS SQL Server using System
Administrator role. The system is Window XP Pro, which has only Computer
Administrator role, no System Administrator role. Are they same in XP Pro?

Please help. I will appreciate it.
 
XIAN said:
I have problems on database connection on MS SQL Server using System
Administrator role. The system is Window XP Pro, which has only Computer
Administrator role, no System Administrator role. Are they same in XP Pro?

Please help. I will appreciate it.
Click to expand...


"System Administrator," a.k.a. the "SA" login name is specific to
SQL Server. There is no "SA" for the operating system, per se, although
the OS's Administrator account is equivalent, as far as privileges go.
So, even if you're logged in to the OS as Administrator, you'll still
have a separate "SA" login account for SQL Server. The OS's login
credentials cannot normally be passed on to or used to log into SQL.


--

Bruce Chambers

Help us help you:



You can have peace. Or you can have freedom. Don't ever count on having
both at once. - RAH
 
Back
Top