changing the sa of MSDE

• Sthealth

  SSC Enthusiast

  Points: 115

  More actions

  March 11, 2003 at 5:40 pm

  #158972

  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 ?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 12, 2003 at 7:59 am

  #450866

  Use Enterprise Manager to make the change.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  March 12, 2003 at 8:07 am

  #450870

  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

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  March 12, 2003 at 8:19 am

  #450872

  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