Re: irregular connection issue

Do you mean to use SQL Profiler to trace the activity? What events?

Thanks,

"Kevin3NF" wrote:

no...you were clear...I just didn't read closely enough.

I would suggest turning on ODBC tracing if I knew how to help review the
output...

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B16BFA10-EE85-4D25-9DD2-AEFE236AC781@xxxxxxxxxxxxxxxx
I must not have been clear - SQL & the IIS application run on the same
server.

"Kevin3NF" wrote:

Run Netmon on both ends. Sounds very much like a flaky switch or some
other
piece of hardware that appears normal 99%of the time

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:594474FB-DF78-46F5-811E-D17BE7CC4738@xxxxxxxxxxxxxxxx
Occasionally we are getting the generic "SQL Server does not exist or
access
denied" connection message. KB 328306 does an ok job describing the
situation, the problem we're having is that it doesn't occur with each
connection. The IIS application runs on the same server as SQL does, so
I
don't think any of the network related issues apply. The server is a
stand
alone server, so I don't think any of the domain related issues apply
either.
The server is running W2k3 & SQL 2k.
We've written an ASP page to read records until it encounters a
problem.
The
record count varies every time - it can occur on the 1st read or the
3000
read.
Any de-bugging suggestions will be greatly appreciates.

Thanks,






.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
Loading