[Solved] Aceonlione 3.5 - Preserver cant connect to DB

CPreIOCP::IOCPInit_ | PreServer IOCPInit Error

I know, I know,

this error is a common thing but I just can't fix the problem.

Programming and setting up servers is normaly not my job. But I would love to have my own server for me and some friends. This means my server is running on a Windows 2008 R2 root server to have it 24/7 online and getting best performance.

And here is my problem: I try to start the Preserver and it is never able to connect to the DB.
No matter what type of fix I tried (possibly just too stupid) it never worked.

Here my 'global.cfg' global.cfg - Pastebin.com

and here is my latest log of the preserver Preserver log - Pastebin.com (got several of them but with different IP's, all look the same)

I am really losing all hope. I used the EP. 3.5 tutorial on this forum. Did everything as described.

Thanks for reading

Blackstern

PS: As I have to work tomorrow (it's almost 2 am right now) I will have a look here in about 20 hours. I appreciate every answer and thank you very much for the time you take to help others.

From the looks of it, you most likely did not enable TCP/IP in MSSQL.

Here is a very quick explanation on what you need to do to open it up properly: https://msdn.microsoft.com/en-us/lib...(v=vs.90).aspx

This error log is quite wide. I posted numerous times already what can go wrong on a connection attempt between the Game Server and the SQL Server.

Could you also post the SQL Network configuration? You can view this by starting the SQL Server Configuration Manager then:
SQL Server Network Configuration
-> Protocols for MSSQLSERVER

Another idea would be to check if the SQL Server allows SQL Authentication because by default it only allows Windows Authentication. You can check this by right clicking on your SQL Server in the SQL Server Management Studio -> Go to Properties -> Security and then check whether "Allow SQL and Windows Authentication" is checked.

Thanks for the fast answers,

TCP/IP is enabled. I am not quite sure about the SQL Server Authentication. Gonna need to reinstall SQL as I choosed the Windows one.
Going to tell you this evening if it worked.

Quote:

---

Originally Posted by Blackstern

Thanks for the fast answers,

TCP/IP is enabled. I am not quite sure about the SQL Server Authentication. Gonna need to reinstall SQL as I choosed the Windows one.
Going to tell you this evening if it worked.

---

You don't need to reinstall it. You can check the "Allow SQL and Windows Authentication" Radio Button in the SQL Server Management Studio when right clicking on your SQL Server in the Security Properties :)

http://i21.servimg.com/u/f21/14/11/12/87/sql_se10.png

I needed to reinstall it because that function was blanked out. I couldn't enable it.
Then I had trouble finding another download link for MSSQL because the mainlink on MS-website didn't work for today... Found another one.
Now I am at the beginning of the installtion of a MSSQL server. So it'll take a while for a new update
in this thread whether I fixed it or not.

Quote:

---

Originally Posted by Blackstern

Then I had trouble finding another download link for MSSQL because the mainlink on MS-website didn't work for today...

---

Sometimes you have to use the manual download links from MS, because the automatic ones are not working, but the direct download should still work.

Nothing works. I am too stupid for this. I am sitting there like in St34lth4ng3l's profile pic the whole time.
Going back to other games. Thanks for everyone here and I am sry that I wasted your time.

Edit: St34lth4ng3l helped me to install a server. It is running properly now. The thread is now tagged as 'solved'.

Sincerely

Blackstern