Annoying issue with SSIS on SQL 2008 r2

Asked By 10 points N/A Posted on -
qa-featured

Hello!

I am facing an annoying issue with SSIS on SQL 2008 r2.

While I try and increase the MSDB directory I obtain the below fault: 

Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.Sqlserver.Management,Sdk.Sfc)

Additional Information:

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 2008 R2 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 instances name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

TCP Provider: No connection could be made because the target machine actively refused it. (MsDtsSrvr)

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 instances name is correct and if SQL Server is continued to allow remote connections. For more information see SQL Server Books Online.

TCP Provider: No connection could be made because the target machine actively refused t.

(Microsoft SQL Server Native (bert 10.0)

OK

I'm operating 1 DEFAULT example I'm applying the conventional NT AUTHORITY/NETWORK SERVICE account I've examined the MsDtsSrvr.ini.xml computer document to confirm the hosting server name is appropriate (directing to built-in case) I've re-booted the Incorporation service/sql broker solutions.

The only factor that has modified was that I set up a known as example but due to organization changes I removed it a couple of weeks ago (but cannot validate if it eliminated immediately after the uninstall). It would be very helpful for me if you can kindly suggest anything about the further steps that should be done. I am looking forward for your reply. I would like to thank you in advance for your time and help.

SHARE
Answered By 0 points N/A #144377

Annoying issue with SSIS on SQL 2008 r2

qa-featured

Well, the answer to this problem  is to use a file name as “MsDtsSrvr.ini.xml” which we can find in this location “%ProgramFiles%Microsoft SQL Server<90><100>DTSBinn”. If you open that file then it will look like this:

Here then is connection to the local machine will be used  i.e. name of the server. So keep in mind this vital information. So you have to specify SQL Server name Instance Name like <ServerName> SQL Server NameInstanceName </ServerName> OR If you installed SQL Server Cluster then it should look like <ServerName> SQL Server Virtual Server InstanceName</ServerName>.

We need absolutely some changes for each one which are specified in red in the image above, so keep that in mind because it’s very important.

Login/Register to Answer

Related Questions