proxy SQL traffic?

[regulator44]

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

 

[Catadmin]

Is this other domain a trusted domain or an untrusted domain? If untrusted, I'm not sure you can do it without using IIS to expose your SQL Server to the internet (Bad Idea<tm>!)

If trusted, you should be able to use pass-thru security to do the deed.

Of course, the account accessing SQL Server will need the proper domain permissions on top of the proper SQL Server permissions. Pass-thru security means the accounts have to be set up identical (names, passwords, permissions, etc). Google the phrase and you'll find all sorts of interesting links with more details.




Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???