Wednesday, March 21, 2012

Deployment Error

After creating a my project which has several dts packages.

I want to deploy and place them in different sql servers to run automatically.

I do the following:

After building my project.I select project ->properties ->deployment utility->i set create deployment to true.

Then within deployment folder i double click .projectdeploymentmanifest file

where package installation i select sql server instead of file system.

and i get the following error.

TITLE: Package Installation Wizard

Could not save the package "C:\Program Files\Microsoft SQL Server\SSIS\bin\Deployment\Procedure.dtsx" to SQL Server "SQL-DEV".


ADDITIONAL INFORMATION:

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.

BUTTONS:

OK

It would be great if some one guides me with this.Is this anything to deal with security.please let me know

Open up Management Studio and try to connect to "Integration Services" on SQL-DEV.|||

It says Access Denied.

Do i need to be under sysadmin role to do this?

Please let me know.

Thanks

|||

See this link from my blog:

http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/

|||

I have worked with the steps from this site.I still have the same problem.

Access denied when i connect to integration services on a particular server from i local machine.

Do i have any other options?

|||The answers are all right there, but need to be done on the server, not the local machine.|||

Thanks,I was working on my local machine instead of server.

No comments:

Post a Comment