Showing posts with label navision. Show all posts
Showing posts with label navision. Show all posts

Wednesday, March 21, 2012

Problems Connecting Remotely - Integration Services

All,
We have a new install of SQL 2005 SP1 configured with a Navision
database restored and all client tests show no issues at moment. I am
able to connect remotely via SSMS (Management Studio) from my
workstation via TCP/IP. Also installed is Integration Services. I am
able connect to the service remotely to view the Stored Packages in the
File System but unable to view the MSDB contents. The error is below:
->Login timeout expired
An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failue may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.
TCP Provider: No connection could be made because the target machine
actively refused it. (Microsoft SQL Native Client)
No firewall exists on this server. Does anyone have insight to this
issue?
Thanks,
IanUpdate: Reviewing the Surface Area Configuration shows that Local and
remote connections are enabled for both TCP/IP and Named Pipes.
Connection via Named Pipes produced the similar error below:
->Login timeout expired
An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failue may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].
(Microsoft SQL Native Client)
Regards,
Iansql