<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Linked server permissions issue
64 posts, Page 1 of 7
1
2
3
4
5
»
»»
Linked server permissions issue
Rate Topic
Display Mode
Topic Options
Author
Message
Sapen
Sapen
Posted Tuesday, November 29, 2011 2:31 PM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
Hello everyone,
Hope all is well.
I have recently setup a linked server from sql server 2005 to mas90 providex database and it works fine. I am able to fetch records from the providex database by issuing a select statement from the server where I have the mas90 and sql server existing. But I am getting an error when I connect to that SQL server remotely from my laptop and issue the same select statement. I have pasted the error below:
OLE DB provider "MSDASQL" for linked server "link" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible"
I need your inputs if anyone has come accross with such a scenario. I am using the same windows authentication to connect to the DB Server from SSMS from my laptop instead of doing a RDP. It works from RDP but not from my laptop.
Thank you.
Post #1213570
Sapen
Sapen
Posted Wednesday, November 30, 2011 8:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
Any updates please.
Post #1214019
SQLKnowItAll
SQLKnowItAll
Posted Wednesday, November 30, 2011 9:03 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 2,613,
Visits: 3,128
Can you list what your current settings are for the server options on that linked server?
Thanks,
Jared
Thanks,
Jared
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Post #1214028
Sapen
Sapen
Posted Wednesday, November 30, 2011 9:37 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
I have
Data Access set to True
Use Remote Collation set to True
and all the others set to False
with a blank in the collation name and 0's for Connection timeout and query timeout
I am having the default settings I believe.
Post #1214065
SQLKnowItAll
SQLKnowItAll
Posted Wednesday, November 30, 2011 9:42 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 2,613,
Visits: 3,128
Hmm... Try enabling RPC out. Also, is the login from your SSMS on your machine the same that you use to login to SSMS on the server?
Jared
Thanks,
Jared
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Post #1214067
Sapen
Sapen
Posted Wednesday, November 30, 2011 9:50 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
Thanks for you inputs Jared.
I have just enabled the RPC out and executed my query and I end up getting the below error:
OLE DB provider "MSDASQL" for linked server "MAS90_LINK" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "AR_Customer" from OLE DB provider "MSDASQL" for linked server "MAS90_LINK".
Yes I am the SYSADMIN and I am using the same windows authentication to connect to the SQLServer with linked server from my laptop through SSMS(from where I am getting the error) and if I do an RDP to the remote Server and connect then I am able to fetch the records. Although I am not able to view the tables from my laptop as well as actual server under the catalogs of the linked server(MAS90_Link).
Post #1214075
SQLKnowItAll
SQLKnowItAll
Posted Wednesday, November 30, 2011 9:59 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 2,613,
Visits: 3,128
Sapen (11/30/2011)
Thanks for you inputs Jared.
I have just enabled the RPC out and executed my query and I end up getting the below error:
OLE DB provider "MSDASQL" for linked server "MAS90_LINK" returned message "[ProvideX][ODBC Driver][FILEIO]Table is not accessible".
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "AR_Customer" from OLE DB provider "MSDASQL" for linked server "MAS90_LINK".
Yes I am the SYSADMIN and I am using the same windows authentication to connect to the SQLServer with linked server from my laptop through SSMS(from where I am getting the error) and if I do an RDP to the remote Server and connect then I am able to fetch the records. Although I am not able to view the tables from my laptop as well as actual server under the catalogs of the linked server(MAS90_Link).
Try also enabling RPC and make sure the distributed transaction option is TRUE as well. I can't find to much info on these, but I believe that RPC may have something to do with remotely logging into the instance and then accessing a linked server.
Jared
Thanks,
Jared
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Post #1214087
Sapen
Sapen
Posted Wednesday, November 30, 2011 10:09 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
Forgot the Mention that I am using SQL Server 2005 Standard Edition. I have enabled the RPC but still ended up getting the same error. I dont see the distributed transaction at the server options but I do see it at the sqlserver properties unchecked "Requires distributed transaction for server-to-server communication".
I just enabled it and ran my queries and ended up with same error again.
Post #1214098
SQLKnowItAll
SQLKnowItAll
Posted Wednesday, November 30, 2011 10:11 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 2,613,
Visits: 3,128
Sapen (11/30/2011)
Forgot the Mention that I am using SQL Server 2005 Standard Edition. I have enabled the RPC but still ended up getting the same error. I dont see the distributed transaction at the server options but I do see it at the sqlserver properties unchecked "Requires distributed transaction for server-to-server communication".
I just enabled it and ran my queries and ended up with same error again.
Hmm... What credentials are you passing to the linked server? Are you impersonating? Sending explicit creds?
Jared
Thanks,
Jared
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Post #1214103
Sapen
Sapen
Posted Wednesday, November 30, 2011 10:16 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 7:49 AM
Points: 1,281,
Visits: 1,564
I havent setup anything in the security part of the linked server properties. But in the provider string, I am using the username and password to connect to the mas90 providex database.
Post #1214105
« Prev Topic
|
Next Topic »
64 posts, Page 1 of 7
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
