Service Error

Results 1 to 9 of 9
  1. #1
    Apprentice Rinty is offline
    MemberRank
    Sep 2012 Join Date
    8Posts

    Service Error

    So I'm trying to run my services and they were working fine earlier. But currently the services I can't run are.

    _Account DB Server
    _AccountLog DB Server
    _World00 Character DB Server
    _World00 GameLog DB Server

    The rest of the services run fine. This happened because I had a problem earlier trying to log on, the client would give me "connection failed". So I tried deleting the services with cmd and redoing it. But then these errors are all that come up for those services. I'd like some help as fast as possible, I've been trying to fix this all night. Thanks :/

    services.jpg odbc-setup.jpg
    Code:
    ;-----------------------------------------------------------------------------------
    ; ODBC INFO
    ;-----------------------------------------------------------------------------------
    ;	  NAME		nDBID		nWorldNoConnection INFO			       Startup Command
    ODBC_INFO "Account",	0,		0,	"DSN=Account;	UID=sa;	PWD=cookies101", "USE Account;		SET LOCK_TIMEOUT 5000"
    ODBC_INFO "AccountLog",	1,		0,	"DSN=AccountLog;UID=sa;	PWD=cookies101", "USE AccountLog;		SET LOCK_TIMEOUT 5000"
    ODBC_INFO "StatisticsData",	2,		0,	"DSN=StatisticsData;UID=sa;	PWD=cookies101", "USE StatisticsData;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "OperatorTool",	3,		0,	"DSN=OperatorTool;	UID=sa;	PWD=cookies101", "USE OperatorTool;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "World00_Character",	10,		0,	"DSN=World00_Character;	UID=sa;	PWD=cookies101", "USE World00_Character;	SET LOCK_TIMEOUT 5000"
    ODBC_INFO "World00_GameLog",	11,		0,	"DSN=World00_GameLog;	UID=sa;	PWD=cookies101", "USE World00_GameLog;	SET LOCK_TIMEOUT 5000"
    
    #END
    Before somebody says to search it again I've done that awhile ago and only found this thread that wasn't helpful at all.

    http://forum.ragezone.com/f594/serve...-issue-790303/

    Bottom attachments are in this order:

    _Account DB Server
    _AccountLog DB Server
    _World00 Character DB Server
    _World00 GameLog DB Server (couldn't upload, probably reached max uploads idk)
    Attached Files Attached Files
    Last edited by Rinty; 24-06-13 at 03:51 AM.


  2. #2

  3. #3
    Apprentice Rinty is offline
    MemberRank
    Sep 2012 Join Date
    8Posts

    Re: Service Error

    I hope you actually read through some of those lol. 4 of them have no real answer, the remaining are either wrong password or wrong setup for ODBC. Which I made sure is the right setup following this tutorial. How to make a Fiesta Private Server [Part 1] - YouTube.

    Looking for help please :/

    P.S. I'd like to point out on my post that I said all of the services were working fine in the beginning.
    Last edited by Rinty; 24-06-13 at 03:57 AM.

  4. #4
    Account Upgraded | Title Enabled! darielgames312 is offline
    MemberRank
    Oct 2012 Join Date
    247Posts

    Re: Service Error

    If you reinstall everything from scratch chances are it'll work.

  5. #5
    Apprentice Rinty is offline
    MemberRank
    Sep 2012 Join Date
    8Posts

    Re: Service Error

    Nope I did that, first time I did it I uninstalled and deleted everything and reinstalled the server. Still didn't work, then I did a system restore and did it again but still didn't work.

  6. #6
    Valued Member DeadlyAsZyklonB is offline
    MemberRank
    May 2013 Join Date
    FontainebleauLocation
    105Posts

    Re: Service Error

    i've the same error, re set up the server, delete and re add services but accountlog and world wont start...

    Edit : it's a SQL server error, idk why sometimes it works then error 26 (you can't log in, sql can't find the server)

    2nd Edit : i found it, it's about SQL server when the protocols are off, you have to turn them on in SQL Server Configuration Manger for your SQL server instance ( Turn On TCP/IP) then restart SQL service for your instance.

    To avoid this error, switch off your pc propely.
    Last edited by DeadlyAsZyklonB; 24-06-13 at 02:44 PM.

  7. #7
    Apprentice Rinty is offline
    MemberRank
    Sep 2012 Join Date
    8Posts

    Re: Service Error

    Quote Originally Posted by DeadlyAsZyklonB View Post
    i've the same error, re set up the server, delete and re add services but accountlog and world wont start...

    Edit : it's a SQL server error, idk why sometimes it works then error 26 (you can't log in, sql can't find the server)

    2nd Edit : i found it, it's about SQL server when the protocols are off, you have to turn them on in SQL Server Configuration Manger for your SQL server instance ( Turn On TCP/IP) then restart SQL service for your instance.

    To avoid this error, switch off your pc propely.
    I tried that, I found TCP/IP disabled under SQL Server Network Configuration > Protocols for SQLExpress in the SQL Server Configuration manager. I enabled it and restarted the SQL Service but it still keeps coming up with that error.

    Code:
    000021 2013-06-24 14:32:22 *FAILED START LISTEN SOCKET*
    If I can just fix this weird port error everything will be good. :/

    Well I fixed it some how I guess, I had to change the ip back to 127.0.01 and all the services run now. I don't know how I'm gonna port forward this if it won't let me use my ip but I'll figure that out later. In the mean time I have another issue. Every account I made in the database, when logging on the client I would get a wrong password error. I made 4 accounts now and its still saying wrong password. :/
    Last edited by Rinty; 25-06-13 at 04:40 AM.

  8. #8
    Account Upgraded | Title Enabled! aqua512 is offline
    MemberRank
    Nov 2012 Join Date
    574Posts

    Re: Service Error

    lmao its because the pw is md5 and the launcher ur using doesnt read md5

  9. #9
    Account Upgraded | Title Enabled! Evildarkang is offline
    MemberRank
    Sep 2012 Join Date
    Northfield, BirLocation
    417Posts

    Re: Service Error

    If your still having trouble drop me a line
    Last edited by Evildarkang; 03-07-14 at 07:44 AM.



Advertisement