April 19, 2012 at 3:22 pm
I created linked server using following script On my dev server:
EXEC sp_addlinkedserver
@server='prd'
,@provider='SQLNCLI'
,@srvproduct=''
Connection is fine.When I expand ‘Catalog’ folder from newly created Link server it shows databases that I have on my dev server.I can not see prd\databases.Any idea why?
Thank you
April 19, 2012 at 3:29 pm
might be permissions.
April 19, 2012 at 11:05 pm
Might sound lame, but check to see if there's some System DSN created (in Administrator Tools, ODBC)
Sounds like there might be a "prd" in that that's pointing to your "local" server...you can also try dropping and recreating it.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
April 20, 2012 at 3:24 am
is there any entry in your host file that points to your local?
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
April 20, 2012 at 12:55 pm
thank you guys for your responses.i found the problem.
DNS
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply