February 20, 2014 at 2:46 pm
Hello - I have searched for an answer to this question but have had no success so far.
I have created a linked server on my development machine (SQL Server 2012) in order to retrieve data from the production machine (SQL Server 2012). The connection tests ok and the database displays under Catalogs. However, no tables are displayed under that catalog except the system tables. I have admin permissions on both machines.
I'm not sure what additional information is needed to help with this problem.
Thanks in advance - Kathy
February 20, 2014 at 2:52 pm
Just wondering but when you created the linked server did you pass the sa/sa password for the username/password for the connection to the production server, small things like that could be the issue...other than that I would think permissions but you already said you were admin on both environments
February 20, 2014 at 3:06 pm
stormsentinelcammy (2/20/2014)
Just wondering but when you created the linked server did you pass the sa/sa password for the username/password for the connection to the production server, small things like that could be the issue...other than that I would think permissions but you already said you were admin on both environments
Thanks for the quick reply. No, I didn't pass any passwords. The thing that puzzles me is that I can see the database name, but no tables. So it appears to find the database, but nothing else.
February 20, 2014 at 3:22 pm
To confirm, you're sa/dbo on production with your NT login?
Go to security in the linked server. What is the default setting for a login not defined? Is it set to be made without using a security context? If so, swap it to be made using the login's current security context.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 20, 2014 at 3:34 pm
Evil Kraig F (2/20/2014)
To confirm, you're sa/dbo on production with your NT login?Go to security in the linked server. What is the default setting for a login not defined? Is it set to be made without using a security context? If so, swap it to be made using the login's current security context.
I set the default setting to be 'login's current security context' and refreshed, but no change.
February 20, 2014 at 4:00 pm
This may sound silly but when you login to the target server with the login you're logged into your local as, and look at the database, you can see tables/procs/etc, right?
This almost always comes back to a security setting of some form, thus why I'm pushing on that side of the issue.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 20, 2014 at 4:04 pm
Evil Kraig F (2/20/2014)
This may sound silly but when you login to the target server with the login you're logged into your local as, and look at the database, you can see tables/procs/etc, right?This almost always comes back to a security setting of some form, thus why I'm pushing on that side of the issue.
Right. I can see tables, etc.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply