CODEWITHSUNDEEP
sql-server
JD.
JD.

Reputation: 15551

SQL server administrators group

I have a service that runs under as specific windows user. That user is part of the adminstrators group.

In the SQL server database, I can see in the security pane : Builtin\Adminstrators.

The connections string contains Integrated Security = SSPI (no username or password).

Is the fact that I can connect to the database a result of my user being in the administrators group which corresponds to Builtin\Adminstrators in sql server?

JD.

Upvotes: 1

Views: 6391

Answers (1)

Eric
Eric

Reputation: 95133

Yes, yes it is.

SQL Server uses Windows Authentication (you can enable native SQL logins, as well, though), and that includes groups. If you add a group and give that group permissions (in this case, Builtin\Administrators), then every member of that group has access.

In SQL Server 2000 and 2005, Builtin\Administrators were default server administrators. In 2008, that's no longer the case, but many people go that route out of habit, anyway.

Upvotes: 4

Related Questions