I had an os drive failer and had to reinstall my Sql server 2000 database. I have all the data recovered but I cannot seem to connect to the database with anything other than enterprise manager. I can connect with ET from various machines in my network but if I try a connection string or try to use sql query analyzer to connect it says database does not exist or you do not have permision
I set up a user with access permision to everything.
I have Service pack 3 installed.
Does any one have any idea why this is not connecting?