Menu
I upgraded from SQl server 05 to 08 and had a few issues. After uninstalling 05 and a few restarts later 08 installed okay, but now I don't have any SQL Server services running.
I can't connect to (local)\SQLExpress or .\SQLEXPRESS via SQL Server management studio and the SQL Server services dialog shows no services. There's no add button anywhere there, so how do I add a new service?
Do I have do this programmatically or something?
430
Start > Programs > Microsoft SQL Server (version) > Configuration Tools > SQL Server Configuration Manager. Once we click on SQL Server Services on left, we can see all services on right pane. Then we can right-click SQL Server (MSSQLServer), and then choose required action.
If the instance of SQL Server is a named instance (such as SQLEXPRESS), then specify the name of the computer where SQL Server is installed, or the IP address of the computer, and add a slash and the instance name. The following examples connect to an instance of SQL Server running on a computer named APPHOST.
I've had similar issues and the solution we used was to reinstall SQL server 2008 and at the point where it asks you for default instance or named instance, used a named instance and continue on.
This does not affect any currently installed instances but creates a new instance of the name supplied and then from there on should be usable.
52
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
