Until today when accessed by remote desktop to my sql server could connect using localhost, but suddenly I cant (without any update or change in my server), now I can connect using localhost\instance but cant using localhost.
This is the error, and also it affects connections to several linked servers in this machine
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections.
- Firewall - disabled
- Allow remote connections - yes
- TCP connection allowed - yes
- Server running - yes
- User running services - domain administrator
Also in my computer I can access to this server using SSMS and only the IP.
In our development environment the user running sql server services is local administrator and everything go fine, but our network team doesn't change anything in our domain that affect administrator user.
SO: Windows Server 2008 R2 Datacenter SP1