Tutorial Microsoft SQL Server OpenNos

[Uppermost]

 Spoiler

1.) Download SQL server 2016 and choose Developer Edition

2.) Start the setup (Iso file)

3.) Choose Developer Version (Free)

4.) Select

In instance Features, check they boxes

- Database Engine Services
- SQL server replication
- R-Services (In-database)
- Full Text and Semantic Extraction for search
- Data quality service

In Share features, check they boxes

- R Server (standalone)
- Client tools connectivity
- Client tools backwards compatibility
- Client tool SDK
- Distributed Replay controller
- Distributed Replay client
- SQL client connectiviity SDK

And click to NEXT

6.) Choose default name

7.) click to NEXT

8.) In Server configuration, Choose Mixed Mode (SQL Server authentification and Windows authentification)

Set the password root and confirm it

And click on the button Add current user and click to next

9.) Again NEXT

10.) click on Add current user, NEXT

11.) You have nothing to do now just NEXT everytime

12.) Close the software after the complete installation.

14.) Use get-migration, and update-database, parse all again and it's finish ! Microsoft SQL server 2016 is installed.

15.) Install (Microsoft SQL Server Management Studio) :

16.) Open it after the install,(Microsoft SQL Server Management Studio), server name type : localhost and click to connect now.

17.) Create a database called : opennos

FINISH !

Pastebin here :

If you see an error etc tell me and I modify it.

[Marvin341]

14.) Use get-migration, and update-database, parse all again and it's finish ! Microsoft SQL server 2016 is installed.
Where to use get-migration and where update-database ?

[Uppermost]

Originally Posted by Marvin341

14.) Use get-migration, and update-database, parse all again and it's finish ! Microsoft SQL server 2016 is installed.
Where to use get-migration and where update-database ?

In Visual Studio, Tools > Manager of Nugget packages

select OpenNos.DAL.EF project

and use they commands

[Marvin341]

Is the video tutorial still up to date or does it works with the mssql too?

Doesnt work for me , i dont get the .bak file for MSSQL

[warchiefxX]

My problem is that when I use the get-migrations command I get an error saying "No connection string named 'OpenNosContext' could be found in the application config file."

Google translate.

[Singleplayer™]

get-migration dont works ....

[Alexyceleh]

Originally Posted by Singleplayer™

get-migration dont works ....

I have the same error ... just let me use update-database, import the parser, but I do not login

[Marvin341]

i am stupid i already figured out ^^
its get-migrations
and update-database -verbose
you need to select the Default Project as OpenNos.DAL.EF

[Alexyceleh]

Originally Posted by Marvin341

i am stupid i already figured out ^^
its get-migrations
and update-database -verbose
you need to select the Default Project as OpenNos.DAL.EF

marvin, add me skype? please.

error with login ...



my skype is alex.nostale6

[MANUEL PERES]

Originally Posted by Alexyceleh

marvin, add me skype? please.

error with login ...



my skype is alex.nostale6

Hey remember to launch OpenNos.WebApi.SelfHost

[NosTaleP]

Can someone help me in skype? I have some problems..

Skype: caflori12

[lorenx911]

explicitly. Use the -Verbose switch for more information.
The project 'OpenNos.DAL.EF' failed to build.

[Fizo55]

Originally Posted by lorenx911

explicitly. Use the -Verbose switch for more information.
The project 'OpenNos.DAL.EF' failed to build.

Reinstall the stylcop
-> Reboot your computer
-> Retesting

[lorenx911]

resolve thanks

[GGGGame]

Can someone help me? I'm trying to create a new server but when I finish doing everything I can not create the database