Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 11:19

  • Please register to post and access all features, it's quick, easy and FREE!

 

SQL problems

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
SQL problems

Hi guys i need some help connecting to sql server 2014.
I use this guide for lvl 99 rohan server.
According to the guide you have to change
Quote:
C:\xampp\htdocs\RohanAuth\include\dbconn.php
ServerName = your computer name
uid = sa
pwd = your mssql pass
My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?

My SQL log are





sariusmt is offline  
Old   #2
 
elite*gold: 0
Join Date: Jul 2014
Posts: 66
Received Thanks: 8
I have the same problem hope someone will help us


SkyZer0 is offline  
Old   #3
 
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
Now I face the following problem You must register and activate your account in order to view images.
sariusmt is offline  
Old   #4
 
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
Quote:
Originally Posted by sariusmt View Post
Hi guys i need some help connecting to sql server 2014.
I use this guide for lvl 99 rohan server.
According to the guide you have to change


My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?

My SQL log are


server name = your computer name
uid = sa
pwd = ur mssql password

open cmd, type ipconfig then enter. use ur IPv4 ip for localhost. change the ip on dbserver, regedit and xampp.


xpro99 is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Mar 2014
Posts: 162
Received Thanks: 7
Or just use 127.0.0.1
busternr is offline  
Old   #6
 
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
Ok so now SQL seems to be working fine but AI server won`t start, at least it won`t show on my desktop and MapID says "Can`t connect to DB server".
LogServer logs show server started but again it won`t stay on my screen. Any advices?

Ok so i also get this
sariusmt is offline  
Old   #7
 
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
you need to do to fix your problem.
xpro99 is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2014
Posts: 762
Received Thanks: 355
Quote:
Originally Posted by sariusmt View Post
Hi guys i need some help connecting to sql server 2014.
I use this guide for lvl 99 rohan server.
According to the guide you have to change


My question is: Do I have to modify the IP to my external IP or to my internal one? Since I`m gonna use this server on the same machine where I plan to use my client.
Also, on the server machine I will connect local to my SQL server. When I configure the files for "pwd" should I put my SQL password or leave it blank since i`m connected to the server machine and use the client on the same machine?

My SQL log are


First of all that's really wrong you dont use your computer name you use the SQL server name for the rohan server (SQL can use more then 1 server for multiple game's) The sa is the default username for the database (Witch i recomend you change) next comes the password that you set for the new user.(If you installed the SQL without setting an Simple Account (SA) then you will have to create one.
DretoNEX is offline  
Old   #9
 
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
Quote:
Originally Posted by DretoNEX View Post
First of all that's really wrong you dont use your computer name you use the SQL server name for the rohan server (SQL can use more then 1 server for multiple game's) The sa is the default username for the database (Witch i recomend you change) next comes the password that you set for the new user.(If you installed the SQL without setting an Simple Account (SA) then you will have to create one.
If i remember right I did add my current PC username to SQL when I installed the SQL server.
Regarding the use of SQL server and not my computer name, I edited the registry to use my computer name .
I did set up a password for my SQL account like it`s listed in the registry.
sariusmt is offline  
Old   #10
 
elite*gold: 0
Join Date: Jul 2014
Posts: 762
Received Thanks: 355
Quote:
Originally Posted by sariusmt View Post
If i remember right I did add my current PC username to SQL when I installed the SQL server.
Regarding the use of SQL server and not my computer name, I edited the registry to use my computer name .
I did set up a password for my SQL account like it`s listed in the registry.
K im gonna give you an advice here STOP dooing any kind of rohan server you wana do right now if you cant even figure out what's the SQL server name and what's your pc name then im pretty sure noone arround here will even try to help you. As for the password it has nothing to do with the registry.
DretoNEX is offline  
Old   #11
 
elite*gold: 0
Join Date: Jul 2014
Posts: 70
Received Thanks: 10
Quote:
Originally Posted by DretoNEX View Post
K im gonna give you an advice here STOP dooing any kind of rohan server you wana do right now if you cant even figure out what's the SQL server name and what's your pc name then im pretty sure noone arround here will even try to help you. As for the password it has nothing to do with the registry.
Dreto, I do appreciate the criticism, constructive or otherwise. I won`t stop cuz that`s how I learn new things. As I said I`m looking at this server as a personal project. I`m pretty sure it will take me some time to figure things out. It`s not in my nature to give up when things won`t work. When you said server name I asume you were refering to MSSQLSERVER. Anyway, thanks for the tip.
sariusmt is offline  
Old   #12
 
elite*gold: 0
Join Date: May 2013
Posts: 174
Received Thanks: 30
try to read all posts (maybe from pages 1 to 20 only) on senzoku thread at another forum. what you want to know and your problems has been explained there. but i believe you need some hard reading all of them. no offense, if you cant start your server after that then I would suggest the same thing as what dreto said. This is just the beginning, you will find a bigger problems later. trust me
xpro99 is offline  
Old   #13
 
elite*gold: 0
Join Date: Oct 2014
Posts: 15
Received Thanks: 0
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help
daingnabangus is offline  
Old   #14
 
elite*gold: 0
Join Date: Feb 2014
Posts: 269
Received Thanks: 66
Quote:
Originally Posted by daingnabangus View Post
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help
This forum is full of answers for every kind of issues. Go make an effort and search for yourself, if you're really interested in succeeding.
xHaiBai is offline  
Old   #15
 
elite*gold: 0
Join Date: May 2011
Posts: 314
Received Thanks: 97
Quote:
Originally Posted by daingnabangus View Post
may i humbly ask for help in setting up a local rohan server..i managed to make xampp running..do i need the mysql running too?..dbserver opens but it closes instantly..please help

tbh all you have to do is import db and double check every IP address settings and it should work just fine.


kthxbai2 is online now  
Reply



« Previous Thread | Next Thread »

Similar Threads
[PROBLEMS] Server Problems
Hi I have a little problem on the server metin2. I put it on the dedication and everything works beautifully, but as I enter the client of this...
0 Replies - Metin2 PServer - Discussions / Questions
Roc Mountain Teleport Problems? DC Problems?
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside...
1 Replies - SRO PServer Ask the Experts
Roc Mountain Teleport Problems? DC Problems?
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside...
0 Replies - SRO Ask the Experts
[Problems] Source 5165 All Problems
Hello Everyone, Ok i will put All my problems here So i hope noone spamming and Say Go learn C# and w/e 1-RegPage: fixed all by adding  to...
7 Replies - CO2 PServer - Discussions / Questions
[Problems]Having problems in Cabal Wudijt
1>im having problems in registering in Wudijt can anyone help me give me working link 2>i cant seem to update my red cabal online is it offline? ...
0 Replies - Cabal Main - Discussions / Questions



All times are GMT +2. The time now is 11:19.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.