Results 1 to 5 of 5

Thread: Builtin\Administrator login

  1. 10-24-2006, 10:20 AM #1
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127

    Builtin\Administrator login

    Hi All,

    I have a question about this user. Does this user need to be a sysadmin? And if yes, what is the reason for that?

    Thanks.
    Reply With Quote Reply With Quote
  2. 10-24-2006, 11:20 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    If you have a domain account lets say "abc\sqlserver", "abc\inet" that you could use, then add the domain accounts to the sysadmin role and you could remove the builtin\administrator from the sysadmin role.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 10-24-2006, 02:13 PM #3
    inet
    inet is offline Registered User
    Join Date
    Mar 2006
    Posts
    127
    When I tried to create a domain account, I got this error message:

    Error 15401: Windows NT user or group 'abc\sqlserver' not found. Check the name again.
    Reply With Quote Reply With Quote
  4. 10-24-2006, 02:24 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Is sql server in that domain?
    Reply With Quote Reply With Quote
  5. 11-20-2006, 10:47 AM #5
    santiagoc93
    santiagoc93 is offline Registered User
    Join Date
    Nov 2006
    Posts
    2
    you have create firth the user acount into to domain when in sql server creater the user acount taking el user acount created in the domain.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules