I have a little problem

12/11/2012 18:47 Dorado18#1

I get the standard "Specified SQL Server not found" error, but it's not as straight forward as it looks.(For those who want to be ass holes). I've diagnosed this problem down as far as I could go, even looked at the hex.

Anywhore, apparently the Auth server isn't even attempting to connect to the SQL server. Everything else starts perfectly fine. Game Server, upload, logs, etc etc. I can even access it remotely. So I can only deduce from this that I'm missing something in the opt file for the Auth server.

Code:

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S db.auth.port:1433
S app.name:auth
S io.auth.port:4500
N game.user_limit:3000
N auth.max_client_per_ip:30000
S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000
S db.auth.md5_key:2011
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0

This is my authserver.opt file. Either I'm missing something from my opt file or this particular auth server is fucked.

I'm going to be starting a rappelz server, it's going to be the best one in existence. Who ever can help me with this annoyance, there might be a spot on the staff in it for you.

12/11/2012 18:59 ismokedrow#2

Want's to bet OP installed a "Named" SQL instance instead of a "Default" instance which is why he can't access his server via "127.0.0.1" bet if he tried to connect to his DB via SSMS @ 127.0.0.1 w/ windows auth it would error out to. Bet if he tried 127.0.0.1/instanceName it would work [being a named instance and all] (google search term: difference between default and named instances)

P.S.

I don't want a spot on your supposedly one-day Legendary Staff. Thanks anyway.

12/11/2012 18:59 emekpc#3

im back my words... :D

12/11/2012 20:08 Dorado18#4

Quote:

Originally Posted by ismokedrow

Want's to bet OP installed a "Named" SQL instance instead of a "Default" instance which is why he can't access his server via "127.0.0.1" bet if he tried to connect to his DB via SSMS @ 127.0.0.1 w/ windows auth it would error out to. Bet if he tried 127.0.0.1/instanceName it would work [being a named instance and all] (google search term: difference between default and named instances)

P.S.

I don't want a spot on your supposedly one-day Legendary Staff. Thanks anyway.

after viewing dozens of threads like these. I knew you'd bring your self righteous attitude in here eventually, and no, that is not the case. If it were, the game server wouldn't work. Also.

[Only registered and activated users can see links. Click Here To Register...]

What's this? Looks like me... logged in as loopback with windows auth and no instance.

If you want to be a dick, at least know what you're talking about.

12/11/2012 22:40 ismokedrow#5

[Only registered and activated users can see links. Click Here To Register...]

-cough-

[Only registered and activated users can see links. Click Here To Register...]

p.s

You're still doing it wrong.

12/11/2012 23:53 Dorado18#6

And you're still an ass. If you're not going to help people. Get out of the section, and don't come back.

p.s I fixed it. I was missing a dll file. Derp