Viewing 15 posts - 1 through 15 (of 18 total)
yes, I am using ip,port number
July 13, 2010 at 9:25 am
I have open the case with microsoft, and have worked with three enigneer, but have not resolved. I am waiting for another engineer to work with me. They asked me...
March 21, 2008 at 11:16 am
Just try on our test server, it didn't help. I still can't create linked server? Any other idea?
January 24, 2008 at 9:38 am
Thank you for the help. I google it, and it say to ODBC driver, will it help on OLE DB driver?
January 24, 2008 at 9:16 am
on sql server 2005(sp2) create linked server to sql server 2000(sp4) boxes.
January 24, 2008 at 9:07 am
just delete it then re-create it, no luck.
January 17, 2008 at 7:09 am
100% sure. I guess it is the msdtc or distributed transaction had some problem. I had set up the MSDTC allow remote connection and no password needed.
January 17, 2008 at 6:41 am
Wait, you miss understander it. This account I can connect through the management studio, but when used on the linked server, it had error. What I mean because the user...
January 17, 2008 at 6:27 am
I create a very simple test account: account name: A and passowrd:a
I also try to connect as SQL login use this account and it all fine.
January 17, 2008 at 6:17 am
Here is the error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or...
January 17, 2008 at 5:58 am
Wait! I can linked from B to A, but when I explore the data, I had error say SQL Server is not exist. Any idea?
January 17, 2008 at 5:45 am
The new SQL Server 2005 is on server pack 2. Also if the server I had problem A(2005 cluster SQL Server), the other Server SQL 200 is B. I just...
January 17, 2008 at 5:41 am
The other SQL Server 2000 with service pack 4. The currecnt SQL Server 2000 is a cluster SQL Server, we just migrate to this new SQL Server 2005 cluster server....
January 17, 2008 at 5:37 am
Yes, those all SQL server 2000 servers. We have a SQL 2000 server linked to those servers now. Thank you for the help!
January 17, 2008 at 5:25 am
From teh cluster server to all other sql servers all failed to create
January 17, 2008 at 5:16 am
Viewing 15 posts - 1 through 15 (of 18 total)