SQLTeam.com | Weblogs | Forums

Connection Error


#1

Though I have installed Integration Services on 2012 Installation I could not get perhaps very basic Error.

Connecting to the Integration Services service on this computer 'xxxxxxx' failed with the following error "Access is Denied'.

This is on Stand Alone Machine.

Thanks


#2

Hi @pdset,

Right click and run SSMS as an Administrator.

Hope it will helps.

Thanks.


#3

Thanks Jai, I have tried connecting using the Server/InstanceName in the Login for COnnect to Server Window but still not working.

Any finer tips Further.


#4

Try this: http://www.sqlservercentral.com/blogs/robert_davis/2008/12/11/How-Do-I-Configure-SSIS-to-Work-With-a-Named-Instance/


#5

Thanks All for your Support I will try now,


#6

Check the admin rights on installed SQL Server

1. Close your SQL Server Management Studio (SSMS).

2. Open SSMS by right clicking Run as Administrator and then try to login to Integration Services.

If it doesn't work then double check if your account has admin rights on installed SQL Server.