question

crazyCoolguy avatar image
crazyCoolguy asked

how to connect ssis connection in sql server?

when i'm trying to connect to ssis services in MSBI i got This Error Please Expalin Connecting to the Integration Services service on the computer "JAI" failed with the following error: "Access is denied." By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.
ssisssmsadministrationconnectivity
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

CirqueDeSQLeil avatar image CirqueDeSQLeil commented ·
What version of SQL Server? What OS? Are you logged into SQL Server with an account that has adequate permissions? Have you verified that the Integration Services Service is running?
1 Like 1 ·

1 Answer

·
raadee avatar image
raadee answered
Not sure what MSBI (bids?)is but you got to run it with administrative privileges. shift + right click, run as administrator. Same goes for management studio when you want to connect to Integration Services.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.