When you find yourself unable to log into your Microsoft SQL database - first check that the service is running. If the service is not running, then you might have a corrupt MASTER system database. So then you ask... How do I fix that?
In MSSQL 2000, the task is a bit different because there is a utility in the binn folder that is not present in MSSQL 2005 or greater. To fix/rebuild the master system database, one has to go through the setup process instead.
I've explained how to do this with a command-line command at my www.enkognedo.com site. Just visit there and you will find what I had to do, why most of the on-line resources miss the target a bit, and a resource link to Microsoft that gives more detail.
Here is the link: http://bit.ly/diWPv5
No comments:
Post a Comment