Install database on existing MSDE server with unknown SA password? -- sql server msde

Jim K
8/16/2004 11:31:24 AM

Question regarding the MSDE SP3a install process...

What happens if I attempt to install MSDE on a server that already has MSDE
installed and the SA password has been changed to an unknown password? Can
I still install an instance for my database without knowing the SA password?
If not, how can I get around this issue?

I can see my app/database being installed at a customers site that already
has a version of MSDE for a different application they have already
installed and are using.

Thanks,
Jim K.

Aaron [SQL Server MVP]
8/16/2004 12:36:31 PM

You should be able to install using Windows authentication, assuming you
know the password for an administrator on the box.

With that, you can also reset the sa password for an existing instance using
sp_password.

--
http://www.aspfaq.com/
(Reverse address to reply.)

[quoted text, click to view]

sql server msde : Install database on existing MSDE server with unknown SA password?