NOt able to connect to sql server usinmg em2000

[muthukumar]

hi

iam not able to connect to any of the sql servers using em2000, just few days before i was able to connect to mssql4 and import data from access mdb, but for last 2 days iam unable to connect, this is the error iam getting

error desc : [dbnetlib] Connection open(connect()).]Sql Server does not exist or access denied.
Context: Error during intialization of the provider.

thanx

[Brangwyn]

Can you telnet to any of them?

telnet sqlserverFQDN 1433

You won't get a response other than a blank screen, but if you get a timeout then it's one of a couple of things most likely.

First try telnet with the full IP address if the FQDN doesn't work, if that doesn't work then your ISP or perhaps even a localfirewall may have recently blocked TCP port 1433.

I just quickly checked all via EM and telnet and I can log on ok so dont initially think anythings wrong with the servers. Which one in particular are you trying to connect too?

[muthukumar]

i am trying to connect to mssql4.

i don't know how to use telnet?? how can i use one?

[Carly]

You can run that command from the Windows Command prompt (Start -> Run -> type "cmd"). Type the command 'telnet sqlserverFQDN 1433' at the prompt.

[Craig_Smith]

open up a command prompt on your windows machine,, If you not sure where thats at,, goto start menu, run, cmd

Type the following in the window:

telnet mssql4.hsphere.cc 1433

you can replace hsphere.cc with your service domain.

when your done type quit to exit telnet

[muthukumar]

Originally Posted by Craig_Smith

open up a command prompt on your windows machine,, If you not sure where thats at,, goto start menu, run, cmd

Type the following in the window:

telnet mssql4.hsphere.cc 1433

you can replace hsphere.cc with your service domain.

when your done type quit to exit telnet

Oh plzzzz, i am not that illitrate that i don't know cmd. i did'nt know much about telnet, even though i used telnet once sometime back just for testing purpose's.

telnet mssql4.hsphere.cc 1433 is just giving me a blank screen after login, i hit enter and i get "conn lost to host"

telnet mssql4.hsphere.ccFQDN 1433

gives

Connecting To mssql4.hsphere.ccFQDN...Could not open a connection to host on port 1433 : Connect failed

[Brangwyn]

Oh plzzzz, i am not that illitrate that i don't know cmd

Craig & Carly were only trying to help I don't think that comments really required.

telnet mssql4.hsphere.ccFQDN 1433 will never work becuase the FQDN isn't required, thats an abbreviation for Fully Qualified Domain Name .. ie mysql4.hsphere.cc

You say

telnet mssql4.hsphere.cc 1433 is just giving me a blank screen after login

You shouldn't actually get any form of login screen when doing this (I certainly don't) just a blank screen if it's worked.

Still it's certainly sounds as if either your ISP or a local firewall is blocking the port, you'll probably need to email your ISP now and confirm with them whether they've been blocking any ports recently.

[zubin]

telnet mssql4.hsphere.cc 1433 works
ping mssql4.hsphere.cc works

.. but em still cannot connect ?

This may help on some Windows 95 or 98 machines:

1. Click Start, and then click Run.
2. In the Open box, type cliconfg.exe and press ENTER.
3. On the General tab of the SQL Server Client Network Utility, click Add.
4. In the Server Alias box, enter the name of the server that you want to connect to.
5. In the Network Libraries Option Group, select TCP/IP.
6. Click OK.
7. On the General tab of the SQL Server Client Network Utility, click Apply, and then click OK.

Connect now