April 3, 2009 at 11:47 am
I am using MS SQL Server Management Studio and I am trying to connect to an intance of an old SQL Server instance, version 8 (MSDE). I need to remove this as well as drop the databases within the instance.
The name of the instance shows up in the list of server names to select from to connect. But, the name of instance does not show up in the SQL Server Surface Area Configuration for Features and for Services and Connections.
When trying to connect to the instance in MS Management Studio, I get this error:
Cannot connect to SERVERNAME.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verifty that the instance name is correct and the SWL Server is configured to allow connections. (provider: SQL Network Interfaces, error 26 - Errror locating server/instance).
Any suggestions on how to remove the instance?
April 3, 2009 at 12:13 pm
Hi
Have a look to the windows services. There should be a MSSQLSERVER or a MSSQLEXPRESS. You can start the service and connect to the server.
Greets
Flo
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply