Re: ADODB Connection Open: Intermittent Timeout Expired Errors



C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
assuming you installed express first and to the default location.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Brian Kudera" <BrianKudera@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:17F23E00-0514-43F1-9822-88F61816AD2D@xxxxxxxxxxxxxxxx
Where do I find the SQL Server errorlog?

I am on SQL Server Express and cannot view the transaction logs from
within
SSMSE. If you are talking about the system logs in the Event Viewer,
there
was nothing logged in here during the time frame of the connection error.

"Roger Wolter[MSFT]" wrote:

Yes, also look in the SQL Server errorlog file to see if any errors are
logged when the timeout happens.


.



Relevant Pages

  • Re: Passing IDs in SQL
    ... William (Bill) Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> Let's see how you're setting up the SQL in code. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Passing IDs in SQL
    ... William (Bill) Vaughn ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >> Let's see how you're setting up the SQL in code. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SMS 2.0 - Remote Tools being denied on some PCs
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > SQL DB ... > Remote Tools Security ...
    (microsoft.public.sms.admin)
  • Re: SQL SLAMMER
    ... that's named pipes but from the way SQL Server 7.0 did it... ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Are multiple transaction logs used concurrently or sequentially?
    ... SQL Server allows to create multiple Transaction logs for a database. ... FILENAME = 'c:\program files\microsoft sql ...
    (microsoft.public.sqlserver.server)

Loading