Automatically start sql server 2000 service on Windows 7 pro pc
Posted on 2010-11-22
My client has 4 old pc’s running Windows 2000 pro in a peer-to peer network. One of the pc’s died. It is to be replaced by a machine running Windows 7 Pro. There is an old application which uses SQL server 2000 personal edition .
I have read posts on Experts Exchange stating as long as SQL Server uses its own logins and not Windows authentication then SQL Server 2000 can be installed onto Windows 7.
Other users have stated the SQL Server service will not start automatically when Windows 7 pro is rebooted.
1.) What commands must be put into a script file to enable the SQL Server service to be started ?
2.) What must be done to allow this script to run shortly after a reboot of the Windows 7 pc?