sql doesnt service dont start

[resinate]

when i try to install a brand new sql server never used on a tower, i get cannot start service error 0

yes ive ran servers for years but these new bugs are raping me.

 

[Kameleon20]

uninstall sql server and make also sure the service is ended and no traces left in the register or in program files.
then reboot your pc, reinstall it and it shoud work

 

[aceindy]

For somebody who runs it for years you provide a amazing little info :-/
Then again, you didn't ask anything either...so why care?

 

[resinate]

i fixed the sql long ago, ascent cant run when u have more then 1 comp on the network using linksys.

i added a duel core comp on my network and destoryed my server on the other comp cuz of the ips clashing in server and sql db.

 

[aceindy]

ascent cant run when u have more then 1 comp on the network using linksys.

Still don't have a clue what you mean; we're running a multi-realm for 3 realms for more then a year; at one sight we run 2 sql servers (and yes, we use linksys too).

 

[resinate]

ok heres what you u do, if u guys use linksys and have more then 1 comp

take off ALL but 1 and reboot the router, the lan ip should be forced 192.168.1.100, MAKE SURE IT SAYS 100

in the confs

ascent_world.conf and ascent-logonserver MAKE SURE THE LISTENING PORTS ARE 0.0.0.0

logon=

<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"


world=
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">


for the db part make sure u have db on the cpu with the server files

and for the db ip use 127.0.0.1

for the realm use a normal realm and do this
<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">

<Realm1 Name = "REALM NAME"
Address = "WANIP:8129"

make sure u forward ports in the router

after server is all done plug the other comps into the router and play.

some comps may need this little guide. mine was for sure each comp is dif.

 

[Kurohane]

i fixed the sql long ago, ascent cant run when u have more then 1 comp on the network using linksys.

That's a bunch of bullshit. I used to run my server with 6 computers, 2 laptops, and 3 game consoles on my linksys.

 

[Kurohane]

ok heres what you u do, if u guys use linksys and have more then 1 comp

take off ALL but 1 and reboot the router, the lan ip should be forced 192.168.1.100, MAKE SURE IT SAYS 100

in the confs

ascent_world.conf and ascent-logonserver MAKE SURE THE LISTENING PORTS ARE 0.0.0.0

logon=

<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"


world=
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">


for the db part make sure u have db on the cpu with the server files

and for the db ip use 127.0.0.1

for the realm use a normal realm and do this
<LogonServer Address = "127.0.0.1"
Port = "8093"
Name = "Default Logon"
RealmCount = "1">

<Realm1 Name = "REALM NAME"
Address = "WANIP:8129"

ROFL!!! You forwarded the ports to the wrong IP address....*dies of laughter*

 

[FroZenFiRe]

when i try to install a brand new sql server never used on a tower, i get cannot start service error 0

yes ive ran servers for years but these new bugs are raping me.

U using xp >? if so go to start button, control panel., administrative tools, then dbl click services
scroll down and see if mysql is running or not , If it is make sure its the correct one

 

[WiKKiD]

Wow, dude.. You're like the most clueless admin out there. Absolutely no idea what's goin on when it comes to networking, huh? Lol.

Your server must be great. Rofl.