What are the challenges you face when working across database platforms? Take the survey
Options

Problems connecting to (local) server

ApocApoc Posts: 37
edited January 31, 2006 10:20AM in SQL Compare Previous Versions
Hi,

when trying to connect to the "(local)" SQL 2005 server, the connection fails with the message "SQL server does not exist or access denied".

But when using the machine name instead, the Windows Authentication works and the list of databases is populated.

Thomas
Thomas Stensitzki
MCITP, MCTS, MCSA, MCSA: Messaging
http://www.icomcept.de
http://www.sf-tools.net

Comments

  • Options
    Ok, everythings fine, when you setup the TCP/IP library for SQL server correctly :)

    Thomas
    Thomas Stensitzki
    MCITP, MCTS, MCSA, MCSA: Messaging
    http://www.icomcept.de
    http://www.sf-tools.net
  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello,

    FYI using Computer Management to move the TCP/IP network library to the top of the list also helps quite a lot with network problems when connecting to SQL Server 2005. The named pipes driver isn't nearly as reliable when used with SQL Compare. Sometimes the connections break in the middle of a compare with 'internal network fatal error' and other strangeness.
This discussion has been closed.