[HELP]Session Server Error

06/21/2015 03:02 WendX#1
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? :confused:
Executable too are working well. There is this failure only
[Only registered and activated users can see links. Click Here To Register...]
I inserted the code below in Query Analyser:
1°
Code:
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°
Code:
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'
06/21/2015 10:05 janvier123#2
stop PMing me or ill ban you


Read: [Only registered and activated users can see links. Click Here To Register...]
06/21/2015 13:09 6shadow6#3
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

06/21/2015 18:27 WendX#4
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
06/21/2015 19:06 6shadow6#5
do you turn on TCP/IP watch video
06/21/2015 20:26 freez00#6
#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.
06/22/2015 00:01 conquer93#7
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 ? :D
06/22/2015 06:15 6shadow6#8
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.
06/25/2015 21:00 freez00#9
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.