can only connect to DB through ET nothing else will work

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?

Kelly
LVL 2
unreal400Asked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
ET?  You mean EM?

Sounds like maybe your authentication method got switched (some of the EMs work because they have a different method).  Did you verify your SQL Server was installed with the same authentication method and using the same startup accounts as before?
0
 
arbertCommented:
Also, close some of your 9open questions....
0
 
jchopdeCommented:
Use the Client Network Utility to specify an alias for the server and see if you can connect via SQL QA to this alias.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.