Can not connect to MSSQL server after trial expired

Moderator: crythias

Locked
arvobowen
Znuny newbie
Posts: 55
Joined: 12 Jul 2010, 20:34
Znuny Version: 2.4

Can not connect to MSSQL server after trial expired

Post by arvobowen »

OK so I was running MSSQL 2000 for a while then moved to MSSQL 2008 Standard and had OTRS running on it great! I didn't even think about it but I had installed a trial version of MSSQL Server 2008 Standard. Well the trail was up and the server locked up the DB making OTRS unusable. Since then I have backed up the OTRS database, uninstalled MSSQL 2008 Standard, then installed MSSQL 2008 Express. I have attached the database and now have the MSSQL server up and running as well as have test the connectivity with a vbs script. When I try to check my trouble ticket site again I get the same error...


Error: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or a[..]

Comment: Please contact your admin
Bug Report:

Traceback: ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: MSWin32 Time: Mon Apr 4 12:14:41 2011

Message: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. (SQL-08001) [state was 08001 now 01000]
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). (SQL-01000)

Traceback (1644):
Module: Kernel::System::DB::new (v1.105.2.1) Line: 188
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 143
Module: PerlEx::Precompiler::c_::httpd::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48
Module: (eval) (unknown version) Line: 458
Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

Any ideas?
Operating System: Windows Server 2003 x86
Purpose: Information Technology Help Desk
OTRS Version: OTRS 2.4.7
arvobowen
Znuny newbie
Posts: 55
Joined: 12 Jul 2010, 20:34
Znuny Version: 2.4

Re: Can not connect to MSSQL server after trial expired

Post by arvobowen »

Operating System: Windows Server 2003 x86
Purpose: Information Technology Help Desk
OTRS Version: OTRS 2.4.7
Locked