I am running on Win XP PRO with SP3 and 3GB RAM, SQL2000 EVAL with SP4.
I'm sorry I have searched everywhere and tried the solution suggested by ttadast. I can run all other servers app, except the session server app with crash error and this is exact error from the event log > >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
Here is where I messed up > I got the wrong SQL2000 SP4 version.
For those who made the same mistake or is getting the same error with session server, this is how to fix it:
By using a browser, locate the SQL Server 2000 Service Pack 4 download page at
To view the content, you need to sign in or register
.
On the SQL Server 2000 Service Pack 4 page, click Download files below, and then click SQL2000-KB884525-SP4-x86.EXE.
In the File Download dialog box, click Save.
Run SQL2000-KB884525-SP4-x86-ENU.EXE
SAVE install Files to C:\SQL2KSP4
Go to C:\SQL2KSP4\Setup.bat
How to identify your SQL Server version and edition?
To view the content, you need to sign in or register
or Go to MS SQL Query Analyzer and execute:
SELECT @@Version
You should be see this for Database Components SP4
8.00.2039
A big thanks to all the kind people for contributing to this private server. Especially, Cyber the Master.