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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Accessing SQL Server

Author  Topic 

raja
Starting Member

18 Posts

Posted - 2005-02-24 : 03:41:41
Hi,

I have two server server A and Server B. Server B has SQl server installed in it. now i have a windows application which needs to be connected to sql server(B) through server A. IS this possible ? if so, how ?

Thanks in Advance
Raja

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-24 : 13:34:58
Why do you need to route through server A? Network problem? I don't think this is going to be easy to fix. I believe that you'll need to discuss with your network admins how to route through server A as there probably isn't a way programmatically to do this.

Tara
Go to Top of Page

raja
Starting Member

18 Posts

Posted - 2005-02-25 : 02:19:05
If i have a instance of SQl server running in Server A and make server B as remote server,will my problem be solved???
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-25 : 12:26:44
No it won't. Why do you have an architecture like this?

Tara
Go to Top of Page

raja
Starting Member

18 Posts

Posted - 2005-02-28 : 04:08:06
Sever A is Not Internet Enabled But Server B is, and Server A and Server B are connected through a 2mbps pipeline.So Client can connect to the server b through internet and connect to server A to access the database.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-28 : 12:52:29
So you'll need to change your architecture then.

Tara
Go to Top of Page

raja
Starting Member

18 Posts

Posted - 2005-03-01 : 06:26:53
??
Go to Top of Page
   

- Advertisement -