Hello

im trying to connect to a remote server over an internet vpn connection
i asked admin of the remote location to open port 1433 in his firewall, he
did and im able to register the server successfully by IP address on
enterprise manager
i can also make a connection with query analyzer with no problem and select
from tables normally

however when i try to establish a linked server using OLEDB for SQL server ,
connection fails , properties of the connection is ,
product name: empty
data source: the IP address of the server
provider string and catalog: empty

security: no rows in local server login to remote server login mapping but
chose last option in
for a login not defined in the list above connection will: i chose
be made using this security context and i wrote sa and password i used
before in registering server as a test

what is wrong , does linking a server require opening additional ports in
firewall ?? which query analyzer does not need if server is registered
normally not linked?

any help very appreciated

Bassam

Bassam (bas***@nptco.com.eg) writes:
And the error message is?

You could consider defining a provider string for the linked server. That's
all I can suggest without knowledge about the error.

Error msg is :

SQL Server does not exist or access denied.

i tried to define a provider string also by format
srever=ip address;database=xx;user id=xx ; password=xx

but did not work either

question is do i have to open port UDP 1434 also in the firewall ?

Regards
Bassam

Show quoteHide quote

Bassam (bas***@nptco.com.eg) writes:
I don't think that would matter.

Is SQL Server running on the same machine as you run QA/EM from? If not,
maybe the remote DBA only opened the firewall for one IP address?

Under which Windows account do SQL Server run? You can check this in
Computer Management/Services. If SQL Server is running under LocalSystem
try changing it to domain account, and restart SQL Server.

Stored procedures, nullable parameters, COALESCE
Naming Conventions: Prefixing Columns w/ Table Names
Group By
column info from temp table
Oracle MINUS equivalent in MSSQL2000 ?