Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

IIS6 with ODBC loggin

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  IIS Public/private Address  
Author Message
user782

External


Since: Sep 14, 2003
Posts: 2



(Msg. 1) Posted: Sun Sep 14, 2003 5:39 am
Post subject: IIS6 with ODBC loggin
Archived from groups: microsoft>public>inetserver>iis (more info?)
I'm running a Windows 2003 server and various IIS services. The server also
SQL Server 2000 installed.

I'm trying to setup ODBC logging for the web server, but can't get it
working. I've enabled ODBC logging for the FTP, SMTP, and NNTP servers no
problem. Each of the services is logging to the same table in SQL Server.

I get the following in the event logs:
Application log -
Could not initialize the logging module for site 1. The site will therefore
be non-functional.

System log -
IIS ODBC Logging failed to connect to data source NNTP_Log. Error text is
[[State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.].

I've tried various things, including the working DSN from one of the other
services, but I get the same messages.

Help
--
</Slugsie>
-=+Team ToolFox+=-
[paul_at_slugsie_dot_co_dot_uk]

 >> Stay informed about: IIS6 with ODBC loggin 
Back to top
Login to vote
kgafvert

External


Since: Aug 23, 2003
Posts: 2972



(Msg. 2) Posted: Sun Sep 14, 2003 2:48 pm
Post subject: Re: IIS6 with ODBC loggin [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,

Looks like 'NT AUTHORITY\NETWORK SERVICE' is not allowed to logon to SQL
Server.

--
Regards,
Kristofer Gafvert
<a style='text-decoration: underline;' href="http://www.ilopia.com" target="_blank">http://www.ilopia.com</a> - FAQ & Tutorials for Windows Server 2003, and SQL
Server 2000
* Latest on ilopia.com *
Views in SQL Server 2000 - <a style='text-decoration: underline;' href="http://www.ilopia.com/MSSQL/Tutorials/Views.aspx" target="_blank">http://www.ilopia.com/MSSQL/Tutorials/Views.aspx</a>
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.


"Slugsie" <me.TakeThisOut@privacy.net> wrote in message
news:esTBKEmeDHA.2748@TK2MSFTNGP11.phx.gbl...
 > I'm running a Windows 2003 server and various IIS services. The server
also
 > SQL Server 2000 installed.
 >
 > I'm trying to setup ODBC logging for the web server, but can't get it
 > working. I've enabled ODBC logging for the FTP, SMTP, and NNTP servers no
 > problem. Each of the services is logging to the same table in SQL Server.
 >
 > I get the following in the event logs:
 > Application log -
 > Could not initialize the logging module for site 1. The site will
therefore
 > be non-functional.
 >
 > System log -
 > IIS ODBC Logging failed to connect to data source NNTP_Log. Error text is
 > [[State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL
 > Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.].
 >
 > I've tried various things, including the working DSN from one of the other
 > services, but I get the same messages.
 >
 > Help
 > --
 > </Slugsie>
 > -=+Team ToolFox+=-
 > [paul_at_slugsie_dot_co_dot_uk]
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: IIS6 with ODBC loggin 
Back to top
Login to vote
kenremove

External


Since: Aug 23, 2003
Posts: 2901



(Msg. 3) Posted: Sun Sep 14, 2003 3:33 pm
Post subject: Re: IIS6 with ODBC loggin [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
a) Is SQL Server using Mixed Mode -or- Integrated Windows Authentication?

b) It seems that you are using Integrated Windows Authentication. If so,
have you granted permission (in SQL Server) for NT Authority\Network Service
to login to SQL Server, and, say, DataReader/DateWriter permissions on in
the databases in question?

Error message is saying that the user account that the web application pool
is running under doesn't have permission to login to the SQL Server. The
FTP, SMTP and NNTP servers are different - they run inside Inetinfo (which
runs under LocalSystem by default), so the user permissions are probably
fine for those services.

Cheers
Ken

"Slugsie" <me.TakeThisOut@privacy.net> wrote in message
news:esTBKEmeDHA.2748@TK2MSFTNGP11.phx.gbl...
: I'm running a Windows 2003 server and various IIS services. The server
also
: SQL Server 2000 installed.
:
: I'm trying to setup ODBC logging for the web server, but can't get it
: working. I've enabled ODBC logging for the FTP, SMTP, and NNTP servers no
: problem. Each of the services is logging to the same table in SQL Server.
:
: I get the following in the event logs:
: Application log -
: Could not initialize the logging module for site 1. The site will
therefore
: be non-functional.
:
: System log -
: IIS ODBC Logging failed to connect to data source NNTP_Log. Error text is
: [[State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL
: Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.].
:
: I've tried various things, including the working DSN from one of the other
: services, but I get the same messages.
:
: Help
: --
: </Slugsie>
: -=+Team ToolFox+=-
: [paul_at_slugsie_dot_co_dot_uk]
:
:
 >> Stay informed about: IIS6 with ODBC loggin 
Back to top
Login to vote
user782

External


Since: Sep 14, 2003
Posts: 2



(Msg. 4) Posted: Sun Sep 14, 2003 7:21 pm
Post subject: Re: IIS6 with ODBC loggin [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Thankyou both, got it working now.

What had me thrown was that NT Authority\Network Service wasn't listed
anywhere as an account I could select. After typing it in manually it works.

--
</Slugsie>
-=+Team ToolFox+=-
[paul_at_slugsie_dot_co_dot_uk]

"Kristofer Gafvert" <kgafvert DeleteThis @NEWSilopia.com> wrote in message
news:%23vzEeVqeDHA.620@TK2MSFTNGP11.phx.gbl...
 > Hi,
 >
 > Looks like 'NT AUTHORITY\NETWORK SERVICE' is not allowed to logon to SQL
 > Server.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: IIS6 with ODBC loggin 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS 5 loggin time 4 hours ahead - Howdy, My IIS 5 server is logging time in the 24 hour format that is 4 hours ahead of what the actual computer time is. How do I change this? THANKS! helm

ODBC connector not accessing data - We have created a photo management web application using perl and ms access. I have configured the ODBC System DSN to pull data from a database located on another server. When accesing the page, data from the database is not displayed. If I put the..

Limit SQL/ODBC Connections per virtual server? - I have the follwing setup: An IIS 5 server, with various virtual webservers. Some of these webservers use connections to an externel SQl and a Oracle database. One of the applications is not written correclty and it looks like it takes all connections....

does odbc support connection pooling when using named pipes - I have a problem with a VB.NET web application connection to an Informix database using ODBC. Occasionally I get "out of memory" errors, I discovered enabling connection pooling seems to solve this error, hovever on one of the machines the pro...

iis6 / asp / caching - Hi I'm using IIS 6 that uses a shared drive as source. It serves all files etc without any problems. But when I modify an .asp or html page and i reload it, I still get the old page. Then I have to reload 2-3 more times and I get the new version. I have...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]