asked on

SQL 2005 Developer Edition Problem

Installed SQL 2005 Developer Edition on my pc.
When I run management studio, it only shows two types to connect to:
PC-22\SQLEXPRESS
PC-22\MICROSOFTSMLBIZ

I tried connecting to the SQLExpress version. Imported a database, but its VERY slow to open the design of any views or tables.
Anyway, it looks those are the only two registered servers on the pc. I'm unsure of what to do next.
If I check in Services, only SQLExpress is there. What must I do to get the full version of SQL running?

Thanks

lamaslany

What spec machine are you running this on?

To confirm - if you look in services you can only see the service 'SQL Server (SQL Express)'?

jdhackett

ASKER

3Ghz P4, with 1Gb of RAM. I thought it had 2Gb when I posted, will probably need the extra gig for good performance.
Either way, I'd like to make sure I'm using the right version.
There are five SQL items, listed as follows:
SQL Server (SQLEXPRESS) - Started
SQL Server Active Directory Helper
SQL Server Browser - Started
SQL Server VSS Writer
SQLAgent$MICROSOFTSMLBIZ

David Todd

Hi,

It looks like you installed only the tools and not the database. Can you check for this service: MSSQL$MICROSOFTSMLBIZ

It appears that you have SQL Express (as SQLEXPRESS) and SQL 2000 ( as MICROSOFTSMLBIZ)

Please run the following code against both instances and paste the results.

Cheers
David

use tempdb
go
 
set nocount on
 
select serverproperty( 'ServerName' )
select serverproperty( 'ProductVersion' )
select serverproperty( 'ProductLevel' )
select serverproperty( 'Edition' )
select serverproperty( 'EngineEdition' )
select 
	case serverproperty( 'EngineEdition' )
		when 1 then 'Personal or Desktop Engine (Not available for SQL Server 2005.)'
		when 2 then 'Standard (This is returned for Standard and Workgroup.)' 
		when 3 then 'Enterprise (This is returned for Enterprise, Enterprise Evaluation, and Developer.)'
		when 4 then 'Express (This is returned for Express, Express Edition with Advanced Services, and Windows Embedded SQL.)'
	end
	
set nocount off

Open in new window

jdhackett

ASKER

MSSQL$MICROSOFTSMLBIZ is there, but the service is disabled.
I started it up and got:
PC-22\MICROSOFTSMLBIZ
8.00.2039
SP4
Desktop Engine
1
Personal or Desktop Engine (Not available for SQL Server 2005.)

For SQLEXpress, the results were:
PC-22\SQLEXPRESS
9.00.1399.06
RTM
Express Edition
4
Express (This is returned for Express, Express Edition with Advanced Services, and Windows Embedded SQL.)

If I need to remove and do a fresh install, thats not a problem, as I have no SQL dbs set up on this pc yet.
Thanks

ASKER CERTIFIED SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jdhackett

ASKER

Good idea, I may well have skipped the named instance part. I'll try it today and update here.

jdhackett

ASKER

Yep, worked with named instance
Thanks!