Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Connecting to SSIS and SSAS from Management studio - Access denied

Posted on 2015-02-04
9
Medium Priority
?
142 Views
Last Modified: 2016-02-18
I installed a new version (2008 to 2012) of SQL Server and have been having issues since the beginning. Its on Windows 212 Server VM and it has been causing problems with my permissions since day 1. I configured Mixed mode for authentication and when I open the Database Engine with 'sa' everything is fine. When I try to open SSIS from management studio it doesnt give me the option of opening in SQL auth just windows auth and it gives me an error saying "Access is denied". The same thing happens with SSAS. I wanted to import some of the SSIS packages over to the upgraded server but it seems like I dont have any pernmissions, even though my login is an Admin on the server. Can some let me know what to do cause this has been causing a big problem for me.

Thanks everyone
0
Comment
Question by:jknj72
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 40588780
hi

try to RIGHT click the ssdt and choose RUN AS ADMINISTRATOR
0
 

Author Comment

by:jknj72
ID: 40588830
ok I was able to figure out how to get SSIS to run but there is something definitely wrong with my userid login because I created a package and tried to kick it off from a SQL job and I am getting an access denied message. I use sa when I login to SQL management studio and when I do anything else with my logon I get an Accesss Denied? I need to get my user login squared away. Ive never had this issue before with permissions and Im worried that I did something wrong? How can I get my logon permissions fixed on this server for SQL , SSIS, SSAS etc...
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 40589401
follow this : https://msdn.microsoft.com/en-us/library/aa337562.aspx
maybe all you need is to fix permissions you have all he info in the same page
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:jknj72
ID: 40590919
I think I have narrowed it down to the service accounts needing access to the file system. I would just need to know which service accounts are for what processes. I know Ill have to add SQLSERVERAGENT to the folders that have the SSIS packages but are there other service ccounts like MSOLAP(?) or the Integrations services logon?
0
 

Author Comment

by:jknj72
ID: 40591301
I added my service accounts to these folders and I still cant run a package from the file system in a SQL job? I know there is still a problem and I want to fix these permission issues. Can anyone help me with this? When I first started I couldnt run anything on any drive other than C and it ended up being a Windows Server 2012 VM issue. My network guy fixed it but its still not fixed. Does anyone have any suggestions on where I can start and get this straightened out? Please help me!!!
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 2000 total points
ID: 40591363
hi

i had the same issues in VM under drive c: so i moved everything to drive D.
why wouldn't you move the package to a different drive?
0
 

Author Comment

by:jknj72
ID: 40591375
And you were able to run a SQL job poitning to the file system and not have to store the packages in SQL(MSDB?) and run those from there?
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 40591392
yes.
but lets test this and make sure this is the only issue you have.
:-)
0
 

Author Closing Comment

by:jknj72
ID: 40597128
Thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question