IIS-SQL Server login failure 
Author Message
 IIS-SQL Server login failure

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?

Quote:
>-------------------------------------------------------------------------
>------ ------- Microsoft OLE DB Provider for ODBC Drivers error
>'80004005' [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen
>(CreateFile()).
>-------------------------------------------------------------------------



Sun, 25 Jun 2000 03:00:00 GMT
 IIS-SQL Server login failure

Check your permissions to connect to the SQL Server



Quote:
> 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?

>-------------------------------------------------------------------------
> >------ ------- Microsoft OLE DB Provider for ODBC Drivers error
> >'80004005' [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen
> >(CreateFile()).

>-------------------------------------------------------------------------



Sun, 25 Jun 2000 03:00:00 GMT
 IIS-SQL Server login failure

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



Sun, 25 Jun 2000 03:00:00 GMT
 IIS-SQL Server login failure

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

Quote:
> -------------------------------------------------------------------------
> ------ ------- Microsoft OLE DB Provider for ODBC Drivers error
> '80004005' [Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen
> (CreateFile()).



Wed, 28 Jun 2000 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Error 17832, Login Packet Failure Using ODBC and IIS 3.0

2. SQL server task fails-sql executive login failure-

3. IIS Virtual Directoary Management for SQL Server on remote vs local IIS Web Server

4. Sql Server 6.0 Login Failure

5. SQL Server V6.5 Enterprise Manager Login Failure

6. Login failure with SQL 6.5 Server

7. SQL server login failure

8. SQL Server MAPI login failure

9. SQL 2000 Server Error 1069 Login Failure

10. Login Failure/Not Trusted SQL Server Connection

11. SQL server 7 login failure after changing domain

12. Login failure using SQL 6.5 Server


 
Powered by phpBB® Forum Software