sql server database access from Enterprose mgr 7.0

• rohitkaul_2000

  SSC Rookie

  Points: 25

  More actions

  December 17, 2001 at 5:28 am

  #64005

  Hi friends,

  Can anybody please tell me why I am not able to register a new SQL Server database which is on a server on the network.

  I can easily ping to the server but when I try connecting to it using the

  New Sql Server Registration option and choosing the sql server authentication option (thru user SA) i get a message saying Specified sql server not found.

  ConnectionOpen(CreateFile())

  The machine is on the network (cause i can ping to it).

  Also I can access it thru PC anywhere.

  Why can't i connect to it using the SQL Enterprise Mgr ?

  Any help will be deeply appreciated...!!

  Thanks in advance..!!

  \\Rohit

  
  Rohit Kaul

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734418

  More actions

  December 17, 2001 at 8:16 am

  #421176

  There are a few possibilties.

  Connecting over TCP/IP uses ports 1433 adn 1434 and 445 (I believe) for EM. Be sure these are not blocked.

  Be sure you have the same protocols setup on your machine (client network utility) and the server (server network utility).

  Steve Jones

  steve@dkranch.net