I'm having a problem connecting to my SQL Server Express instance. I can connect to the
sa account from the local machine but as soon as I try to connect from a separate workstation, the connection fails with the following error.
TITLE: Connect to Server
Cannot connect to SERVER1\SQLEXPRESS.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1311)
I had previously been able to connect without issues, but there were some changes made to the server (it was turned into a domain controller), and it is now refusing to work as I had assumed it ought.
I've tried restarting the SQL Server Browser instance and I've already checked the firewall settings. However I won't rule out having missed something.
I'm stymied and the database needs to be up 20 minutes ago.
How do fix this problem?