June 14, 2006 at 7:56 am
Our network guy here installed sql with the default settings...so now when i bring up SQL EM i get local
but i need to delete this and add a new registration.
Its says use windows login account or sa...........If i use sa...will the SERVER be in mixed mode authenticaion....or i set that afterwards..
Also i want the SQL to start with DOMAIN/SQL account
how to change.
I know if i installed the SQL i can select all this during installation..
Thanks
June 14, 2006 at 10:54 am
1) How you connect via EM doesn't determine if the SQL Server is in Windows Authentication or Mixed Mode. That's determined by a registry value SQL Server reads on startup. However, if you can log on as sa, that's a clear indication you're running in Mixed Mode. To determine whether or not you're in Mixed Mode, connect to the SQL Server using Enterprise Manager. Right-click and choose Properties. Click on the Security tab and see what it says for Authentication. That will tell you what mode.
In either case, make sure you configure a strong password for the sa account. Even if the SQL Server is in Windows Authentication mode you can still set passwords for SQL Server logins. Setting a strong password (and putting it in a secure location) will ensure that should one switch the mode, they don't get in with the sa account very easily. It also gives you a backdoor by modifying the appropriate registry value and restarting SQL Server if someone accidentally drops the Windows user(s)/group(s) which have sysadmin access.
As to how to change the startup account, do so from that Security tab. Enterprise Manager will take care of handling all rights needed by the account. This is something you probably don't want to tackle manually.
K. Brian Kelley
@kbriankelley
June 14, 2006 at 3:52 pm
Thanks for replying
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply