August 21, 2012 at 7:08 am
Hello,
i tried to connect to my ssis Server, running on a Windows Server 2008 R2.
I can start the services and connect to the ssis server by using the management Studio on the Server. But if i open "Stored Packages - MSDB" i get an error after a while:
Failed to retrieve data for this request.
Same if i try to connect by using my local Management Studio or Deploy a SSIS Package by Visual Studio wizzard.
TITLE: SQL Server Integration Services
------------------------------
Failed to connect to server . (Microsoft.SqlServer.ConnectionInfo)
------------------------------
ADDITIONAL INFORMATION:
Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server. Der Server wurde nicht gefunden, oder auf ihn kann nicht zugegriffen werden. Überprüfen Sie, ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zulässt. (provider: Named Pipes Provider, error: 40 - Verbindung mit SQL Server konnte nicht geöffnet werden) (Microsoft SQL Server, Error: 2)
Named pipes are activated, TCP too.
August 21, 2012 at 7:19 am
Could be to do with your config file. Have a look at this:
http://msdn.microsoft.com/en-us/library/ms137789.aspx
John
August 21, 2012 at 7:26 am
Hi John,
i have changed the setting file and inserted my server name, but without success.
August 21, 2012 at 7:37 am
Did you restart the Integration Services service after making the change? Is the SQL Browser service running? Do you have a named instance, or a default instance? Does SQL Server listen on a non-default port? Do you have any other instances on the same server? Is the config file in the default location, or have you moved it? If you're able to post the contents of the config file, that would help. Doesn't matter if you change the name of the server to protect the innocent.
John
August 21, 2012 at 7:42 am
Did you restart the Integration Services service after making the change? Is the SQL Browser service running? Do you have a named instance, or a default instance? Does SQL Server listen on a non-default port? Do you have any other instances on the same server? Is the config file in the default location, or have you moved it? If you're able to post the contents of the config file, that would help. Doesn't matter if you change the name of the server to protect the innocent.
Yes, i have restartet the SSIS Service.
Yes, is up and running.
Default instance, no named and no other instances are running on this server. Only SSIS 2012 and SQL 2012
Default Ports and location of config file.
The only change i have made is the big marked:
<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>SQLSERVERNAME</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply