Sharing database on a network

Toby 1 Reputation point
2022-03-19T06:03:57.25+00:00

I'm using SQL Server Express and i am trying to share a database on our network so that multiple computers can update/add records on the database.

On the server. i have enabled TCP/IP (and set TCP Port to 49172 for IPAll) and Named Pipes.
I've opened a port in Windows Firewall - port 49172 as TCP.
With a computer on the same network, i attempt to connect in SQL Server Management using tcp:Desktop-xxxxxxxx,49172 but login always fails. Desktop-xxxxxxxx is the pc with server.
I've also tried other combinations such as Desktop-xxxxxxxx\SQLEXPRESS

Am i missing something or doing something wrong?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,922 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,469 questions
{count} votes