Does anyone have an (almost) foolproof instruction sheet for instaling MSDE? It should be installed using SQL Server security. Microsoft's instructions are not always successful and when it does work, Integrated Security seems to be the default. Changing this requires going through hoops and involves registry changes.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSDE
- Thread starter obrienb
- Start date
You can change the type of security using SQL-DMO, with some frontend app using this code:
oSQLApp = CreateObject('SQLDMO.Application')
oServer = osqlapp.SQLServers(1)
oserver.IntegratedSecurity.SecurityMode = 1
&& 1 -> Just Windows , 2-> Win & SQL, 0-> Only SQL
This works without working with the registry.
oSQLApp = CreateObject('SQLDMO.Application')
oServer = osqlapp.SQLServers(1)
oserver.IntegratedSecurity.SecurityMode = 1
&& 1 -> Just Windows , 2-> Win & SQL, 0-> Only SQL
This works without working with the registry.
- Status
Similar threads
- Locked
- Question