Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 08:28:49
|
| Gianluca Seno writes "Hi, I'm creating an advanced search sistem for my website, but I've a great problem where I couldnt see the solution..So my problem is this: I've a SQL Server installed in Server A and a Index Server installed on Web Server B.I want to connect SQL Server on Server A to Index Server on Server B throught Linked Server of SQL Server and making a query with openquery.My problem is that when I do the query I receive an error and seems that I couldnt connect SQL Server to a remote index server: count you help me?Best regards,Gianluca" |
|
|
mallier
Starting Member
24 Posts |
Posted - 2006-02-14 : 10:58:22
|
| what error msg u getting?cheers,http://mallier.blogspot.com |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-15 : 03:44:50
|
| Hi,yes without an error message we can't help you to give u a good answer so please describe error message ... but have you specify both server in each server as a remote server using sp_addlinkedserver and sp_addlinkedsrvlogin ? are both in same network segment ? is proper privillege with user account ?RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
|
|
|
Linked Server advanced question