Error while creating a server

lucarossini · 07/16/2014, 03:48

Hi,

Today I was trying to set up a server following this ->

tutorial.
Everything went fine till the end, exept for the fact that whenever I start the server, every service is stuck in pause (starts for a few seconds but quickly pauses again).

I did everything according to the guide, the server should be lan so everything is on 127.0.0.1

Looking in many threads I just found "check ini files for mistakes in user/password .." but rest assured they are correct, I checked so many times that I'm about to learn the encrypted password by memory.

Here are the logs that appear each time I start the services:

From ShaiyaServer\PSM_Client\Bin\Log

Spoiler

Additional info : I created the user in SQL Server Management with all the correct permissions, the .ini files ARE CORRECT and match with the password
I enter in the main panel of the server (of course in the .ini it is encrypted).
I made 2 more users with 2 different passwords, always stuck at the same point.

Boul27 · 07/16/2014, 14:24

It's a probleme withyour SQL account

Be sure that the encrypted password in your .ini is correct
try to connecte in SQL Server Management with a sql account (like Shaiya/Shaiya123 ) to check the permissions n this account (don't use the windows authentification)

I'm not a pro, but maybe it can help you

lucarossini · 07/16/2014, 14:53

The .ini files are correct. I can connect manually with SQL management using the user data that I wrote in the server config. The account has maximum DB permissions..

Boul27 · 07/16/2014, 15:02

Hum, if you can connect with your account, it's very strange

wait for better help than mine

Sorry, and good luck

lucarossini · 07/17/2014, 23:38

To anyone having this issue, after hours of searching I finally found a solution, just needed to use a different version of SQL Server (R2 Service Pack 2) and same for Management.

The topic can be closed.