Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-08-16 : 10:41:30
|
| If I install SQL Server using a certain Windows Login, does that login assume some sort of "sa" alias?(I'm trying to explain the behaviour that when I login in to a server using the same username that I used when i installed the SQL Server instance, using trusted authentication, then use a database within which I haven't created any users, I seem to get full permissions, as if I had gone in as "sa") |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-16 : 13:59:21
|
| You are probably a local administrator on the server. By default, local administrators have sysadmin access. This behavior can be removed though if you'd like.Tara |
 |
|
|
|
|
|
More Trusted vb Mixed