Viewing 15 posts - 256 through 270 (of 360 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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 1, 2011 at 11:54 am
The value, minimum and value_in_use columns are 0's
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 1, 2011 at 9:27 am
configuration_idnamevalueminimummaximumvalue_in_usedescriptionis_dynamicis_advanced
16391Ad Hoc Distributed Queries0010Enable or disable Ad Hoc Distributed Queries11
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
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?...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 30, 2011 at 2:12 pm
Yes it does return 1.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 30, 2011 at 2:11 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?...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 30, 2011 at 1:43 pm
Viewing 15 posts - 256 through 270 (of 360 total)