Wednesday, March 21, 2012

remote sql server is the same as local in em

Hello,
In EM under node Remote Servers I see the remote server with the same name
as a local. For example my server name is WP200 and remote server shows
WP200. It is sql 2000. The RCP is checked and map all logins to different
logins selected but there is nothing in the selection grid.
I can't figure out for what purpose it was set up this way.
Please help.
thank you very much.
JanHi Jan
Your local server will appear under the remote servers, if it doesn't then
@.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
BOL and the @.LOCAL parameter may help!
John
"Jan" wrote:

> Hello,
> In EM under node Remote Servers I see the remote server with the same name
> as a local. For example my server name is WP200 and remote server shows
> WP200. It is sql 2000. The RCP is checked and map all logins to different
> logins selected but there is nothing in the selection grid.
> I can't figure out for what purpose it was set up this way.
> Please help.
> thank you very much.
> Jan|||For remote server access to work, the 'remote access' configuration option,
which controls logins from remote servers, must be set to 1 can be done usin
g
sp_configure
refer Configuring Remote Servers chapter in BOL
Amol Lembhe
"John Bell" wrote:
[vbcol=seagreen]
> Hi Jan
> Your local server will appear under the remote servers, if it doesn't then
> @.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
> BOL and the @.LOCAL parameter may help!
> John
> "Jan" wrote:
>

No comments:

Post a Comment