Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

IIS-SQL Server login failure

0 views
Skip to first unread message

asi...@ingenium.com.au

unread,
Jan 6, 1998, 3:00:00 AM1/6/98
to

I have a major SQL login problem from IIS. My Active Server Pages
connection works OK when testing ASP/SQL connections when both are
running on same server, but stop working when IIS and SQL server run on
different NT servers (yet on the same network!). I have set up server
connections without trouble to two SQL servers on the network through
Enterprise Manager. Have also successfully tested ODBC connections using
the new Microsoft Data Access Components 1.5 ODBC32 program. No matter
what I try, I get the infamous access denied error:
-------------------------------------------------------------------------
------ ------- Microsoft OLE DB Provider for ODBC Drivers error
'80004005' [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen
(CreateFile()).
-------------------------------------------------------------------------
------ ----------------------------- If I try to login using ISQL, have
no problems connecting as SQLServer-registered users. Yet if these sam e
users are included in the connection string, the login fails.

-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet

Fuji Nguyen

unread,
Jan 7, 1998, 3:00:00 AM1/7/98
to

Did you specify defaut database name for DSN? I got this error before but I
do not remember the exact solution.

Since you separated the servers, could it be that the DB library is no
longer namepile. Could it be protocol mismatch?

James Skipper

unread,
Jan 7, 1998, 3:00:00 AM1/7/98
to

Check your permissions to connect to the SQL Server

Fuji Nguyen <fng...@idinc.com> wrote in article
<68utig$r...@niven.ksc.nasa.gov>...

Neil Pike

unread,
Jan 7, 1998, 3:00:00 AM1/7/98
to

I assume you need to run the IIS service under an NT user account,
rather than localsystem. This is the normal reason for these things
(never coded to IIS myself though)

Neil Pike MVP/MCSE
Protech Computing Ltd

Bibhas Bhattacharya

unread,
Jan 10, 1998, 3:00:00 AM1/10/98
to

Are you using trusted connection in ODBC?
Do you allow anonymous login to your web server?

If you answer yes to both, make sure that the anonymous user
(IUSER_MACHINENAME by default) has access rights to the SQL server
database. You can change the anonymous user to someone who has adequate
access. Better yet, disable anonymous login to the web server. Security
will be evaluated with respect to the actual client (browser) user.

Bibhas Bhattacharya
bib...@interlog.com

0 new messages