xp_msver giving me trouble on 1 server
I have 1 SQL 2000 server on SP4 that gives an error message when running the xp_msver procedure. Apparently, This procedure is used by SQL Backup when connecting to it. I am running SQL Backup 126.96.36.199 from my desktop (not the server in question), and am trying to look at all of the registered servers I have. Not all of my servers have SQL BAckup installed, yet. On One of the ones were SQL Backup is not installed, SQL Backup is unable to connect and gives the following message in the bottom left frame:
xp_msver: Unable to determine server language version.
4/14/2006 11:45:49 AM
When I run xp_msver on the server itself, I get the same message.
Naturally, this places the problem with the SQL install itself, but as this server is pretty much a 24/7 server, I don't have much chance of messing around with the xplog70.dll and stopping and starting SQL Server.
Is there anyway I can circumvent the problem? I would try installing the full install on the server if I thought it would help, but I doubt it will. I'll simply have the same issue when it tries to connect locally.
HMM, I guess / hope that this is strictly a GUI issue. Should I be able to run the install successfully? If yes, I can at least get my backups running using the jobs I have created. The GUI is just a nice check up tool for me.