p*********r
发帖数: 1440 | 1 1 sql 2008 server and 1 sql 2005 server. need to create a linked server in
2008 for 2005.
i created a sql server user in both 2008 and 2005. on the security page i
used "Be made using this security context", remote login is the sql server
user i just created.
a domain user which is in a domain group, has read only access to 2008
server. the user gets an error when he tried to access the linked server
from 2008. the error is like this:
...
The EXECUTE permission was denied on the object 'xp_prop_oledb_provider',
database 'mssqlsystemresource', schema 'sys'. (Microsft SQL server, Error:
229)
I googled, and it seems i need to grand execute permission on 'xp_prop_oledb
_provider'. what I am not sure here is to whom I should grant the
permission, the sql server i just created or the domain user who tried to
access the linked server. i should run this statement on sql 2005 server,
correct?
thanks in advance. | p*********r
发帖数: 1440 | 2 figured it out myself. thanks.
in
【在 p*********r 的大作中提到】
: 1 sql 2008 server and 1 sql 2005 server. need to create a linked server in
: 2008 for 2005.
: i created a sql server user in both 2008 and 2005. on the security page i
: used "Be made using this security context", remote login is the sql server
: user i just created.
: a domain user which is in a domain group, has read only access to 2008
: server. the user gets an error when he tried to access the linked server
: from 2008. the error is like this:
: ...
: The EXECUTE permission was denied on the object 'xp_prop_oledb_provider',
| g***l
发帖数: 18555 | 3 BE MADE USING THIS SECURITY CONTEXT应该是SQL ACCOUNT，这个ACCOUNT要有ACCESS
另一个SERVER DATABASE的权限 |
|
