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 |
|
shyamprasad76
Starting Member
38 Posts |
 Posted - 2001-10-30 : 15:25:15
|
| Hi,When I installed SQL Server 2k on my database machine, I installed with userid=’sa’ and password as blank (did not specify anything).Also I have some ASP applications running against this sql server with userid = SA and password as blank.Now I realized the problem of using ‘sa’ and blank password and want to disable the “sa” login and use specific login’s created and be used by people who want to connect and by the front-end applications.Please let me know how to disable / delete the ‘SA’ login. First of all can I delete the ‘sa’ login and is it safe to do so? BTW, When I tried to delete the ‘sa’ login in the “Enterprise Manager”. On the right click there is no option to ‘delete’, where as for other logins I can see the ‘delete’ option in the right click.Lastly, Do I have to uninstall and reinstall SQL Server 2k to be able to disable the SA login? This option is not easy for me as the website is in production? Is there any easy way to achieve this?Please make me clear about this as I am little confused about the while thing.Thanks,Shyam. |
|
|
|
|
|
Work Around to 'SA' Login and BLANK password