• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

windows login in sql?

does an individual windows login which is an administrator on the server need a windows login created in sql server? This is not a domain login. its just an individual windows login.
0
sqlserverdba
Asked:
sqlserverdba
  • 4
  • 4
  • 2
4 Solutions
 
chapmandewCommented:
Depends.  If the sql instance has the local administrators group installed, then no...there would not need to be an explicit login for the admin.
0
 
sqlserverdbaAuthor Commented:
I know there is  built in administrators group in  the instance. Wouldnt the login be part of built in administrators group?
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
You just need to look for BUILTIN\Administrators in the Security \ Logins container in SQL Server.  If this login exists, then this person would have access.

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
chapmandewCommented:
Yes, the local admin would be part of the builtin\admin group.
0
 
sqlserverdbaAuthor Commented:
so the account can do operations in sql server like create database, backup, restore, etc?
0
 
chapmandewCommented:
sure...that windows group is likely assigned to the sysamin instance role
0
 
sqlserverdbaAuthor Commented:
thank you for the fast response
I just tried to create the windows login in sql server for the account as it seemed to have some problem, but it throws an error
Error Number: 15401
Severity: 16
State: 1
Line Number: 1
Windows NT user or group - serverame\username not found.
Any idea?
0
 
chapmandewCommented:
how are you doing it?

the problem you're having now is likely a new question...
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
the servername\username must exist on that box.

So if the server was SQL1 then the user would be SQL1\username.  If you try to use WIN2\username then it would not allow that because it is not local.  That is why many people use domain accounts.

DOMAIN\username would be allowed if the SQL1 is a member of the DOMAIN.
0
 
sqlserverdbaAuthor Commented:
ok
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now