Mssql

[Steve_FX]

I’m running a local MSSQL 2000 server and everything has worked fine until this week... when it suddenly stopped working and to fix it I had to reinstall the master database... which now allows the server to run.

My problem is however that I cannot login to the database using windows authentication mode... and when selecting new sql server registration within enterprise manager and then clicking on the browse feature nothing is returned as an active server.

Does anyone have any ideas as to how to resolve this?

For instance as I have reinstalled all the default databases do I have to reset default usernames, etc... and if so how... as you can see I’m lost... help?

Steve

[Steve_FX]

I’ve resolved the problem, when I copied the main databases across from my CDrom, these were original databases.... the installation however had been patched with various server updates... these updates not only change the installation environment they also update the database... hence my database was not the correct version (shall we say)...

To fix it all that was required was a complete uninstall and then a reinstall and patch application... its all working fine again now...

Thanks

Steve

PS – I believe I could now resolve this using the password tool located in Control Panel / Administration / Services...