SQL Server 2005 and Strong Passwords 1

[oppcos]

Hi,
We have a legacy app that was originally built on site but, of course, the source code disappeared long ago. Well wouldn't you know it but the sa username and password is hard coded into that app and it isn't very "strong". The SQL database is isolated however, so we aren't too worried about the mixed mode security.

We want to upgrade to SQL 2005 but we weren't able to use the old sa password. Is there a way, probably post installation, to force the sa password to be the one we need to get the legacy app to work?

Thanks!

 

[SQLBill]

Check ALTER LOGIN in the BOL for 2005.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

Yes you can alter the login to remove that requirement post install.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[oppcos]

Great, thanks a lot guys.