|
| | | Supreme Being
Group: Ipswitch Employees
Last Login: Yesterday @ 9:02:27 AM
Posts: 126, Visits: 538 |
| | Ok, that looks correct too. I am stumped as to why you would be getting the error message that you are. Can you please post your exact error message again? |
| |
| | | Forum Member
Group: Forum Members
Last Login: 6/30/2008 12:56:56 PM
Posts: 43, Visits: 129 |
| | please see my edited post back one page, which basically says the name of the computer is NDWhatsup and not ndvmware if the results of the command should ref the computer name. when attempting to change an active monitor script that already exists, or when attempting to add a new monitor to an existing device i receive: error window titlebar: Failed to update monitor type error window description: "Error = 80004005 ErrorMessage=Unspecified error Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'NDWHATSUP\WHATSUP' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers." i have executed the stored procedure, although not setting an output, which ran in a command window and did not display any errors. although it took me a few tries to get the command just right |
| |
| | | Supreme Being
Group: Ipswitch Employees
Last Login: Yesterday @ 9:02:27 AM
Posts: 126, Visits: 538 |
| | Ah! - that makes a lot more sense now. Extract the attached file to C:\ and then run following command in a command prompt window: osql -E -D WhatsUp -i C:\rename_sql_server.sql -o C:\rename_output.txt and then restart the "SQL Server (WHATSUP)" service
|
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 6/30/2008 12:09:43 PM
Posts: 6, Visits: 15 |
| Hello,
I have the same problem with different servernames.
So I used your attached file and edit it for my system.
But I get an error in rename_output.txt
1> 2> Msg 102, Level 15, State 1, Server NewServer\WHATSUP, Line 1
Incorrect syntax near '\'.
1> 2> 3> Msg 102, Level 15, State 1, Server NewServer\WHATSUP, Line 2
Incorrect syntax near '\'.
1> 2>
Could you explain this?
Thanks.
|
| |
| | | Supreme Being
Group: Ipswitch Employees
Last Login: Yesterday @ 9:02:27 AM
Posts: 126, Visits: 538 |
| | Sorry, I forgot to enclose the names is single qoutes. Edit the rename_sql_server.sql to looks like: sp_dropserver 'OLDNAME\WHATSUP'
go sp_addserver 'NEWNAME\WHATSUP'
go Also make sure that the DSN used by Whatsup (most likely called WhatsUp) points to NEWNAME\WHATSUP. To check this, look at 'Server' value under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\WhatsUp (assuming that your DSN is called WhatsUp). |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 6/30/2008 12:09:43 PM
Posts: 6, Visits: 15 |
| Hello,
I did this changes. But now the the file servername.txt seems:
------------------------------------------------------------------------------
--------------------------------------------------
NULL
(1 row affected)
and I have a different error in WhatsUp.
Error=80004005
ErrorMessage=Unspecified error
Description=.... Server 'NewServer\WhatsUp' is not configured for DATA ACCESS.
DNS and and registry is ok. |
| |
| | | Supreme Being
Group: Ipswitch Employees
Last Login: Yesterday @ 9:02:27 AM
Posts: 126, Visits: 538 |
| | What is the name of the system where SQL server is installed? |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 6/30/2008 12:09:43 PM
Posts: 6, Visits: 15 |
| | RAS4 It's on the same server where WhatsUp is installed. |
| |
| | | Supreme Being
Group: Ipswitch Employees
Last Login: Yesterday @ 9:02:27 AM
Posts: 126, Visits: 538 |
| | Ok, then change your rename_sql_server.sql to: sp_addserver 'RAS4\WHATSUP' go save the changes and then run: osql -E -D WhatsUp -i rename_sql_server.sql -o rename_output.txt |
| |
|
|