ASP.NET Enterprise Manager 500 Error

[MatthewTLS]

Any assistance that anyone can provide would be greatly appreciated. I currently have a Linux Plesk server and I am now investigating setting up a Windows Plesk server, however I'm having a few issues with the MS SQL Webadmin utility. I should also note that I'm a Sys Admin, so I hope I'm providing all the information necessary to troubleshoot my Windows Server issue.

I'm running Windows 2008 R2 SP1, IIS 7.5 and Plesk 10.2.

My issues:

1) The sqladmin site that hosts the MS SQL web administration utility (ASP.NET Enterprise Manager) always crashes with a 500 error. Event viewer shows:

Faulting application name: w3wp.exe, version: 7.5.7601.17514, time stamp: 0x4ce7a5f8
Faulting module name: ntdll.dll, version: 6.1.7601.17514, time stamp: 0x4ce7ba58
Exception code: 0xc0000374
Fault offset: 0x000ce653
Faulting process id: 0xcc4
Faulting application start time: 0x01cc31a1aa0a1962
Faulting application path: C:\Windows\SysWOW64\inetsrv\w3wp.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: bfd33dd2-9d95-11e0-9164-acc2dcb2ba3b

If you try and refresh the page it simply hangs until you Recycle the Application Pool and then it will give you the 500 error again. This happens if you try to access the Webadmin tool from either as an Admin or Customer.

2) Is there a way to change the link the Webadmin uses? As a shared hosting provider that won't be able to always control all of our customer's DNS, it's not very efficient for Plesk to require a mssql.domain.tld sub domain when logged into the panel as a Customer attempting to access the MS SQL Webadmin utility. It would make much more sense to make it a static link, like the MySQL Webadmin link. Any assistance you can provide would be greatly appreciated.

Cheers, Matthew

 

[MatthewTLS]

Resolution:

Add IIS_IUSR with read/directory list permissions to C:\Inetpub\vhosts\sqladmin\mssql and C:\Inetpub\vhosts\sqladmin\mssql\Web.config. Then, move the mssql application from the plesk(default)(2.0)(pool) Application Pool to the DefaultAppPool Application Pool. Recycle your pools and you will be able to access the ASP.NET Enterprise Manager web admin utility.

However, I am still at a loss for how to change the URL so that when a customer accesses the MS SQL web admin utility it doesn't redirect them to mssql.customer-domain.com.

Cheers.

 

[yatint]

Run these two command from command prompt


%Plesk_bin%websrvmng.exe --reconfigure-vhost --vhost-name=cgrecruiter.com


%Plesk_bin%defpackagemng.exe --fix --type=sqladminmssql

then restart IIS

==============
I have 2 win server

on my 2nd server I am also getting same error in event viewer

Please let me know if you found any solution on this.

Thanks

 

[yatint]

Okay Sysadmin

Now I am getting this window when I tried to connect webadmin
http://clip2net.com/clip/m90301/1311996294-dc17d-83kb.png

I already created virtual dir for sqladmin

please assist

thanks

 

[yatint]

While opening IIS application pool I am am getting below error :

PHP Warning: call_user_func_array() expects parameter 2 to be array, string given
Line: 1080
File: C:\Program Files (x86)\Parallels\Plesk\admin\plib\elements.php3
Stack Trace:
#0 Smb_Exception_Syntax::handleError(2, call_user_func_array() expects parameter 2 to be array, string given, C:\Program Files (x86)\Parallels\Plesk\admin\plib\elements.php3, 1080, Array ([name] => status, => on.gif,[conhelp] => Dedicated IIS application pool is enabled.,[direct_conhelp] => ,[skin] => Skin Object ([] => ,[] => Array (),[] => ,[] => ,[attr] => Array ([id] => 1,[name] => Default,[place] => default),[changableAttr_] => ,[oldAttr_] => Array ([id] => 1,[name] => Default,[place] => default),[errorAttr] => Array (),[reqAttr] => Array ([0] => name),[Table] => SkinTable Object ([tables] => Array ([0] => Skins),[fields] => Array ([0] => id,[1] => name,[2] => place),[] => Array ([id] => 2),[] => mysqli_result Object ([current_field] => ,[field_count] => ,[lengths] => ,[num_rows] => ,[type] => ),[] => ,[id] => 1,[idAttrIndex] => 0,[where] => ,[order] => ,[error_] => ,[errorMsg_] => ,[warnArr_] => Array ()),[needUpdate] => ,[idFieldName] => id,[] => ,[error_] => ,[errorMsg_] => ,[warnArr_] => Array ()),[i_handlers] => ))
#1 call_user_func_array(Array ([0] => Tooltip,[1] => key), Dedicated IIS application pool is enabled.) called at [C:\Program Files (x86)\Parallels\Plesk\admin\plib\elements.php3:1080]
#2 comm_icon(status, on.gif, Dedicated IIS application pool is enabled.) called at [C:\Program Files (x86)\Parallels\Plesk\admin\plib\iis\class.IIsAppPoolForm.php:99]
#3 IIsAppPoolForm->assign(IIsAppPoolMode Object ([_old_mode] => mixed,[_mode] => mixed,[error_] => ,[errorMsg_] => ,[warnArr_] => Array ()), IIsAppPool Object ([_node] => DOMElement Object (),[_websrvmng] => WebServerManager Object ([restart_] => 1,[options_] => Array (),[features] => Array ([WEB_Server_package] => iis,[WEB_Server] => Microsoft IIS,[WEB_FPAdminSysUser] => 1,[WEB_Performance] => 1,[WEB_MimeTypes] => 1,[WEB_VirtualDirs] => 1,[WEB_VirtualDirsFastCGI] => 1),[error_] => ,[errorMsg_] => ,[warnArr_] => Array ()),[_type] => 0,[_id] => ,[_inputableAttr] => Array ([0] => cpuUsage),[_errAttr] => Array (),[_enabled] => 1,[error_] => ,[errorMsg_] => ,[warnArr_] => Array ()), pool) called at [C:\Program Files (x86)\Parallels\Plesk\admin\plib\ui_common\IISAppPoolUIPointer.php:186]
#4 IISAppPoolUIPointer->accessItem(GET, ) called at [C:\Program Files (x86)\Parallels\Plesk\admin\plib\UIPointer.php:600]
#5 UIPointer->access(GET) called at [C:\Program Files (x86)\Parallels\Plesk\admin\htdocs\plesk.php:57]


Please assist