VoIP Monitor no longer working after moving to SQL Server 2005?

To the Ipswitch web site

Ipswitch Forums
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



VoIP Monitor no longer working after moving to SQL Server 2005?Expand / Collapse
Author
Message
Posted 11/5/2008 10:16:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/24/2008 10:14:49 AM
Posts: 4, Visits: 15
Hi
I've recently moved our WhatsUp Gold v12 to a seperate MS SQL 2005 server and everything works great, except for the VoIP monitor tool. All the VoIP monitors we'd configured before the move are now showing as DOWN and when I try to run the VoIP monitor configuration tool, it throws an error to do with connecting to the database. There is nothing in the docs about the VoIP monitor needing special handling when moving the DB. Can anyone help? THanks

J
Post #48422
Posted 11/5/2008 2:00:49 PM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Ipswitch Employees
Last Login: Today @ 2:55:20 PM
Posts: 205, Visits: 940
Can you please export the "HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings" registry key of your WUG system and paste the contents in your reply?
Post #48441
Posted 11/13/2008 1:15:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/14/2008 3:53:30 PM
Posts: 3, Visits: 13
Have the same problem, here is my regkey (Password removed):

[HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings]
"DSN"="DSN=WhatsUp"
"CommandTimeout"=dword:0000003c
"DataSource_WhatsUp"="Persist Security Info=True;Initial Catalog=WhatsUp;Data Source=WHATSUP\\WHATSUP;Trusted_Connection=Yes"
"Username"="whatsup"
"Password"=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings\Log Expiration Settings]
"Action Activity Log Expiration Time Limit (Hours)"=dword:00000000
"Active Discovery Log Expiration Time Limit (Hours)"=dword:00000000
"Performance Monitor Log Expiration Time Limit (Hours)"=dword:00000000
"General Error Log Expiration Time Limit (Hours)"=dword:00000000
"Passive Monitor Error Log Expiration Time Limit (Hours)"=dword:00000000
"Recurring Report Log Expiration Time Limit (Hours)"=dword:00000000
"System Activity Log Expiration Time Limit (Hours)"=dword:00000000
"Web User Activity Log Expiration Time Limit (Hours)"=dword:00000000
"Remote Server Log Expiration Time Limit (Hours)"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings\RDC Rollup Settings]
"RDC Rollup Number Of Threads"=dword:00000001
"RDC Raw Expiration Time Limit (Hours)"=dword:00000018
"RDC Hourly Expiration Time Limit (Hours)"=dword:000005a0
"RDC Daily Expiration Time Limit (Hours)"=dword:00002238

[HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings\Sample Rollup Settings]
"Removal task interval (Minutes)"=dword:0000000a
"Raw Sample Expiration Time Limit (Hours)"=dword:00000018
"Hourly Sample Expiration Time Limit (Hours)"=dword:000002d0
"Daily Sample Expiration Time Limit (Hours)"=dword:00002238
"Daily State Change Expiration Time Limit (Hours)"=dword:00002238
"Maximum # records to delete"=dword:0000012c
"RDC Raw Expiration Max (Days)"=dword:0000000e
"Passive Activity Log Expiration Time Limit (Hours)"=dword:00002238

------------------------------------------------------------------------

And here is the error message:

************** Exception Text **************
System.Exception: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at WhatsUp.CDb._OpenConnection()
   at WhatsUp.DBHelper.GetDeviceWithSnmpCredentials()
   at WhatsUp.DeviceListPage._PopulateDeviceListView()
   at WhatsUp.DeviceListPage.DeviceListPage_SetActive(Object sender, CancelEventArgs e)
   at WhatsUp.WizardPage.OnSetActive(CancelEventArgs e)
   at WhatsUp.WizardSheet.SetActivePage(WizardPage newPage)
   at WhatsUp.WizardSheet.buttonNext_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
VoIPConfigTool
    Assembly Version: 12.0.1.900
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/VoIPConfigTool.exe
----------------------------------------
Wizard.Net
    Assembly Version: 1.0.3089.24419
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/Wizard.Net.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Interop.CoreAspLib
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/Interop.CoreAspLib.DLL
----------------------------------------
CoreVoIP.NET
    Assembly Version: 12.0.1.900
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/CoreVoIP.NET.DLL
----------------------------------------
Core.NET
    Assembly Version: 12.0.1.900
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/Core.NET.DLL
----------------------------------------
CoreNm.NET
    Assembly Version: 12.0.1.900
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/CoreNm.NET.DLL
----------------------------------------
CoreInterfaces.NET
    Assembly Version: 12.0.1.900
    Win32 Version: 12.0.1.900
    CodeBase: file:///D:/Program%20Files/Ipswitch/WhatsUp/CoreInterfaces.NET.DLL
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.42 (RTM.050727-4200)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

Post #48726
Posted 11/13/2008 2:17:00 PM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Ipswitch Employees
Last Login: Today @ 2:55:20 PM
Posts: 205, Visits: 940
Can you also export the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\WhatsUp registry key and paste the contents?
Post #48728
Posted 11/13/2008 2:53:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/14/2008 3:53:30 PM
Posts: 3, Visits: 13
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\WhatsUp]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Description"="WhatsUp Database"
"Server"="gerrard"
"Database"="WhatsUp"
"LastUser"="whatsup"
Post #48730
Posted 11/13/2008 3:09:26 PM
Time Traveler

Time TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime TravelerTime Traveler

Group: Ipswitch Employees
Last Login: Today @ 2:55:20 PM
Posts: 205, Visits: 940
Aha. I see that the WhatsUp DSN is referring to "gerrard" server whereas the "DataSource_WhatsUp" value under the "HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings" is referring to "WhatsUp" server.

Delete the "DataSource_WhatsUp" value under "HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\Network Monitor\WhatsUp Engine\Database Settings" key in the registry and then restart the WhatsUp Polling engine service. That should fix the issue. Let me know how it goes.

Post #48731
Posted 11/13/2008 3:14:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 11/14/2008 3:53:30 PM
Posts: 3, Visits: 13
Whoho, thanks! It's alive
Post #48733
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Jason Benton, Jason Williams

PermissionsExpand / Collapse

All times are GMT -5:00, Time now is 6:24pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 10 queries. Compression Enabled.