Viewing 15 posts - 271 through 285 (of 360 total)
I gave you a wrong version for the sql server..please find the correct ones below
2. What versin of SQL Server is the source server?
Linked server is set up of sql...
“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:33 pm
1. Can you script out your linked server creation and post the TSQL here?
/****** Object: LinkedServer [MAS90_LINK] Script Date: 11/30/2011 15:26:01 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'MAS90_LINK',...
“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:30 pm
I am not much familiar with adding users to the mas90 providex database. I will look for resources that would help me with it.
But I just created a login on...
“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 11:59 am
When I say remote connection I am using SSMS to connect to DB Server from my laptop instead of connecting from the SSMS from the DB Server directly. I am...
“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 10:39 am
I just used the same username and password that I am using in the provider string in "Be made using this security context". Still no luck.
“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 10:25 am
So should these credentials be added to the sql server too?
“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 10:22 am
I have tried running the queries both the ways and still no luck
SELECT count(*) FROM MAS90_LINK...AR_Customer
SELECT * FROM OPENQUERY(MAS90_LINK, 'SELECT count(*) FROM AR_Customer')
“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 10:21 am
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...
“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 10:16 am
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...
“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 10:09 am
If you want use the profiler then the below blog might be helpful too.
http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/
“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 10:02 am
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"...
“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 9:50 am
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...
“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 9:37 am
Any updates please.
“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 8:57 am
The thing is I am able to select data from table AR_Customer thru my select query under the linked server but not able to see anything in the catalogs under...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 28, 2011 at 11:13 am
I was able to create the linked server connection. But not able to see any tables under the catalogs of the linked server.
but when i test the connection string...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
November 28, 2011 at 10:42 am
Viewing 15 posts - 271 through 285 (of 360 total)