question

Fatherjack avatar image
Fatherjack asked

Do I trust the new installation?

I have just installed a new SQL 2008 instance beside my SQL 2005 instance on my production server and the install completed with a message saying it failed to complete successfully as the services could not be started.

Looking in AD, the domain account for SQLBrowser and the other services got locked out (may have been my mis-typing the pwd in the setup screen). I have unlocked the account and the services have started with no errors.

Will the install be reliable or should I uninstall and reinstall?

sql-server-2008installation
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

I see no reason why, based on a security issue, the installs should not have completed successfully. If there are no other errrors, you're good to go.

Of course, I'd still run DBCC on the databases and validate connectivity, that all the servers are running, etc. Paranoia in this situation is not a bad thing, even if you didn't have errors.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Ian Roke avatar image
Ian Roke answered

One way to test it if you can with a production server is reboot the machine and see if the services start correctly.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

The failure point was on starting the services. Since you were able to start the services, I would trust it. However, I typically reboot the server after an install anyway. Thus, a good final test would be to reboot the server and verify service startup.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.