Can not make an odbc connection to sql2008 server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Johan Lijffijt

    Can not make an odbc connection to sql2008 server

    Hello,

    I am trying to make an odbc connection from a Windows XP pro Station to a Windows 2008 R2 Server with SQL 2008. When i do a command on the server "SQLCMD -L" i can see the server and the server instance of the SQL server so like:

    <SERVERNAME>
    <SERVERNAME>\SQ LEXPRESS

    Within the Server i can also make perfectly all odbc connections i want.

    Coming to the client, when i do there a command "SQLCMD -L"i only get to see the servername

    <SERVERNAME>

    But bot the instance. When i still try to make a connection to thsi server with an odbc connection i get a message like "Sql server does not exist or acces is denied" SQl server error 10060

    How can i make the instance available to the client?


    Johan
  • Sl1ver
    New Member
    • Mar 2009
    • 196

    #2
    What exactly are you trying to do? connect from the client to the main server?

    Comment

    Working...