I've been having various problems with Sharepoint etc since migrating from SBS2003 to SBS2008, but currently my problems all seem to be coming back to this one thing:
The Windows Internal Database (Microsoft##SSEE)
In the SQL Server Configuration Manager it's there under SQL Server 2005 Services.
It's NOT there when I look under SQL Server 2005 Network Configuration, and it's not there in portqry2 either.
I can connect to SBSMonitoring with Microsoft SQL Server Management Studio Express using Windows Authentication, but while I can select it from the "browse for more" list, I can't connect to the Microsoft##SSEE instance the same way. It gives me
an error 26.
I am doing this from the server the instance is running on. Any ideas at all would be welcome.
Cannot connect to fangio\MICROSOFT##SSEE.
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:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
View Complete Post