"Lalit" <Lalit@discussions.microsoft.com> wrote in message
news:B2B9DF70-6D4D-44D2-A56D-79224A89748A@microsoft.com...
> Hi Friends,
>
> I have two LAN networks, having different IP Address classes(say one
> network is 101.12.12.x and other is 102.12.11.x). These LAn Networs are
> connected by the Internet connection. At both the networks routers are
> configured and at the Gateway Firewall Port 1433 is opened.
>
> How to connect the SQL server of other network from network?
>
>
> With regards,
> Lalit

"Andreas Müller" wrote:

> Hi Lalit,
>
> did you try to call the stored procedures sp_addlinkedserver SERVERNAME
> and then sp_addlinkedsrvlogin LOCAL_LOGIN, REMOTE_LOGIN, REMOTE_PWD
>
> regards
> Andreas
>
> "Lalit" <Lalit@discussions.microsoft.com> wrote in message
> news:B2B9DF70-6D4D-44D2-A56D-79224A89748A@microsoft.com...
> > Hi Friends,
> >
> > I have two LAN networks, having different IP Address classes(say one
> > network is 101.12.12.x and other is 102.12.11.x). These LAn Networs are
> > connected by the Internet connection. At both the networks routers are
> > configured and at the Gateway Firewall Port 1433 is opened.
> >
> > How to connect the SQL server of other network from network?
> >
> >
> > With regards,
> > Lalit
>
>