<div>
It depends the name of the sql instance, and you need to make sure you connect to that instance to be able to control it. &nbsp;Instead of SQLSERVER or SQLEXPRESS it may be SQLSERVER2 or such. &nbsp;You can go to the configuration tools and configuration manager to ensure the service is running as well as the service name.
</div>


It depends the name of the sql instance, and you need to make sure you connect to that instance to be able to control it.  Instead of SQLSERVER or SQLEXPRESS it may be SQLSERVER2 or such.  You can go to the configuration tools and configuration manager to ensure the service is running as well as the service name.

<div>
I can only see a mention of the sqlexpress instance.... which is the 2005 version?
</div>


I can only see a mention of the sqlexpress instance.... which is the 2005 version?

<div>
if you installed 2008 as well it could be under a different configuration utility. &nbsp;I know in windows 7 it can be found at: <br />
<br />
C:\Windows\System32\mmc.ex<wbr />e /32 C:\Windows\system32\SQLSer<wbr />verManager<wbr />10.msc
</div>


if you installed 2008 as well it could be under a different configuration utility.  I know in windows 7 it can be found at:

C:\Windows\System32\mmc.exe /32 C:\Windows\system32\SQLServerManager10.msc

<div>
I've attached what I get when I run it and right clicked properties on the service.... <a href="https://filedb.experts-exchange.com/incoming/2011/11_w45/519452/Untitled.png" target="_blank" title="screen shot of config manager (71 KB)"><img alt="screen shot of config manager" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/11_w45/800_519452/Untitled.png" /></a>
</div>


I've attached what I get when I run it and right clicked properties on the service.... screen shot of config managerhttps://filedb.experts-exchange.com/incoming/2011/11_w45/519452/Untitled.png

Untitled.png

<div>
&gt;&gt;I installed sql server 2008 but can't create a 2008 database, I only have 2005 as an option.&lt;&lt;<br />
That would be because you are attempting to create the database on the 2005 instance as opposed to the 2008 instance.<br />
<br />

</div>


>>I installed sql server 2008 but can't create a 2008 database, I only have 2005 as an option.<<
That would be because you are attempting to create the database on the 2005 instance as opposed to the 2008 instance.



<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
This is no doubt a stupid question....<br />
<br />
I had sql server 2005 installed for ages and have a lot of 2005 databases.<br />
<br />
I installed sql server 2008 but can't create a 2008 database, I only have 2005 as an option.<br />
<br />
How can I get the ability to create a 2008 version?
</div>
</div>


Hi,

This is no doubt a stupid question....

I had sql server 2005 installed for ages and have a lot of 2005 databases.

I installed sql server 2008 but can't create a 2008 database, I only have 2005 as an option.

How can I get the ability to create a 2008 version?

creating a new sql server 2008 database

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.