October 10, 2011 at 5:12 pm
I am trying to use SSMS to connect to an Integration Services server. We have only one domain and every user and server are on that domain. When I start SSMS on my local machine and then try to connect to the Integration Services server (which is NOT on my local machine, but on the same domain), I get the following error:
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
A security package specific error occurred. (Exception from HRESULT: 0x80070721) (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
However, when I use Remote Desktop Connection (RDC) to run SSMS on the same box the Integration Services server is on, I do not get any errors, even if I use my same Windows login.
Does anyone know what my problem could be?
October 11, 2011 at 9:30 am
Are you using the same version of the tools on the remote machine? I have seen this while trying to use SSMS from SQL 2008 to try and connect to a SQL 2005 SSIS server. If you had gotten access denied I might have said its a DCOM problem but you got a fail. The other thought I had was firewall issue.
CEWII
October 11, 2011 at 10:41 am
On local machine:
Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer8.0.6001.18702
Microsoft .NET Framework2.0.50727.3623
Operating System5.1.2600
On remote machine:
Microsoft SQL Server Management Studio10.50.2500.0
Microsoft Analysis Services Client Tools10.50.2500.0
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 5.0 6.0
Microsoft Internet Explorer8.0.7601.17514
Microsoft .NET Framework2.0.50727.5446
Operating System6.1.7601
Do you think the version differences are the problem?
October 11, 2011 at 1:37 pm
imani_technology (10/11/2011)
On local machine:Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
On remote machine:
Microsoft SQL Server Management Studio10.50.2500.0
Microsoft Analysis Services Client Tools10.50.2500.0
Do you think the version differences are the problem?
Yes, based on the version on the remote machine it has SQL 2008R2 with SP1. On your local machine you are using the last Release Candidate for SQL 2008. SQL doesn't like to connect to newer versions from older versions. You need to upgrade your local machine.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply