Re: Virtual SQL Server times out.

From: Sezgin Rafed (anonymous_at_anonymous.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 16:20:37 +0300

Thanks again to Geoff an Mingqing.

I would like to mention few more points. We constructed a separate ASP.NET
application and a ASP 3.0 page connecting to the same Virtual SQL Server. I
also put the complete problematic web site on a different Windows 2003
Server box. The situation is as follows:

Once the "Connection Timeout" Error occurs the code on the NLB Cluster and
the same code on the separate Windows 2003 Server box cannot connect to the
Virtual SQL Server. The ASP.NET application and the ASP 3.0 page connect
without a problem. Once the SQL Server is cycled Offline/Online all of them
can connect.

The Connection String used in the problematic code(with some string
variables in it) is:

CONNECTION_STRING = "data source=" & strDataSource_MES & ";Initial Catalog="
& strCatalog_MES & ";User
ID=businesslogic;Password=abc123ef;Trusted_connection=no;Persist Security
Info=True;Max Pool Size=500;Connection Lifetime=10;"

Best regards.

""Mingqing Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:yVgj31PtEHA.3432@cpmsftngxa06.phx.gbl...
> Hi Sezgin,
>
> I am currently standing by for an update from you and would like to know
> how things are going there. Should you have any concerns on the recent
> information I've posted, please don't hesitate to let me know directly and
> I would love to help you on SQL Server side issues. It's my pleasure to be
> of assistance
>
> Sincerely yours,
>
> Mingqing Cheng
>
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---------------------------------------------------------------
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Relevant Pages

  • RE: Urgent problem about SQL Server
    ... Most of the problems I've had with ASP have been because of this. ... I have a problem connecting my SQL Server 2005 from a ASP Webpage. ... When I trying to connect using the following connection string: ... or any setting missing in the SQL Server to accept Web ...
    (microsoft.public.sqlserver.security)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
Loading