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
 Import/Export (DTS) and Replication (2000)
 proxy SQL Traffic ?

Author  Topic 

regulator
Starting Member

3 Posts

Posted - 2005-06-02 : 10:12:05
Hi
Just wondering if it is possible to proxy SQL traffic and get SQL to pop up a user/pass box. I want to access it from another domain, similar to this link here:
http://www.microsoft.com/resources/documentation/sql/7/all/reskit/en-us/part5/sqc07.mspx
BUT I don’t want to replicate the server as is suggested in this link above.
Any suggestions?
Thanks in advance

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-02 : 10:17:36
What do you mean "SQL to pop up a user/pass box" ?
SQL is a language, SQL Server is a service, neither of them can pop up a authentication dialog.

In that link it looks like the proxy box is just doing port forwarding, what are you actually trying to achieve ?



Damian
Ita erat quando hic adveni.
Go to Top of Page

regulator
Starting Member

3 Posts

Posted - 2005-06-03 : 02:08:56
I have a group of users on another server and I want them to be able to access the sql server. When these users open up sql I want sql to challenge them for a username and password to gain access. (Redirect over proxy). I dont want to do this via replication. If i cant achieve this, then i need to add all those users to the sql server which means increased user management for me
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-06-03 : 02:17:20
Ahhh ok, I see what you mean now. I don't think there is a way around this, except maybe VPN ?


Damian
Ita erat quando hic adveni.
Go to Top of Page
   

- Advertisement -