Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Link

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-18 : 08:24:35
Mala writes "Hi,

We have application and database server linked. From Application server I can open db's of database server.
But all of a sudden I am unable to open either Query Analyzer or Enterprise manager from database server.

We checked all the network utility options. Everything seems to be fine.

Can you please tell me what could be wrong and how can I enable it.

Thanks,
Mala"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-18 : 16:23:53
What is the error that you are getting?

Tara
Go to Top of Page

Mala
Starting Member

26 Posts

Posted - 2005-01-19 : 23:30:33
Hi ,

We are getting following error message

1)For SQL Server (In Enterprise Manager)
A connection could not established to TRANSDBSSRV.
Reason:SQL Server does not exist or access denied.
Connectionopen(connect())..
Please verify SQL Server is running and check your SQL Server registration properties (by right clicking on the TRANSDBSSRV node) and try again.
2)For Query Analyzer
Unable to conncet Server TRANSDBSSRV:
Server:Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.
Go to Top of Page
   

- Advertisement -