[HELP]Session Server Error

[WendX]

HELLO GUYS!
I publish here again to comment about my error: session server error. Basically this executable fails to load and my not connecting server. I accessed all topics of this forum for the same error. The problem is to replace or attempt to add back the following codes not solved this problem. Someone help me to solve this?
Executable too are working well. There is this failure only

I inserted the code below in Query Analyser:
1°

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

_

2°

exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

[janvier123]

stop PMing me or ill ban you


Read:

[6shadow6]

Why you not wait.
when you want get more info about some error just run some exe and wait till you will see something like session is start.

Stop sill press bottom on mouse sometimes just wait. Then run next exe

On your screen we don't see error but i thing you have something wrong on sql configuration

[WendX]

13:18:11 1D00 ------------------ Connect Session Server IP : [ 127.0.0.1 ] ------------------
13:18:20 1F9C Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server inexistente ou acesso negado.
13:18:20 1F9C [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS
13:18:24 13EC Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server inexistente ou acesso negado.
13:18:24 13EC >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
13:18:24 13EC File: .\Config\Provider.cpp, Line: 79


i am getting this error? please help

[6shadow6]

do you turn on TCP/IP watch video

[freez00]

#1 You need to have the database names set up in the ODBC
#2 Like Shadow said, make sure you turn on TCP/IP for SQL Server. you will need to download the SQL Server management studio with the management tools.
#3 Make sure the config.ini is properly set up for each server and you have the right SQL username & password.

Your error is telling you that it can't connect to the database. Unfortunately if you don't understand any of this then you shouldn't be trying to set up a server. Setting up a server requires knowledge of SQL server database, networking and programming.

[conquer93]

If i remember correctly someone told me ODBC is only required if you're like hosting a website for your server ? , and the TCP/IP what Shadow said i never had to do that either to make my server load up without errors ?

[6shadow6]

conquer93 you have right, odbc is needed only when we use regpage with using odbc.

i help him and i have right TCP problem. and one more he using old sql 2000 and i think he not install SP for this sql.

P.S. conquer93 if you use old sql like 2000 you not get this problem with TCP.

Now we use 2008, 2012 or even 2014 like me and some other ppl.

[freez00]

I thought the older databases for DK square needed the ODBC? On 64bit machines you need to add the databases to the 32bit ODBC in the syswow folder, not the ODBC from the Administrative tools.

As for TCP/IP, if he is using SQL Server Express then TCP/IP isn't on by default. In 2012 and 2014 TCP/IP is on by default. But it's still always good to check just in case.