I have an application that I use anonymous access using a domain account with to access a SQL Server. If I use only anonymous access, then I am able to get to the DB just fine. My problem is if I use anonymous access, the post method stops working for my forms on that page. And just the opposite if I use NT authentication instead of anonymous access. Post method works fine, but I cannot access the database. Please help. I've searched all over google with no solutions. Thanks

What it sounds like to me is that when you are using NT Authentication, you are eliminating the default anonymous user. Instead of putting the user information into the connection string, you've made the internet user an admin of your database. I say just make a new user in your db with a good password and define the user name and password in your connection string. For example, you might do this:

Const strServer = "MYSQLDBSERVER01"
Const strDatabaseName = "MyDatabase"
Const strUID = "MyInetUser"
Const strPassword = "Qx56zp"
myConnString = "DRIVER={SQL Server};SERVER=" & strServer &";DATABASE=" & strDatabaseName &";UID=" & strUID &";PWD=" & strPassword &";DSN=;"
Set myConnect = Server.CreateObject("adodb.connection")
myConnect.Open myConnString

That should do it. I've always been able to have my inet user account work well as a database user, but I've only worked with 2k and XP as SQL Server environments.

Thanks for the response. Here is the connection string I am using.

strConnectEBPPInfo = "Provider=SQLOLEDB; Data Source = nexus\ebpp; Initial Catalog = EBPPDev; Trusted_Connection=yes"

Our SQL server is setup for NT authentication mode only. If it was setup in mixed mode, then your solution works. Unfortunatly, our security team will not let that happen. So what I did is made a domain account ten added that account to the user list on the DB. Then in order to access that data, I needed to use that account for the anonymous user instead of the IUSR account. Make sense?