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

SQL LOGGING----PLEASE HELP

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Metadata Searching  
Author Message
d_richwalski

External


Since: Jan 14, 2004
Posts: 2



(Msg. 1) Posted: Thu Jan 15, 2004 12:18 am
Post subject: SQL LOGGING----PLEASE HELP
Archived from groups: microsoft>public>inetserver>iis (more info?)
I have a number of machines running Windows 2003 Enterprise with IIS 6.0....

I have a SEPERATE Windows 2003 with SQL 2000 SP3a running on it.

I have a SINGLE database to gather the logging information from all of the
IIS 6.0 machines, configured with System DSN using an admin account...

Every so often the websites fail because of the forrlowing error:

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



Anyone have a suggestion?

 >> Stay informed about: SQL LOGGING----PLEASE HELP 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 2) Posted: Thu Jan 15, 2004 1:07 am
Post subject: Re: SQL LOGGING----PLEASE HELP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 14 Jan 2004 21:18:40 GMT, d_richwalski.RemoveThis@hotmail.com wrote:

 >I have a number of machines running Windows 2003 Enterprise with IIS 6.0....
 >
 >I have a SEPERATE Windows 2003 with SQL 2000 SP3a running on it.
 >
 >I have a SINGLE database to gather the logging information from all of the
 >IIS 6.0 machines, configured with System DSN using an admin account...
 >
 >Every so often the websites fail because of the forrlowing error:
 >
 >IIS ODBC Logging failed to connect to data source IIS_LOGS. Error text is
 >[[State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL
 >Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Does that account have a matching account on the SQL server?

Jeff<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: SQL LOGGING----PLEASE HELP 
Back to top
Login to vote
d_richwalski

External


Since: Jan 14, 2004
Posts: 2



(Msg. 3) Posted: Thu Jan 15, 2004 1:26 am
Post subject: Re: SQL LOGGING----PLEASE HELP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
If your asking about the NT AUTHORITY\NETWORK SERVICE...then no it is a
built-in (hidden) Windows 2003 account.


As for the other account for that is set-up in the SYSTEN DSN....
Yes........and has SYS admin and DB owner on the SQL server for the Database
 >> Stay informed about: SQL LOGGING----PLEASE HELP 
Back to top
Login to vote
user658

External


Since: Aug 26, 2003
Posts: 1525



(Msg. 4) Posted: Thu Jan 15, 2004 5:02 pm
Post subject: Re: SQL LOGGING----PLEASE HELP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 14 Jan 2004 22:07:51 GMT, jcochran.nospam.DeleteThis@naplesgov.com (Jeff
Cochran) wrote:

 >On Wed, 14 Jan 2004 21:18:40 GMT, d_richwalski.DeleteThis@hotmail.com wrote:
 >
  >>I have a number of machines running Windows 2003 Enterprise with IIS 6.0....
  >>
  >>I have a SEPERATE Windows 2003 with SQL 2000 SP3a running on it.
  >>
  >>I have a SINGLE database to gather the logging information from all of the
  >>IIS 6.0 machines, configured with System DSN using an admin account...
  >>
  >>Every so often the websites fail because of the forrlowing error:
  >>
  >>IIS ODBC Logging failed to connect to data source IIS_LOGS. Error text is
  >>[[State=28000][Error=18456][Microsoft][ODBC SQL Server Driver][SQL
  >>Server]Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
 >
 >Does that account have a matching account on the SQL server?

The error specifies the Network service account though, so I suspect
the issue is with that account accessing the DSN or SQL server itself.
Except for it being intermittent, which would be puzzling if it really
is a permissions error. Can you pin this occurence to anything
specific, SQL server being unavailable at the time possibly?

Jeff<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: SQL LOGGING----PLEASE HELP 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
logging - I have Outlook Web Access 2003 on a Windows 2003 Server. I have all the advanced options to log everything on the IIS side of OWA. This is not logging everything like it did in previous versions of Exchange. I am mainly looking to log external IP..

Logging on to IIS (FTP) - Hello, What I to do is setup an FTP site. I want users to have anonymous access to download things. Then I want to have other users able to login using a username and password and be able to download and upload. Now I have created the directories an...

Logging - I am having a problem with ActiveState Perl 5.8. Using Perls warn function, nothing is output to any of the sites logs, the w3svc or http error logs. Also, no script compile or runtime errors are written to any logs. I have run the same scripts under...

logging nt user - Is it possible to get IIS to log the current NT user login? In my case the site is anonymous - i'm hoping IIS can log the server variable AUTH_USER... Thanks Paul

IIS Logging has been shutdown ... - Since a few days I get the folowing message in the System event log: Source: IISLOG Event ID: 1 Description: IIS Logging for W3SVCxx* has been shutdown because a disk full error has been encountered. * xx: any of the web sites On each hard disk there...
   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 ]