Disconnect from server after Char Selection

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


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

Try this

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

Quote:

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"

Quote:

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

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

Quote:

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

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