Error With Session Starting?!

I have an issue with the session starting in server patch config, I was hoping somebody was willing to lend a hand. They just start up and go back to pause.




This is what it says in the PS_Session_system.txt file:

2010-06-22 05:08:41 PS_SESSION__system log start (Session)

2010-06-22 05:08:42 userlog connect failed

2010-06-22 05:08:42 initserver() failed

2010-06-22 05:08:42 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-22 05:08:42 PS_SESSION__system log end (Session)

2010-06-22 05:08:42 3 1 SService::ServiceCtrlDispatcher(): service shutdown



Then it says this in PS_Userlog_session.txt:

2010-06-22 05:08:39 PS_USERLOG__system log start (UserLog)

2010-06-22 05:08:56 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

2010-06-22 05:08:56 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2010-06-22 05:08:56 PS_USERLOG__system log end (UserLog)

2010-06-22 05:08:56 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Anyone got any idea?

Are you able to log into the database? If not then uninstall and reinstall SQL correctly.

yes we can log in to database fine with 127.0.0.1 and Shaiya, Shaiya123

Ah Adam. How are you? Did you guys move anything? What happened right before it stopped working?

2010-06-22 05:08:56 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

Above tells you what the problem is.. just not what is causing it. Could be many things. Exceptions, DB missing, Server host name change, Moved DB's, corrupt DB's, incorrect IP's, etc etc.. Holler at me on Skype and I can possibly teamview if you like. Otherwise we going to need more info and/or logs.

Skype: phish.aka.blatrix

~Phish

Edit: Sorry Im currently on my server Skype account "admin-phish"

im fine thanks mate :)

Well we set up server from scratch and followed everything down to a T. Used the EP4 Server Foles for C:/ drive that was posted on RZ (as host only has C:\ Drive) it might be corrupt databses but they seem fine to me as i can open them and view tables. Ill holler at you on skype then see what's going on :)

Quote:

Originally Posted by adamkoolkid2 im fine thanks mate :) Well we set up server from scratch and followed everything down to a T. Used the EP4 Server Foles for C:/ drive that was posted on RZ (as host only has C:\ Drive) it might be corrupt databses but they seem fine to me as i can open them and view tables. Ill holler at you on skype then see what's going on :)

Ouch.. I'm unfamiliar with C:/ server file setup.. but I heard that there is alot that needs to be changed in .ini's in order to get it to work.. and then its buggy. However I'll still look if you want.

well i think it was already modded for working on C drive as it set up fine. But yeah if you could take a look on TV that would be great :)

install again sql expres 2005 and it will make u MSQLEXPESS and go to sql server configuration menager stop SQLEXPRESS and start MSQLEXPRESS and install server again and it will work session

We got it all figured out thanks

yeah the problem was that we installed SQL with Named Instance. We reinstalled it with default instance and got it working. Thanks anyways guys!

I reinstalled SQL with Default instance and still im having issues with session... My logs are the same that ariez posted and i on't know what else i can do, i shutted down firewalls anti virus checked msql a thousand times and nothing... So can anyone tell me what else can i do to fix this?

Edit: Also my database is EP5 and my server files are EP5

im still having problem's with the Session starting i got it in the D:\ driver and isntalled all the BS but for some rreson still wont let me >.< any one know what i can do ?

You have to read your logs and check in there what is giving you issues, by reading your logs you will be able to know what is happening

Quote:

Originally Posted by grristheone im still having problem's with the Session starting i got it in the D:\ driver and isntalled all the BS but for some rreson still wont let me >.< any one know what i can do ?

Make sure your Shaiya login on your SQL server is all correct, especially if you're using SQL Server 2008, it has a few new protocols to follow when using databases created by other users.

Tyler

im not using sql 2008 im using sql 2005 this is the error i get with the log's

2011-10-15 13:31:38 PS_SESSION__system log start (Session)

2011-10-15 13:31:39 userlog connect failed

2011-10-15 13:31:39 initserver() failed

2011-10-15 13:31:39 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-10-15 13:31:39 PS_SESSION__system log end (Session)

2011-10-15 13:31:39 3 1 SService::ServiceCtrlDispatcher(): service shutdown
=\ anyone