STEPS LEADING UP TO THE ERROR
1. renamed server
2. rebooted
3. ran the following script:
-- delete the server name currently stored in SQL Server
EXEC sp_dropserver @.@.servername
GO
-- set the server name stored in SQL Server to match the server name
DECLARE @.srvr sysname
SET @.srvr = CAST(SERVERPROPERTY('ServerName') AS sysname)
EXEC sp_addserver @.srvr, local
GO
-- Enable a loopback linked server after renaming the server.
DECLARE @.srvr sysname
SET @.srvr = CAST(SERVERPROPERTY('ServerName') AS sysname)
EXEC sp_serveroption @.srvr, 'data access', true
GO
4. rebooted
ERROR DESCRIPTION
Upon starting SSMS, the following error dialog appeared (Shift+Ctrl-C was used to capture the dialog box as text):
Microsoft SQL Server Management Studio
OK
As you can see the error dialog box is empty. It appears over what appears to be a blank SSMS. After clicking OK, SSMS appeared as it should.
I actually have the same problem and I haven't renamed anything. When I start SQL Server Managemnt Studio I get the blank message with the OK button as well.
Any suggestions?
