7

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?

The Archetypal Paul
  • 41,321
  • 20
  • 104
  • 134
CVertex
  • 17,997
  • 28
  • 94
  • 124

2 Answers2

8

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.

Jimoc
  • 1,492
  • 1
  • 10
  • 20
4

If it's an instance you want to create you might wanna have a look at this question - it might work the same way

Community
  • 1
  • 1
JohnIdol
  • 48,899
  • 61
  • 158
  • 242