Ask your network guys if they set up the DSN to use "windows authentication"
or "SQL Server Authentication". If it is "windows authentication" then the
anonymous internet account on the web-server needs to be given access to the
database in SQLServer Enterprise Manager.
If it is "SQL Server Authentication" then you will need a SQLServer Logon ID
and Password for an account that has access to the database. For use with a
DSN the connection string would look like:
For DSN-less connections see the other responses.
Head of Development
"somanybugssolittletimetofixthem" <fixinbugzruszapembugs.com> wrote in
message news:25CFA8DA-7FB1-4A67-80CF-1D5B740D1112microsoft.com...network guys set me up to create web pages on the server (IIS) and created> I have to write an ASP web application against a SQL server database. The
an ODBC connection. However, I cant connect to SQL server and read any data
using the System DSN. I get a generic SQL server error complaining about NT
authorization. Do I need to pass a SQL server userid and password (I dont
have one!). Is there any other SQL server setup needed for web access? Have
spent several days struggling with this. No-one knows anything about web
applications with SQL server here.