Difficulty in installing SQL server

Question

1.00/5 (3 votes)

See more:

Hello all, I have been facing issues in installing SQL server in fact this is the first time i am trying to install it for my home class. I have 4 systems in which one is acting data server and the other 3 are used for the students to do project work. I tried to install the SQL server 2016 express edition on the data server so that the other 3 systems could communicate through it but after the installation the application is not showing in the system. All i need your help to understand which version of SQL 2016 do i need to install on the main system to make it a server and the version on the other 3 systems so that they can act as a client.

System configuration: Main system is 8 gb Ram 1000 tb hdd windows 10 OS and core 13 6th generation

other 3 systems are 4 gb Ram 500 hdd windows 10 OS core i3 4th generation

Please suggest and guide me to install as it is very urgent

What I have tried:

Hello all, I have been facing issues in installing SQL server in fact this is the first time i am trying to install it for my home class. I have 4 systems in which one is acting data server and the other 3 are used for the students to do project work. I tried to install the SQL server 2016 express edition on the data server so that the other 3 systems could communicate through it but after the installation the application is not showing in the system. All i need your help to understand which version of SQL 2016 do i need to install on the main system to make it a server and the version on the other 3 systems so that they can act as a client.

System configuration: Main system is 8 gb Ram 1000 tb hdd windows 10 OS and core 13 6th generation

other 3 systems are 4 gb Ram 500 hdd windows 10 OS core i3 4th generation

Please suggest and guide me to install as it is very urgent

Posted 2-Dec-16 6:37am

Tushar Shrivastava

Updated 2-Dec-16 8:10am

Sean Ewington

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AnvilRanger · Accepted Answer · 2016-12-02T08:10:00

Solution 2

Another quick note. Starting with MS SQL 2016 SSMS is no longer including in the installer. It is a separate download from Download SQL Server Management Studio (SSMS)[^]

Posted 2-Dec-16 8:10am

AnvilRanger

Dave Kreskowiak · Accepted Answer · 2016-12-02T07:29:00

Solution 1

For a home class you say? And you don't know the basics of installing SQL Server?

OK.

You can install any edition you want on the server. It really doesn't matter as far as the "class" is concerned. The only thing it matters to is your wallet.

What you install on the clients depends on what you're teaching. Usually, you don't have to install anything at all. Well, except for the Management Studio if you're teaching SQL Server administration.

Posted 2-Dec-16 7:29am

Dave Kreskowiak

Comments

Tushar Shrivastava 2-Dec-16 13:48pm

Thanks for your reply, well i am trying my hands on training thats why needed help to set up

Dave Kreskowiak 2-Dec-16 13:50pm

Well, you need to start by defining in precise terms what the class is going to cover. Without that, you can't tailor an installation to support that syllabus.

Tushar Shrivastava 2-Dec-16 14:38pm

thanks for the suggestion i will try to implement that

Difficulty in installing SQL server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Difficulty in installing SQL server

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us