I'm working through a Microsoft exam study book.
I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC.
The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the book doesn't say what to do if this doesn't work.
I can ping all servers from all servers.
Both SQL Severs are logged in with the same user who has admin rights but I can't connect the 2 SQL Servers.
Things I've tried from answers to similar problems:
- Allow remote connections is ticked
- Port 1433 is set as the TCP Port
- Browser service is running
- Firewall has an inbound rule set up.
I removed both SQL Servers from the domain and added them back in but that didn't change anything. I can't see what I've missed.