Help! Critical Error When Starting Server

05/05/2010 01:15 Anihilater#1
Code:
3564: CastServer Started
1368: Session Server Ready
2300: MsgServer Started
3564: Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).
]SQL Server does not exist or access denied.
3564: [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS
3488: Japan GameChu Login module loading Fail...
3488: <------------- Login Server Started ------------>
3488: ------------------ Connect Session Server IP : [Not Showing for obvious reasons] ---------
---------
I get this every time I try to start my server I have edited all of the correct files according to every tutorial I have seen my ip in all is set to my WAN IP I have a router which is set up to foreward all the ports to my pc in other words I have set up a DMZ and am using a personal firewall with all the correct ports open even if I turn off my firewall I get this error the dbuser and dbpass in both cast config and session config is set to my sqk user and pass so I am not understanding why i get this error. I have obdc data source set up for my sql server I thought that would fix it but it didn't. Any help would be appreciated

After the login server starts I then get a standard windows error saying there is a problem with sessionserver.exe and it needs to close. If that helps any
05/05/2010 03:35 abelwang#2
check again, thats' no connection between SQL. check the premission setting in SQL. and did you upgrade to SP 4? try check for ip setting, using localhost ip first. see if can connect.
05/05/2010 03:45 Anihilater#3
Quote:
Originally Posted by abelwang View Post
check again, thats' no connection between SQL. check the premission setting in SQL. and did you upgrade to SP 4? try check for ip setting, using localhost ip first. see if can connect.
Yes I have SP4 installed how do I check permissions to allow connections other than localhost I have tried using 127.0.0.1 which is localhost ip and still get the error so perhaps I didn't fully install sp4? or something else is messing up

Also if it helps I am running XP Pro x64 with 4gb RAM dual core 2.66 Ghz processor system is fully updated software wise
05/05/2010 06:06 Anihilater#4
Fixed the problem by reinstalling SQL 2000 + SP4
05/05/2010 06:23 abelwang#5
great. so this thread can be close now!
05/05/2010 09:05 ~Kakkarot~#6
#closed