@DNC SQL Server Setup for Dragona (similar for ROM)

Elssair · Jul 13, 2014

Look at this vídeo, the configuration it's similar for setup SQL Server for Runes of Magic

You must be registered to see links

Thanks to @DNC

http://forum.ragezone.com/f891/release-dragona-officially-named-dragon-1013064/

kalle101 · Jul 13, 2014

Thanks for Video Elssair.
But I can't connect. I typed 127.0.0.1 and Windows-Authentification but brings me error.

Elssair · Jul 13, 2014

kalle101 said:
Thanks for Video Elssair.
But I can't connect. I typed 127.0.0.1 and Windows-Authentification but brings me error.

Watch the video and your *.ini files carefully, besides the server connection is not authenticated, is by username and pass

kalle101 · Jul 13, 2014

Ok will try.
But how does MS SQL Server knows my ROM Database? Is there any .exe i must start before connecting with SQL?

Ok maybe i explain. Start from scratch :

I open SQL Server Management Studio.
What put in:
- Servername?
- Login-Name?
- Password?

Which of these .ini Files I need to change? PlayerCenter, Global,..

Elssair · Jul 13, 2014

kalle101 said:
Ok will try.
But how does MS SQL Server knows my ROM Database? Is there any .exe i must start before connecting with SQL?

Ok maybe i explain. Start from scratch :

I open SQL Server Management Studio.
What put in:
- Servername?
- Login-Name?
- Password?

Which of these .ini Files I need to change? PlayerCenter, Global,..

Sorry but explain it all from the beginning is very difficult, the vídeo is a base for setup, you have to use logic that God has given for you, much encouragement and you can see how you learn best.

Sorry my english it's to poor

Ochoaman · Jul 13, 2014

When you first create your SQL installation, you are prompted to create a password. When you get your database all created, I used sa as the username and the password I created when asked during the install.

Also, when you first created your database, you should have created a name for it. Mine is ROMDB, so I have that and I select SQL Server Authentication and enter sa as the username then the password I created during install.

Perhaps you setup the initial SQL DB wrong? I used this video for the setup of my SQL. I stopped watching at 8minutes, since he goes into other stuff. But after 8minutes.

Hope this helps your SQL setup.

You must be registered to see links

starwars1 · Jul 13, 2014

why knows, how get gm account?

kalle101 · Jul 14, 2014

Thanks man Ochoaman!

Now I am a Step closer
Will try now to import the Databases

I start the RAServerMonitor and want to Start the Servers.
Now I'm getting this Error:

DBTransferClass Connect Error _Srv = 127.0.0.1 _DB=ROM_Account _LoginID =romuser
DBTransferClass Init Error!! Server=127.0.0.1 DB=ROM_Account LoginID=romuser

I set everything right in the .Ini and my Databases.
Any Idea?

Thanks

Mantios · Jul 14, 2014

kalle101 said:
Thanks man Ochoaman!

Account _LoginID =romuser

U hawe the same login in file and on sql "romuser" ??

Acc_DBServer = ( you'r Computer name)
Acc_DataBase = ROM_Account (here nothig change)
Acc_Account = (you'r Sql login)
Acc_Password = (you'r encryption pass from sql ) U do this that tool RAPasswordEncode.

kalle101 · Jul 14, 2014

Oh sh*** I didn't know that ;-).
I use the default User Login "sa".
This Login-Name is to short to encrypt it with that tool.

Any Idea? Should I create a new SQL instance?

Ok, i created a new Login in my Database named "romuser".
So I put this User in the Password tool, and encrypted it.
Then I put this Password and "romuser" in the .ini Files.

Is there something wrong?

thanks

Mantios · Jul 14, 2014

kalle101 said:
Oh sh*** I didn't know that ;-).
I use the default User Login "sa".
This Login-Name is to short to encrypt it with that tool.

Any Idea? Should I create a new SQL instance?

Ok, i created a new Login in my Database named "romuser".
So I put this User in the Password tool, and encrypted it.
Then I put this Password and "romuser" in the .ini Files.

Is there something wrong?

thanks

U must encrypt password not username...

kalle101 · Jul 14, 2014

Thanks so far.

Ok I think I made it a step further.
So now I get following messages when starting Servers:

- ControllerClientEvent::OnConnectFailed = Code1
- Census not find

I have Account, ServerList, Switch and Proxy online.
The others remaining in yellow "Starting"

Anybody knows whats wrong?

Thetatuziii · Jun 27, 2020

Elssair
where i can find windows service administrative tool for net start? im stuck : c

@DNC SQL Server Setup for Dragona (similar for ROM)

Elssair

Skilled Illusionist

kalle101

Junior Spellweaver

Elssair

Skilled Illusionist

kalle101

Junior Spellweaver

Elssair

Skilled Illusionist

Ochoaman

Newbie Spellweaver

starwars1

Newbie Spellweaver

kalle101

Junior Spellweaver

Mantios

Experienced Elementalist

kalle101

Junior Spellweaver

Mantios

Experienced Elementalist

kalle101

Junior Spellweaver

Thetatuziii

Newbie Spellweaver