dbTalk Databases Forums  

About MSSQL Audit Logout issue

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss About MSSQL Audit Logout issue in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim.Huang
 
Posts: n/a

Default About MSSQL Audit Logout issue - 09-25-2008 , 01:20 AM






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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.