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

SCOME - Setting Up Your Remote Servers - Part 2 Expand / Collapse
Author
Message
Posted Wednesday, July 1, 2009 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 10:43 AM
Points: 5, Visits: 71
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
Posted Wednesday, July 1, 2009 8:45 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, January 12, 2014 9:26 PM
Points: 68, Visits: 172
Have you followed the MSDTC instructions in the article?
Post #745466
Posted Wednesday, October 28, 2009 5:01 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, January 12, 2014 9:26 PM
Points: 68, Visits: 172
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
Posted Wednesday, May 19, 2010 12:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 12:52 PM
Points: 5, Visits: 105
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 »

Add to briefcase ««12

Permissions Expand / Collapse