I have more information on my problm that I hope help someone to help me:
I have two Intranets Servers Setup:
Intranet Server A: House the SQL Server and works fine.
Intranet Server B: Simple and Intranet Server
Intranet Server A: When running ASP scripts that performs queries on the SQL
server, the SQL Server user name is blank and the NT User Name has the user name
that is logged in. Which is the way I want it.
Intranet Server B: When running doing the same thing, the NT User Name is blank
and the SQL User Name has the name that should be in NT. Since I have all the
permissions setup for NT the connection fails and the scrip fails.
Can anyone tell me why it is that when scripts are executed on the SQL Server it
uses NT User Name, but when on the script is executed on the "NON" SQL Server it
uses the SQL User Name? What do I need to to get this to work right?
Thanks in advance,