About six months ago my vendor installed SQL Server 2008 R2 into a clustered pair of servers, DB01 and DB02.
I've been logging on, periodically, to DB01 to audit some of the data contained in the database instance.
I've been using SSMS the whole time, and for six months there have been no problems.
Suddenly yesterday, I am unable to connect using SSMS.
I get the following error:
Cannot connect to DB01.
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: 53.)
This is very confusing, very little has changed since the last time I've logged in to SSMS.
TCP/IP is enabled on SQL Server, as are named pipes.
One thing I know has changed is that for the CLIENT machines that hit it, the TcpTimedWaitDelay parameter has been set to 30, and the MaxUserPort has been set to 10000.
But that's on the client machines only.
Could there be an issue arising from from these parameters not being mirrored on the database servers?
Could there be an issue arising from these two boxes sharing an IP for the clustering? The database is normally accessed through a shared IP, where DB02 takes the IP if DB01 fails.
I've considered restarting the SQL Server service but that scares the bejeezus out of me.
What if this issue spreads to the application currently using the databases?