March 11, 2003 at 5:40 pm
Hello I have I question I editd the setup.ini of Microsoft SQL SERVER DESKTOP Engine, so that I can I have a SQL Authentication and I put a password also like this
[OPTIONS]
SECURITYMODE="SQL"
SAPASSWORD="XXXXX"
INSTANCENAME="MSDE2003"
but its not working it is still in Windows NT Authentication mode, by the way Im install the final version of MSDE that is included to the Vs.Net final beta. , can you help me on this ?
March 12, 2003 at 7:59 am
Use Enterprise Manager to make the change.
March 12, 2003 at 8:07 am
Allen_Cui,
MSDE doesn't have Enterprise Manager. It uses OSQL.
Sthealth,
Unfortunately I don't have the answer as I don't use MSDE...but I'm curious about it also so I'll post back if I find a solution.
_SQLBill
March 12, 2003 at 8:19 am
MSDE doesn't have EM but if you have other SQL Server installations, you should be able to use the EM for your MSDE.
Or change the following registry key with value 2 and restart SQL Server service.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode.
Edited by - Allen_Cui on 03/12/2003 08:27:56 AM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply