Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    14

    Unanswered: unable to connect remotely to MSSQL 2008

    Hello,
    am running MSSQL 2008 and cant seem to enable remote login with the IP address.

    I have enabled
    1. remote login on the sql instance ( under facets )
    2. added the server IP to surface configuation manager to the TCP/IP configurations and enabled it
    3. I have enabled remote login on windows firewall
    4. I also ran netstat /a to check listening ports and the port 4533 is open and appears in the list, but not under the server IP, but under the 127.0.0.1 Ip and host name.

    However when i try to login with the IPaddress,port number either directly through the server or remotely, I get this error message

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to xxx.xxx.xxx.xxx,4533.

    ------------------------------
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

    For help, click: Source: MSSQLServer ID: 10060 (SQL Server ) - Events And Errors Message Center: Message Details

    ------------------------------
    BUTTONS:

    OK

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Are there multiple instances on the server and, if so, have you turned on SQL Browser?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Dec 2005
    Posts
    14
    Yes there are 3 instances, the main instance hasnt got a problem which is on port 1433, the other is sql express on port 2433

    Yes the browser service is on

  4. #4
    Join Date
    Dec 2005
    Posts
    14
    I finally sorted the problem, after changing the connection parameters i didnt restart the server, i have done so and can connect now, thanks for your assistnace

    Ehi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •