 |
 |
We had a similar problem when we moved our DB server to virtualization. What DB version are you using and what are you using for your connection string. We had to make some changes to our connection string to make it work. We were using something similar to: Provider=sqloledb;Data Source=xxx;Initial Catalog=xxx;Integrated Security=SSPI; Then we changed to: Provider=SQLNCLI10;Data Source=xxx;Initial Catalog=xxx;Integrated Security=SSPI; Which worked better for us since we were now connecting to a SQL 2008. Of course we are also using classic ASP on that site. -----Original Message----- From: Carl Bussema III [mailto:[log in to unmask]] Sent: Tuesday, June 14, 2011 8:51 AM To: [log in to unmask] Subject: [MSUNAG] Database timeouts (Cross-posting to WEBDEV and MSUNAG because not all webdev people are also their systems people, and the systems people may not be aware of this depending on the communication between them and the web teams. Apologies to those of you who get this twice.) Is anyone else on this list using AISDB3/AISDB4 for their websites (or other data-drive applications) and experiencing frequent timeouts? Our sites are reporting now up to 6-10 times per day errors such as these three below: Microsoft OLE DB Provider for SQL Server error '80004005' Timeout expired or System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) or System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) All of these errors started after the May 23 AIS maintenance that moved these servers to a virtual context. It used to be we'd get something like this once a day around 9 p.m. (presumably the servers were going offline for backup, which is a completely separate rant), but now that's it's happening in the middle of the day, I'm trying to figure out if this is just us or if something's really messed up over there, so I know which direction to start poking. None of our data operations changed -- we're still requesting the connection the same way as always. Some of our sites are completely unchanged except minor content updates, so it's not like we changed something, but now we're seeing all these errors, and we're trying to get to the bottom of them. Thanks all for any information, Carl Carl Bussema III Information Technologist Michigan State University Outreach & Engagement Phone: (517) 353-8977 . Fax: (517) 432-9541 [log in to unmask]