odbc connection failed

• J Scott-419766

  Old Hand

  Points: 370

  More actions

  July 17, 2007 at 9:42 am

  #174506

  All, I have SQL 2005 on a virtual server. I have an access frontend and SQL backend. I need users to test the database I am working on. I gave the permissions to access the database. Now, I am trying to set up the odbc connection but I get an error:

  Connection Failed:

  SQLSTATE: '01000'

  SQL Server Error: 233

  [Microsoft] [ODBC SQL server driver][DBNETLIB]Connection open (PreLoginHandshake())

  Connection failed:

  SQLState: '08001'

  SQL Server error: 11

  [Microsoft] [ODBC SQL server driver][DBNETLIB]General Network error. Chcek your network documentation

  Is there something am missing because this is a virtual server? Is it considered a remote connection and I need to do something else that am not aware of? Thanks

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 24, 2007 at 7:34 am

  #721901

  Any firewall, are you able to connect to the remote server using client machine

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com