Monday, March 19, 2012

servers

I have to link servers using sql server 2000 standard edition...
for anyone who has done this.... upon linking the servers using the other options radio button choice... is it suppose to show all the databases for that server under the drop down...
its only showing tables and views... which i get an error 7339 or error 17:

can anyone assist...or lead me in the right direction....
thanks,
jonathanhttp://support.microsoft.com/kb/814398
http://support.microsoft.com/default.aspx/kb/241267
If you google on error 7399 you would get relevant forum posts too.|||I resolved the issue|||How ?|||permissions on the standy server did not match or map to the prod box.....
under the security tab i changed the option being made using this security context to begin made using the login's current security context|||ahhhh...yes.

The ole' security issue...

No comments:

Post a Comment