December 31, 2014 at 8:08 am
SQL 2012 - While Importing a package to msdb, i am getting below error. SQL is in cluster. I tried changing the xml file to point to node name, servername. Nothing worked out.Any help is appreaciated.
TITLE: Import Package
------------------------------
The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in SQL Server 2012 Books Online.
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. (MsDtsSrvr)
December 31, 2014 at 9:02 am
When saving the package to SQL Server, did you specify the entire SQL instance name?
Ken
January 6, 2015 at 4:52 am
Yes, I tried giving the instance name and as well as the server name. Error remains the same.
January 31, 2015 at 2:20 pm
I am still having the same issue and error. Anybody has any ideas how to resolve this?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply