Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 07:29

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #2986
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
Arrow

Hi @ll , i have a message error for my connection a SQL 2012...

Cannot connect to NAME-PC\SQLEXPRESS.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

firewall ? Avast ? or SQL2012 bad configuration ?

Windows Seven X64 SP1.

Sorry for my 2 post but this is urgent.




wesler013 is offline  
Old   #2987
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
I would start with making sure your SQL services are running.

As long as you did go through the configuration steps in the guide for configuring port 1433 and the TCP/IP connections.

Using the same SQL configuration manager that you would have used when you did those configuration steps, check your services and make sure they are running. Right click and select start service for those that are not.


ThunderNikk is offline  
Thanks
1 User
Old   #2988
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
Sql Server Configuration Manager --> Named Pipes --> Enabed
TCP/IP ---> Enable & TCP Dynamics Port is 1433. I missed something.?

"""check your services and make sure they are running.

Right click and select start service for those that are not."""

command is msconfig ??

"" Right click and select start service for those that are not "" my service is OFF good job man , but i have a problem , my right clik is fail lol :')
wesler013 is offline  
Old   #2989
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Well it is not in msconfig so maybe your right click is not so fail after all.

It is in the SQL configuration manager.

Under SQL server services.


ThunderNikk is offline  
Thanks
1 User
Old   #2990
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
The only problem.
I have not been able to connect with the "sa" login.
but with my windows session.
I have everything set.
I configure "Princess"
But I have error messages.
probably due to the configuration.

I am logged in as "sa"!!! why ???
any ideas.
wesler013 is offline  
Old   #2991
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Quote:
Originally Posted by wesler013 View Post
Hi @ll , i have a message error for my connection a SQL 2012...

Cannot connect to NAME-PC\SQLEXPRESS.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

firewall ? Avast ? or SQL2012 bad configuration ?

Windows Seven X64 SP1.

Sorry for my 2 post but this is urgent.

1. Launch SQL Server Managment Studio.
2. Under Connect to Server window, expand the 'Server name' combobox.
3. Select <Browse for more>.
4. Expand the Database engines tree, then select the server named under your PC name.
5. Connect to it, then verify that the user 'sa' under security -> users tree is enabled by finding the icon without an arrow down icon.
6. Under the database's properties, add the user 'sa' as an owner then click ok.


This should solve all user related error messages. (couldn't have made it better).
MuStA2222 is offline  
Thanks
1 User
Old   #2992
 
elite*gold: 0
Join Date: Oct 2011
Posts: 13
Received Thanks: 0
Red face

Hello
I've tried 5 times and followed the guide accurately ( expect getting the Auth_GamePorta.bak file from older epic of rappelz, because the given links doesn't work for it but from epic 7.3 files as some1 told me it won't effect because the Auth doesn't change by the time )
so each time I run "CaptainHerlockServer.exe" it gives me the following error:

You must register and activate your account in order to view images.

I have windows 8.1-64 bit if that matters
so any1 knows how to solve this please tell me, or I can skype + Teaviewer if needed :/
ayman ayoub is offline  
Old   #2993
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
Quote:
Originally Posted by MuStA2222 View Post
1. Launch SQL Server Managment Studio.
2. Under Connect to Server window, expand the 'Server name' combobox.
3. Select <Browse for more>.
4. Expand the Database engines tree, then select the server named under your PC name.
5. Connect to it, then verify that the user 'sa' under security -> users tree is enabled by finding the icon without an arrow down icon.
6. Under the database's properties, add the user 'sa' as an owner then click ok.


This should solve all user related error messages. (couldn't have made it better).
thank you very much.

everything is configured properly.
My only problem is the "AuthServer.opt" file and "gameserver" files.
I have a problem: mk5 / pass / password ....a small problem for you.
a big problem for me.Files8.1_By_AL7roB compared to files.
an example of the file "AuthServer.opt" file and "gameserver" files would be welcome.

Is it possible? last line right.
wesler013 is offline  
Old   #2994
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
@ayman ayoub It is trying to log in as rappelz_game so you have not set your users as "sa" in the opt files like it explains to do in the guide.

Try using the example opt files and just modify them to your own addresses.

@wesler013 There are example opt files in the guide. For the MD5 password use an online MD5 utility find the key in the opt files your password will be the key + password MD5 encrypted.

Example key is 2011 and password desired is password.

Enter 2011password in the online MD5 hasher and get the result.

The results go in the database for the account password.
ThunderNikk is offline  
Thanks
1 User
Old   #2995
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
Quote:
Originally Posted by thndr View Post
@ayman ayoub It is trying to log in as rappelz_game so you have not set your users as "sa" in the opt files like it explains to do in the guide.

Try using the example opt files and just modify them to your own addresses.

@wesler013 There are example opt files in the guide. For the MD5 password use an online MD5 utility find the key in the opt files your password will be the key + password MD5 encrypted.

Example key is 2011 and password desired is password.

Enter 2011password in the online MD5 hasher and get the result.

The results go in the database for the account password.
ok thank man i have a link for mk5, it's for just knowing where to write the password

now, princess.exe closes, I think it is because of mk5 ...
I'm almost at the end !!!!

Example key is 2011 and password desired is password.

Enter 2011password in the online MD5 hasher and get the result.

The results go in the database for the account password.[/QUOTE]

example :

db.auth._password: 2011
S db.auth.md5_key: c8758b517083196f05ac29810b924aca

it's good ?

"The results go in the database for the account password." where ? in the gameserver.opt file and "AuthServer.opt" ?
wesler013 is offline  
Old   #2996
 
elite*gold: 0
Join Date: Oct 2011
Posts: 13
Received Thanks: 0
@thndr would you explain more please? I copied and past the examples giving in the *.opt files but having the same problem
ayman ayoub is offline  
Old   #2997
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
You know...setting up a server is not for everybody, maybe it is not for you.

The MD5 password and key and using MD5 is for accounts only.

It has nothing to do with the user account "sa" and the password for the user "sa" which is DES encrypted not MD5

It really does not sound like either of you have gotten to setting up an account yet for logging into the game so forget about MD5 for a minute.

In the example .opt 2011 should be the key not your long encrypted mistake there.

In the example .opt user should be "sa" for the auth_db and the password should be left blank until we can get you to understand the difference between a game account MD5 and the database account DES, and I am not sure if we will ever get there.

Example from authserver.opt

S db.auth.account:sa
S db.auth._password:

Example from gameserver.opt

S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.c.account:sa
S db.c._password:

S db.user.name:Telecaster
S db.user.server:127.0.0.1
S db.user.account:sa
S db.user._password:

Now in order for this to work correctly "sa" needs to be set as the owner for all of the databases.
ThunderNikk is offline  
Thanks
2 Users
Old   #2998
 
elite*gold: 0
Join Date: Jan 2014
Posts: 19
Received Thanks: 0
[QUOTE=thndr;27017625]You know...setting up a server is not for everybody, maybe it is not for you.


it s OK for me for the md5
wesler013 is offline  
Old   #2999
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
convert. rdb for. sql or. csv or. txt

Hi guys,there is a tool that makes the conversion file. rdb is. sql or. csv or. txt???


ty help
8holyavenger8 is offline  
Old   #3000
 
elite*gold: 0
Join Date: Oct 2013
Posts: 398
Received Thanks: 27
guys i'm searching for how to copy dungeon or any place in other position

help plz ~~


Sherock is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 07:29.


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

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