Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Access??? Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 7:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
I'm getting the access denied error. I went into DCOM config and I don't see anything near "Microsoft SQL Server Integration Services 11.0" listed. I went to try and install it thinking I forgot it, but according to the SQL installer, SSIS is installed. Version is 2008 R2. What am I doing wrong?

Edit: Crap this should have gone in the Integration Services forum... Oh well.
Post #1386897
Posted Tuesday, November 20, 2012 7:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 5,231, Visits: 5,101
Microsoft SQL Server Integration Services 11.0 is SQL 2012.

I take it your looking at the MSDN article on Connecting to a Remote Integration Services Server?

If so it looks like you've not changed the page to the correct version of SQL for what your running.

http://msdn.microsoft.com/en-us/library/aa337083%28v=sql.105%29.aspx





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386908
Posted Tuesday, November 20, 2012 7:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
Still getting access denied, and yes I restarted services.
Post #1386913
Posted Tuesday, November 20, 2012 7:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 5,231, Visits: 5,101
Any firewalls between the clients and the servers? Are you connecting to a cluster?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386918
Posted Tuesday, November 20, 2012 7:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
No cluster, and I'm trying to connect locally.

Do I need to configure something in the SQL Server Configuration Manager?
Post #1386919
Posted Tuesday, November 20, 2012 7:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 5,231, Visits: 5,101
Can you post a screen shot of the error?

I've never had this issue so would be good to see what you see in case its something else other than DCOM.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386922
Posted Tuesday, November 20, 2012 8:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
It's just an access denied error. "Connecting to the Integration Services service on this computer "servernamecensored" failed with the following error: Access is denied."
Post #1386935
Posted Tuesday, November 20, 2012 8:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 5,231, Visits: 5,101
Have you tried this one
http://sqlbuzz.wordpress.com/2011/12/07/connecting-to-the-integration-services-service-on-the-computer-mirrorstand-failed-with-the-following-error-access-is-denied/

Might be that 2008 R2 creates the MsDTSServer100 DCOM object and 2008 creates the MsDTSServer as I have both in my DCOM as I have both versions of SQL installed.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386938
Posted Tuesday, November 20, 2012 8:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
I did all that, including the DCOM local group. What's even stranger is that the AD group I am part of is local admin on this server. I'm missing something really stupid.
Post #1386942
Posted Tuesday, November 20, 2012 8:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 5,231, Visits: 5,101
Strange then as if your an admin you shouldn't need to mess with DCOM.

Will keep digging once I have a spare moment here and there but as never running into this issue myself unsure on the next steps to take.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386949
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse