MSDE users and passwords
-
I'm using ADO to interface with MSDE (Microsoft SQL Server 7) but I still have some doubts: 1. What the 'sa' UserID ? Can I use it from my app ? 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Thanks in advance.
-
I'm using ADO to interface with MSDE (Microsoft SQL Server 7) but I still have some doubts: 1. What the 'sa' UserID ? Can I use it from my app ? 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Thanks in advance.
Frankesk wrote: 1. What the 'sa' UserID ? Can I use it from my app ? Administrator. Don't use this for normal stuff, as it gives complete access to the database. e.g. create\delete databases, tables, etc. Equivelant of logging into the NT Machine as the local admin. Frankesk wrote: 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Well I don't know about the MSDE extact, as I usually develop on a copy of SQL Server with the Enterprise Manager - which is a GUI front end with wizards etc to create new DB's, tables, Views all the way to new users and roles. Otherwise you may have to do it programatically. On Windows 2000, goto the Control Panel, Admin Tools, Server Extensions Admin. From the menu Add\Remove, and then add from the botton of the dialog. Choose Micorsoft Enterprise Manager. From there you can then administor the Server though the MMC pluggin. Hope this helps, Giles
-
Frankesk wrote: 1. What the 'sa' UserID ? Can I use it from my app ? Administrator. Don't use this for normal stuff, as it gives complete access to the database. e.g. create\delete databases, tables, etc. Equivelant of logging into the NT Machine as the local admin. Frankesk wrote: 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Well I don't know about the MSDE extact, as I usually develop on a copy of SQL Server with the Enterprise Manager - which is a GUI front end with wizards etc to create new DB's, tables, Views all the way to new users and roles. Otherwise you may have to do it programatically. On Windows 2000, goto the Control Panel, Admin Tools, Server Extensions Admin. From the menu Add\Remove, and then add from the botton of the dialog. Choose Micorsoft Enterprise Manager. From there you can then administor the Server though the MMC pluggin. Hope this helps, Giles
-
I'm using ADO to interface with MSDE (Microsoft SQL Server 7) but I still have some doubts: 1. What the 'sa' UserID ? Can I use it from my app ? 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Thanks in advance.
Frankesk wrote: 1. What the 'sa' UserID ? Can I use it from my app ? This is the administrator account in SQL Server. You can use this if you want, but its probably best to create a user with the minimum set of access rights required to do what you want. Frankesk wrote: 2. How can I create new accounts (userid+password) for the SQL Servers ? (no NT accounts) I have scanned all options of the "osql.exe" utility but I have found nothing. Have a look at sp_adduser and sp_addlogin in the BOL. Dave