Viewing 15 posts - 256 through 270 (of 359 total)
I don't think you should have to restart the service after that. I still think there is a permissions issue. Something in your domain is not interpreting the user the...
December 1, 2011 at 12:45 pm
No..I am not able to access any linked server unless I create the linked server connection directly on sql server installed on my laptop.
I am getting a little confused. You...
December 1, 2011 at 11:59 am
Sapen (12/1/2011)
The value, minimum and value_in_use columns are 0's
Well... You should start here:
sp_configure 'show advanced options', 1;
RECONFIGURE;
sp_configure 'Ad Hoc Distributed Queries', 1;
RECONFIGURE;
GO
Jared
Edited: Today @ 4:30:44 PM by p-nut
I just...
December 1, 2011 at 11:54 am
The value, minimum and value_in_use columns are 0's
December 1, 2011 at 9:27 am
configuration_idnamevalueminimummaximumvalue_in_usedescriptionis_dynamicis_advanced
16391Ad Hoc Distributed Queries0010Enable or disable Ad Hoc Distributed Queries11
December 1, 2011 at 9:26 am
I ask again, only because I cannot figure this out... Are you using the same SQL Server (windows auth) user to log into the database instance between the server and...
December 1, 2011 at 9:24 am
No..I am not able to access any linked server unless I create the linked server connection directly on sql server installed on my laptop.
December 1, 2011 at 8:47 am
MyDoggieJessie/Jared...Thanks for your inputs...but this is still an issue...I am doing my research to figure out how to make it work...please let me know incase if you come up with...
December 1, 2011 at 8:19 am
I removed the USER DSN now and tested it but with sql server 2008 R2 linked server connectivity and I get the same error.
I have the linked server setup to...
November 30, 2011 at 2:49 pm
I dont have 2005 on any other server. But I tested the linked server connectivity with 2008 R2 as well. I come up with same error when I try to...
November 30, 2011 at 2:46 pm
I can do that real quick but I am able to select the data from the DB server directly...does removing the user DSN be helpful?
November 30, 2011 at 2:28 pm
OH! Thought... Did you set up the DSN as a system DSN or a user dsn? I bet it has something to do with the DSN settings...
Jared
I had to...
November 30, 2011 at 2:22 pm
Randy Doub (11/30/2011)
In your linked server script you have @provstr=N'DSN=SOTAMAS90'
Is this a DSN that lives on the DB server?
And when you use your laptop, that DSN can't be found?...
November 30, 2011 at 2:12 pm
Sorry if I asked this already...but what's the version of your laptop SQL running? And are all 3 OS's 32-bit? I don't suppose your laptop is running 64-bit is it?...
November 30, 2011 at 1:43 pm
Viewing 15 posts - 256 through 270 (of 359 total)