CODEWITHSUNDEEP
c#sqlsql-serverwinforms
wren
wren

Reputation: 383

Install SQL Server for a network of computers linked by a removable drive?

I need to install SQL Server to be used by multiple computers which have one removable drive in common, some computers use windows 7 while some uses windows 10. I tried to install SQL Server 2017 express on the shared removable drive from one of the computers but it says that it SQL 2017 Express are not allowed to install on a removable drive, and also that windows 7 doesn't support SQL Server 2017 express. What can I do to have a SQL Server that all the computers can share and access?

Upvotes: 0

Views: 51

Answers (1)

Bodo Thiesen
Bodo Thiesen

Reputation: 2514

As suggested by @MichaelRandall and @TomC, install it on one of the Win 10 systems (or on any other Win 10 system) on a non removable storage. Access the DB via network from the other machines.

@AlexeiLevenkov posted a link to the appropriate documentation: https://learn.microsoft.com/en-us/sql/relational-databases/lesson-2-connecting-from-another-computer?view=sql-server-2017

Upvotes: 2

Related Questions