Can't connect to a sql server instance over the network, and all SSMS gives me is a 258 error.
Everything is supposed to be correct.
- Both machines are inside a domain and the user was added to the security\logins during installation.
- Server Authentication is set to "SQL Server and Windows Authentication mode"
- Firewall has the following ports open: 1433, 1434, 4022, 135, 2383, & 2382 TCP, and 1434, & 1433 UDP.
- Both "SQL Server (INSTANCE)" and "SQL Server Browser" services are running.
- "Allow remote connections to this server" is enabled.
- TCP/IP is enabled in Protocols for INSTANCE.
Am I missing something? I am double checking the configuration in other servers inside the network and there doesn't seem to be anything missing.