Disconnect from server after Char Selection

[[ADM]Haydees]

OK I know this has been explained a million and 1 times.
I have looked at over 10 posts already but nothing is fixing this issue.
I was getting DCd from Server Selection, but I fixed that.
Now I select a char to start, but instant DC from server.

PS_DBAgent_SystemLog

 Spoiler

2018-04-21 03:04:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2018-04-21 03:04:45 ::LoadCharacter 1 123 qerr=-1, {? = call [usp_Read_User_CashPoint_NCash](?,1,'Haydees')}

2018-04-21 03:04:45 ErrorMsg=, SQL STATE: 00000, NATIVE ERROR: 0 (0x0)

All of my other logs are fine, no errors.

First of all, I am not using the sa account. I have disabled it from the login properties.
Second, I already have another server up, this is a second one, and I have checked the current one with this new one and it seems ok.

I have done everything I can think of as well as followed all the comments on here, but with no luck. Linked Server has been done, IPs are correct in the INIs, DB is working fine.
I am not a pro with these stupid logs, But I can usually tell the error by reading.. I have no idea what this one is though.

Oh and yes I did the /vchkoff and /nprotectoff commands

Any help is greatly appreciated. Thanks in advance

[[ADM]SpyRow]

Try this

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_User_CashPoint_NCash] Script Date: 4/21/2018 12:02:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*================================================= =
@author lenasoft @ 2006-09-28 @
@brief N-Cash DB에서 포인트를 가져온다.

잔액 확인
procGetCashBalance

유저 ID @ AS VARCHAR(12)
유저 UID @UserNumber AS BIGINT
캐쉬 잔액 @cashBalance AS INT OUTPUT
================================================== */
ALTER PROCEDURE [dbo].[usp_Read_User_CashPoint_NCash]
@CashPoint int OUTPUT, @ID int, @ varchar(12)

AS

SET NOCOUNT ON

SET @CashPoint = 0

SELECT @CashPoint=ISNULL(Point,0) FROM game.PS_UserData.dbo.Users_Master WHERE UserUID @ID
IF @CashPoint < 0
BEGIN
UPDATE game.PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID @ID
SET @CashPoint = 0
end

SET NOCOUNT OFF

[[ADM]Haydees]

I will give this a try and let you know SpyRow.
I ended up attaching a new Database for the time being, but I will be using that one again in the next day or 2.

Thank you very much

[{Skrillex}]

Originally Posted by [ADM]Haydees

I will give this a try and let you know SpyRow.
I ended up attaching a new Database for the time being, but I will be using that one again in the next day or 2.

Thank you very much

Hi,
i think there is no problem with that procedure. It seems that you don´t have insertet the correct SQL-Login credintials. Please check your credintials in all .inis and linked server. Also for your SQL-User "sa"

2018-04-21 03:04:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

Regards

[[ADM]Haydees]

Hey Skrillex,

I have the same PW in SQL for both sa and the login I use, but I have sa disabled and not using it.
My INIs are all showing up correct, as for linked server I tried that but it just comes up saying they already exist. That's when I got confused lol

[{Skrillex}]

Originally Posted by [ADM]Haydees

Hey Skrillex,

I have the same PW in SQL for both sa and the login I use, but I have sa disabled and not using it.
My INIs are all showing up correct, as for linked server I tried that but it just comes up saying they already exist. That's when I got confused lol

You have to drop your old linked servers. When you have everywhere the same name and the same passwords it should work.

Regards

[[ADM]Haydees]

Ive attached the DB again and tested it out. Got the error, so then I added the linked server and other script from SpyRow. Problem solved. but there are other issues on this DB so I am scrapping it. I have a fresh DB now which was built only a few weeks ago.

Thank you guys for your help. Appreciated