October 7, 2016 at 10:40 am
I've just installed SQL Server 2014 Developer Edition and am now trying to connect to SQL Server Integration Services (SSIS) using SQL Server Management Studio (SSMS), however, I'm not able to.
Here's the error message I get:
"Connecting to Integration Services on the computer "mycomputername" 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."
The weird thing is I do have Administrative rights. I'm connecting using Windows Authentication from my personal laptop (used for testing and playing) and my account does have administrative rights.
Any ideas?
Couple extra notes:
1) My laptop has Windows 8.1 Standard Edition on it.
2) I'm connecting locally - not remotely.
3) I'm able to connect to the Database Engine and Analysis Services just fine.
4) I'm also able to create packages in Visual Studio just fine.
October 7, 2016 at 11:45 am
Try doing a Run As Administrator to open SSMS.
It's not the same as being in the Administrators group.
Sue
October 7, 2016 at 12:51 pm
Whew! Thank you very much for that. That did it. Didn't know there was a difference. I'll have to research that to understand it. Thanks!
October 7, 2016 at 1:05 pm
Thanks for posting back - glad it worked out.
Most people don't know there is a difference. I stumbled upon some MS blogs that went through it years back. Could only find this link in my bookmarks: https://technet.microsoft.com/en-us/library/2006.03.windowsconfidential.aspx
There are other articles but the above one is good to note as it's an issue sometimes when moving around files, the permissions get lost and people have problems reassigning the permissions.
Sue
October 7, 2016 at 4:50 pm
Great. I appreciate the info. I'll take a look. Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply