How to add an instance of SQL Server 2008 service?

I updated the SQl server from 05 to 08 and had several problems. After uninstalling 05 and several reboots, later 08 is installed normally, but now I do not have any SQL Server services.

I cannot connect to (local) \ SQLExpress or. \ SQLEXPRESS through SQL Server Management Studio, and the SQL Server Services dialog does not show any services. There is no add button anywhere, so how to add a new service?

Am I doing this programmatically or something else?

+7
sql-server sql-server-2008
source share
2 answers

I had similar problems, and we used to reinstall SQL Server 2008 and the moment it asks for a default instance of the instance or a named instance, uses the named instance and continues to work.

This does not affect any currently installed instances, but creates a new instance of the specified name and then should be used from there.

+8
source share

If this is the instance you want to create, you can take a look at this question - it can work in the same way

+4
source share

All Articles