I've just purchased a new Dell Poweredge 2800 in order to run our production database. Currently it is running on an old 2800 using SQL Server 2000 Std. This is starting to come to the end of it's life as the database has grown rapidly in the past 12 months.
I've installed SQL server 2005 and restored a copy of the database to the new server. After following a few steps, I'm able to connect to the test database through the client software. However, whenever I save certain records (Job records), I get the following error:
Could not load the DLL xp_regex.dll, or one of the DLLs it references. Reason 1114 (error not found). The event ID is 17750.
The .net framework is up to date and the /3GB switch is not enabled in the boot.ini.
Any ideas? I can provide further information if required.
I need to get this server to a production level within 2 weeks so any help will be greatly appreciated!
Thanks in advance!