RE: why can't I connect to server from a remote machie?
From: mike (anonymous_at_discussions.microsoft.com)
Date: 01/31/04
- Next message: Kevin McDonnell [MSFT]: "RE: why can't I connect to server from a remote machie?"
- Previous message: Joe Vandenabee: "RE: Security on SQL Jobs"
- In reply to: Kevin McDonnell [MSFT]: "RE: why can't I connect to server from a remote machie?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 30 Jan 2004 17:21:23 -0800
I looked int he event log and sure enough it showed that
swl server was not coming up on a tcp port, even though it
was configured to do so. I looked at other messages in the
event log and ran across one that said TCP connectivity
would be disabled because of some security thing I think,
and it said to downlaod the latest SP, so I did, and that
soleved the problem.
Thanks for your help,
Mike
>-----Original Message-----
>Hi Mike,
> This error is the key:
>Net-Library error 10061: ConnectionOpen (Connect()).
>
>This means that the server is not listening on TCP or
there is a firewall
>between your client and the machine that is blocking your
connection
>attempt.
>
>To verify that the server is listening on TCP:
>Check the NT Application Eventlog and/or SQL Errorlogs:
>
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 1/30/2004
>Time: 11:07:18 AM
>User: N/A
>Computer: TEST
>Description:
>19013 :
>SQL server listening on <IP Address Here> : 1433.
>
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>
- Next message: Kevin McDonnell [MSFT]: "RE: why can't I connect to server from a remote machie?"
- Previous message: Joe Vandenabee: "RE: Security on SQL Jobs"
- In reply to: Kevin McDonnell [MSFT]: "RE: why can't I connect to server from a remote machie?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|