Re: Trouble connecting to SQL Server with ASP !?!
From: Mark Schupp (mschupp_at_ielearning.com)
Date: 06/25/04
- Next message: Jeff Cochran: "Re: ASP accessing Lotus Notes??"
- Previous message: Bob Barrows [MVP]: "Re: Accessing data from an MS Access database on a remote web serv"
- In reply to: somanybugssolittletimetofixthem: "Trouble connecting to SQL Server with ASP !?!"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Jun 2004 10:24:16 -0700
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:
dsn=dsn_goes_here;uid=db_account_id_here;pwd=db_account_pw_here
For DSN-less connections see the other responses.
-- Mark Schupp Head of Development Integrity eLearning www.ielearning.com "somanybugssolittletimetofixthem" <fixinbugzrus@zapembugs.com> wrote in message news:25CFA8DA-7FB1-4A67-80CF-1D5B740D1112@microsoft.com... > I have to write an ASP web application against a SQL server database. The network guys set me up to create web pages on the server (IIS) and created 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.
- Next message: Jeff Cochran: "Re: ASP accessing Lotus Notes??"
- Previous message: Bob Barrows [MVP]: "Re: Accessing data from an MS Access database on a remote web serv"
- In reply to: somanybugssolittletimetofixthem: "Trouble connecting to SQL Server with ASP !?!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
