SCOME - Setting Up Your Remote Servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Drew Salem » SCOME - Setting Up Your Remote Servers - Part...

14 posts, Page 2 of 2

««1 2

SCOME - Setting Up Your Remote Servers - Part 2

Rate Topic

Display Mode

Topic Options

Author

Message

sean.reece

Posted Wednesday, July 01, 2009 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 13, 2012 7:22 AM
Points: 4, Visits: 70

Drew...

I am creating a linked server as Using SSMS.

I am cautiously only adding one linked server at a time.

I call it MonitorTest and its a SQL Server.

On the Security tab, I add a Local SQL login and as the Remote User I specify a SQL Admin Account (windows account) that has all the necessary permissions. I specify that connections will not be made for logins not defined.

On the Server Options page, I specify the True values for RPC and RPC Out.

I get the SQL Server error:-
'The linked server has been created but failed a connection test......
Error 7416 Access to the remote server is denied because no lohin-mapping exists...)

Post #745462

Drew Salem

Posted Wednesday, July 01, 2009 8:45 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 11:32 PM
Points: 68, Visits: 169

Have you followed the MSDTC instructions in the article?

Post #745466

Drew Salem

Posted Wednesday, October 28, 2009 5:01 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, September 26, 2012 11:32 PM
Points: 68, Visits: 169

For anyone interested, I've uploaded a demo of an application that I have developed primarly using the SCOME technique. It can be viewed here: http://www.sqlservermonitor.com/

If you have any questions regarding a particular report, please feel free to ask.

Drew

Post #810419

jol1185

Posted Wednesday, May 19, 2010 12:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, February 17, 2013 9:03 PM
Points: 4, Visits: 68

Hi,

What does this script do?

grant execute on xp_prop_oledb_provider to [User_ID]

I'm currently encountering this error and nto quite sure if this is the only to resolve this error: "Execute permission denied on object 'xp_prop_oledb_provider ', database 'mssqlsystemresource', schema 'sys'"

Is granting execute permission to this extended sp will just grant the user to show the catalogs under there linked server? I'm afraid i will grant them other permission other that what the user and application's linked server should be doing..

Thanks for your inputs! :)

Post #924590

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions