- Joined
- Mar 18, 2013
- Messages
- 280
- Reaction score
- 14
how to fixed the LOGIN FAILED
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!how to fixed the LOGIN FAILED
Try to use the MSSQL server name... Like that on the Management Studio like this: "DESKTOP-TRASH\SQLEXPRESS01"
Permission Denied.
yes i already make it but is same login failedYour account usertype must be at least 20.. just set it to 30And make sure to update your gm_login with the included Stored Procedure..
yes i already make it but is same login failed
<?xml version="1.0" standalone="yes"?>
<groups>
<group>
<title>GMC</title>
<userdb>
<name>RanUser</name>
<ip>WIN-A01T0CV1HLI\SQLEXPRESS</ip>
<id>sa</id>
<pw>0mn1buZ$$$#@!1</pw>
</userdb>
<gamedb>
<name>RanGameS1</name>
<ip>WIN-A01T0CV1HLI\SQLEXPRESS</ip>
<id>sa</id>
<pw>0mn1buZ$$$#@!1</pw>
</gamedb>
<logdb>
<name>RanLogS1</name>
<ip>WIN-A01T0CV1HLI\SQLEXPRESS</ip>
<id>sa</id>
<pw>0mn1buZ$$$#@!1</pw>
</logdb>
</group>
</groups>
this is my config of my XML FILES but always get login failed and my usertype is 30 i already execute the GM_LOGIN
please help me
i'm not using encryption this is the password of my sqlTry removing the encryption with your password. use the plain one.
i'm not using encryption this is the password of my sql
is this correct ? itry login this on my gmc but still login failed.. please help me anyone.. itried all tut here
Do i need to add same info on GSUserInfo or just only UserInfo table??Make sure to run the sql query after making changes to your gm logins.
any desk to me please to fixed thisHave you already enabled the tcp/ip config of your sql? > If yes, have you restarted it? If No, retart it first > If YES and still gets the error, try checking if you have the GMCharEdit.cfg and delete it then try again.
any desk to me please to fixed this
done to pmpm me your anydesk
Do i need to add same info on GSUserInfo or just only UserInfo table??
Do it on both GSUserInfo & UserInfo jsut to be sure.
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[gm_login] Script Date: 3/8/2021 2:04:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[gm_login]
\@userId char(50),
\@userPass char(50),
\@authenticate char(50),
\@userIp char(50) OUTPUT,
@nReturn int OUTPUT
AS
DECLARE \@NuserNum int,
\@NuserType int
SET NOCOUNT ON SET
@nReturn = 0 SET \@NuserNum = 0
SELECT \@NuserNum = GSUserInfo.UserNum, \@NuserType= GSUserInfo.UserType
FROM
GSUserInfo
WHERE GSUserInfo.UserID = \@userId AND GSUserInfo.UserPass = \@userPass AND GSUserInfo.UserAvailable = 1 AND GSUserInfo.UserType>=20
-- ID / PWD ??...
IF \@NuserNum = 0 BEGIN
-- ID / PWD ??? ?? ???????
SET @nReturn = 0
END
ELSE
BEGIN
-- ID / PWD ??
SET @nReturn = \@Nuser+Type
-- ???? ???
INSERT INTO LogGmCmd (UserNum, GmCmd)
VALUES \@NuserNum, 'LOGIN GMTOOL UserID:' + \@userId)
END
SET NOCOUNT OFF
RETURN @nReturn
As far as I know, should just be GSUserInfo. If you find a reason to put it in the UserInfo table please inform me
Actually don't have a reason for it. I just did it back when i was testing your app and everything worked well so i just left it there on both
Guess i can remove it already then? Thanks!
Since most of you are having problems running the GMCharEdit using ADO. Here's my source
I have fixed and changed a few things.
- The ADO config does not use an encrypted user, pass, ip, and DB
- No more Xtremetools pro required
- Character name search works
if you want to see what i have changed, use winmerge
You must be registered to see links
You must be registered to see links
link to the config file: http://forum.ragezone.com/f528/share-gs-source-selling-1195341/index33.html#post9069869
GMCharEdit.xml
Code:<?xml version="1.0" standalone="yes"?> <groups> <group> <title>International Server</title> <userdb> <name>RanUser</name> <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip> <id>sa</id> <pw>1234</pw> </userdb> <gamedb> <name>RanGameS1</name> <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip> <id>sa</id> <pw>1234</pw> </gamedb> <logdb> <name>RanLogS1</name> <ip>127.0.0.1,50711 OR DESKTOP-TRASH\SQLEXPRESS01</ip> <id>sa</id> <pw>1234</pw> </logdb> </group> </groups>
Edit:
I guess it's not clear for some people:
Your account login should be saved in GSUserInfo with type 30 (specifically accounts with usertype at least 20). In other words, whatever GM account you login in-game is the one you also use for this tool.