SQL2008 R2 on Windows 2008 R2 firewall Question
Posted on 2013-01-16
I have just finished installing a SQL 2008 r2 cluster, no errors all looks well
but when i try and start the SQL managemnt studio (on one of the nodes)
it errors saying
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 the instance name is correct…..
Error: 26 – Error Locating Server/Instance specified (Microsoft SQL Server)
when i start SQL Managent studio if i add, 1433 to the server name it works.
I dont have to do this on othe rsql clusters in diffrent domains, what have i missed?
config manager shows 1433 as default for the Instance im using
Windows firewall was turned off, tried turning it on and adding 135,1433,1434,2383,4022