SQL 2008R2 - ODBC cannot connect

  • Hi,

    I just installed SQL SERVER 2008 R2 and trying to create an odbc connection to a database on that server. I am using the same server to create the odbc connection as the sql server is installed.

    I have set the server settings to allow remote connections.

    Have done this many times for earlier servers...

    Thanks

    Bill

  • Bill Maners (3/16/2012)


    Hi,

    I just installed SQL SERVER 2008 R2 and trying to create an odbc connection to a database on that server. I am using the same server to create the odbc connection as the sql server is installed.

    I have set the server settings to allow remote connections.

    Have done this many times for earlier servers...

    Thanks

    Bill

    1. Ensure SQL Server service is running.

    2. Ensure Browser service is running.

    3. Ensure you are specifying correct IPAddress/ServerName.

    4. If it is a named instance verify that you are specifying correct port number.


    Sujeet Singh

  • is the server an express instance , where remote connections are not enabled by default?

    is it the default instance or a named isntance, and is the SLq broswer service running?

    from a different server, can you connect to the new server via SSMS?

    what specific error do you get when you try to connect? that will tell us a lot.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • I also have sql 2008 installed on that server. I can still connect remotely to it.

    The name is e521/R2 and e521 (slq 2008).

    Allow remote connections is checked.

    TCP/IP, Named Pipes and SharedMemory are enabled.

    I do not the port nuimber to use...I am using Dynamic Determination of the port.

    All services are runinng.

    I cannot using SSMS locally but not remotely (using ssms for 2008)

    Thanks for the reply.

    Bill

  • First check the windows firewall. Disable it on the server, and then try to connect via SSMS from a remote machine. If it connect, you know you have to add the sql service to the allowed programs list. That's where i would look next.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Triple checked everything. Not sure what it was, but I am able to connect now.

    Thanks.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply