Click here to Skip to main content
15,850,685 members
Home / Discussions / System Admin
   

System Admin

 
AnswerRe: Accessing Public IP address Pin
Jochen Arndt23-Dec-13 2:21
professionalJochen Arndt23-Dec-13 2:21 
GeneralRe: Accessing Public IP address Pin
forme24-Dec-13 0:02
forme24-Dec-13 0:02 
GeneralRe: Accessing Public IP address Pin
Jochen Arndt24-Dec-13 0:25
professionalJochen Arndt24-Dec-13 0:25 
QuestionScripting MMC with vbscript. Pin
Dan Kamp17-Dec-13 6:00
Dan Kamp17-Dec-13 6:00 
QuestionDNS Pin
goutom15-Dec-13 0:25
goutom15-Dec-13 0:25 
AnswerRe: DNS Pin
Richard MacCutchan15-Dec-13 1:45
mveRichard MacCutchan15-Dec-13 1:45 
QuestionCisco Router Configuration Assistance Pin
Vasudevan Deepak Kumar29-Nov-13 1:53
Vasudevan Deepak Kumar29-Nov-13 1:53 
QuestionTroubleshooting upgrade from sql 2005 to sql 2008R2 Pin
Kalsto2-Nov-13 20:06
Kalsto2-Nov-13 20:06 
I've inherited a legacy IIS 7.0 website (vb.net website, not an application) that was running against an MSSQL 2005 Database.

Recently we upgraded to MSSQL 2008 R2. Now, when users go to certain pages, we get a SQL Connection timeout error. Investigating, it says this can happen when datareaders are used and connections aren't properly closed. I tried adding try/catch/finally statements, but I can still get the error. I've also updated the SQL Client to use the same version on both the SQL server and the Web Server, to no avail.

I pull a netstat when the issue happens, and there's literally thousands of connections to the SQL server (from the Web Server).. based on the one page (trying) to load.

This particular page makes a simple call to populate an Org diagram. Fairly straight forward. But for some reason, the page has almost taken off without control and uses up all the available connections to the SQL server.

Any thoughts on how I might troubleshoot/resolve this issue would be greatly appreciated!





Update:
I've found that when the database was upgraded from 2005 to 2008R2, some NULL columns were converted to columns with a 0 value..which then caused the stored procedure for the page to infinite loop and lock the connections (again.. not my code!). Any idea why that might have happened? Was the database not restored/converted properly?

modified 3-Nov-13 1:16am.

General0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 5:51
professionalJoan M15-Oct-13 5:51 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Pete O'Hanlon15-Oct-13 5:55
subeditorPete O'Hanlon15-Oct-13 5:55 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 5:56
professionalJoan M15-Oct-13 5:56 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
OriginalGriff15-Oct-13 6:08
mveOriginalGriff15-Oct-13 6:08 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 6:17
professionalJoan M15-Oct-13 6:17 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
OriginalGriff15-Oct-13 6:26
mveOriginalGriff15-Oct-13 6:26 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M11-Nov-13 5:31
professionalJoan M11-Nov-13 5:31 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Nicholas Marty15-Oct-13 6:23
professionalNicholas Marty15-Oct-13 6:23 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
David C# Hobbyist.15-Oct-13 6:10
professionalDavid C# Hobbyist.15-Oct-13 6:10 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 6:18
professionalJoan M15-Oct-13 6:18 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
David C# Hobbyist.15-Oct-13 6:26
professionalDavid C# Hobbyist.15-Oct-13 6:26 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M11-Nov-13 5:30
professionalJoan M11-Nov-13 5:30 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
RedDk15-Oct-13 7:57
RedDk15-Oct-13 7:57 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 8:55
professionalJoan M15-Oct-13 8:55 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Storm-blade15-Oct-13 6:23
professionalStorm-blade15-Oct-13 6:23 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
Joan M15-Oct-13 8:55
professionalJoan M15-Oct-13 8:55 
GeneralRe: 0x8024D001 windows update problem with windows XP 32 SP3 Pin
rashin ghodratzade18-Oct-13 20:09
rashin ghodratzade18-Oct-13 20:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.