May 31, 2012 at 5:34 pm
Hi, I'm having issues connecting remotely to a tcp-endpoint.
Locally on the server, I'm able to specific the ip and port with the login that has been granted permission:
CREATE ENDPOINT [MYENDPOINT]
STATE = STARTED
AS TCP
(LISTENER_PORT = MYPORT#, LISTENER_IP =ALL)
FOR TSQL() ;
GO
GRANT CONNECT ON ENDPOINT::[MYENDPOINT] to [testaccount] ;
However, when I'm connecting remote from my pc I'm receiving the following error:
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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10060&LinkId=20476
Basically,
I want to create two endpoints one set of users connecting via one port and another set connecting thru another.
June 1, 2012 at 4:07 am
Here is a link which should help you :
http://www.tobuku.com/docs/SQL%20Server%20Endpoint.pdf
Make sure the port number you precise in your create endpoint statement is open through SQL server configuration manager by default only 1433 is open. Add your port Number like this: 1433, 50022 if 50022 for example is your port number. Hope this helps you.
Cheers
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply