Home Forums SQL Server 2008 SQL Server 2008 Administration SQL 2008R2 - ODBC cannot connect RE: SQL 2008R2 - ODBC cannot connect

  • March 16, 2012 at 7:43 am

    #1460502

    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