January 24, 2008 at 9:00 am
I post last week and ask help on create linked sql server. It failed when I just type any sql server name, but when I type SQL Server name TEST,1433 the linked sql server will work. Can anyone tell me how to fix that, I would rather use sql server name and not specify the port name. I tried 4 SQL Server all failed, but after add port number all worked. Thank you for the help!!
January 24, 2008 at 9:04 am
What version SQL to what version?
Have you tried open data source?
January 24, 2008 at 9:07 am
on sql server 2005(sp2) create linked server to sql server 2000(sp4) boxes.
January 24, 2008 at 9:10 am
Re-apply instcat.sql on the SQL2000 side from the SP4 install.
It won't let me upload a .sql file ... you should be able to Google it if you don't have it handy.
January 24, 2008 at 9:16 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:18 am
Not entirely sure, but it did resolve similar problems we had that you're speaking of ... regardless, it won't hurt to re-apply it to a SQL2000 server already on SP4. So if it doesn't work, than it's something else ... perhaps an alias, dns, not sure ... but I'd start with this.
January 24, 2008 at 9:38 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:45 am
Sunny (1/24/2008)
Just try on our test server, it didn't help. I still can't create linked server? Any other idea?
Is the target server's SQL server listening on a different port?
What is the syntax for your linked server create?
Have you attempted to recreate the linked server?
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply