473,396 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

SQL errors after IIS5 to IIS 6 move

Yesterday we moved a site from a shared Win2K box to a customer dedicated
Win2k3 server. The application is ASP, a huge busy site with MS SQL server
backend. Since the move, the website log is showing many entries with the
following error:

[DBNETLIB][ConnectionOpen_(Connect()).]SQL_Server_does_not_exist_or_access_denied.

The connection string used in the client's web application is in the format:

Conn.Open " Provider=SQLOLEDB.1;Password=xxxx;Persist Security
Info=True;User ID=yyyy;Initial Catalog=zzzz;Data Source=sql1.digitalwest.net
"

From what I can tell from the SQL server, the timing on many of these errors
is at a point where the SQL server is at high CPU loads. However, this is
the same SQL server that has been used all along and the logs were not
showing SQL server connectivity issues prior to the move even when the SQL
server was under a load.

Are there any known out of the box differences between Win2K/IIS5 and
Win2k3/IIS6 that would be effecting the SQL server connectivity? Or what
settings might I have missed on the Win2K3 box that could be causing this
difference in behavior?
Thanks,

Mary Rafferty
Aug 12 '05 #1
0 1700

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: David Lozzi | last post by:
I have an ASP app that grabs the logon user, and then I use GetObject to query the user's security groups. On a Windows 2000 server running IIS5, this works excellent. I then copied it to a...
7
by: Paul | last post by:
I thought this is more of an IE issue but i've had no joy on that group perhaps somebody here will have a clue. If i click a link to a web page embedded in Excel (97 OR 2000) i get the standard...
1
by: Derek | last post by:
I am writing a web application for job seekers, and am adding a section that allows administrators to upload jobs to the system via xml. I have used an xml schema to validate the xml they upload....
4
by: Jon Spivey | last post by:
Hi, I've set up a custom error like this <customErrors mode="On" defaultRedirect="ErrorPage.aspx"> <error statusCode="404" redirect="error404.aspx" /> </customErrors> So requests for...
0
by: Chris | last post by:
Ok, I have the below function in my web app. public void advalue_set_tbs_m (DirectoryEntry ad_user, string field, TextBox tb) { //adds value to AD if value is > 0, if not, sets it to null ...
0
by: Gustavo Barbosa | last post by:
I´m having this problem: I'm stress testing a ASP.NET web application using ACT and comparing results with a previous version of the website (developed in ColdFusion 4.5). When using 300...
1
by: Gustavo Barbosa | last post by:
I´m having this problem: I'm stress testing a ASP.NET web application using ACT and comparing results with a previous version of the website (developed in ColdFusion 4.5). When using 300...
1
by: John Oliver | last post by:
I'm playing around with phpOpenTracker Since the example files generate a blank screen (and no HTML source) on my system, I'm trying to get PHP errors generated somehow, but nothing is working. ...
5
by: Terry Strachan | last post by:
Hi, I have an asp.net webapp that works fine on my development machine, win2k/iis5 however, when I move the site across to win2k3 / iis6 i get the following error on postback of any page; ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.