I have a SQL2000 box, using only NT Security, (and it does need to use only NT security rather than combined NT and SQL security) and I need to connect to it from a IIS 5 web server in my DMZ via a firewall.
The firewall stuff is not really my concern, but I can't instantly see a way to connect an ODBC connection to the server, as it has no NT user (not being part of the domain) and I can't use a SQL login, as the SQL box won't accept it.
I'd appreciate any thoughts anyone might have!!
Thanks in advance.
Fi.

The firewall stuff is not really my concern, but I can't instantly see a way to connect an ODBC connection to the server, as it has no NT user (not being part of the domain) and I can't use a SQL login, as the SQL box won't accept it.
I'd appreciate any thoughts anyone might have!!
Thanks in advance.
Fi.