dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

About MSSQL Audit Logout issue - sqlserver-datamining

This is a discussion on About MSSQL Audit Logout issue - sqlserver-datamining ; hi I have a database server with MSSQL 2005 installed and two webserver work on VS.NET 2.0 It works fine before.But when connecting the dbserver from another remote WebServer with TCP/IP( connection string as "Data Source=192.168.0.202,48525;Network Library=DBMSSOCN;Initial Catalog=MyDB01;User ID=dbuser01;Password=dbuser01pwd") ,the ...


Home > Database Forum > Data Warehousing > sqlserver-datamining > About MSSQL Audit Logout issue

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 09-25-2008, 02:20 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default About MSSQL Audit Logout issue

hi

I have a database server with MSSQL 2005 installed and two webserver
work on VS.NET 2.0
It works fine before.But when connecting the dbserver from another
remote WebServer with TCP/IP( connection string as "Data
Source=192.168.0.202,48525;Network Library=DBMSSOCN;Initial
Catalog=MyDB01;User ID=dbuser01;Password=dbuser01pwd") ,the remote webserver
can not work stably and the error msg is "Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding",I found the issue is "Audit Logout" takes too many Reads .
Could you help me figure out this issue?
thanks



Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 06:07 AM.