February 24, 2012 at 11:37 am
I have a user trying to connecting from the outside.
He is not VPN into a machine, he is just using a tool to get through the firewall.
When he expand on Catalogs he does not any nodes for Tables & Views.
Sounds like a permission issue.
Any ideas?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 24, 2012 at 11:50 am
I did the following and he is good to go:
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO LOGIN;
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 24, 2012 at 12:36 pm
Wow, that is obscure.. Good to know though..
CEWII
February 24, 2012 at 2:15 pm
I forgot to mention that you must CREATE a User in the MASTER Database.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply