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

LVL 1
jdhackettAsked:
Who is Participating?
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

Try a reinstall of SQL 2005 Developer Edition, and install as a named instance.

I don't see the need to uninstall anything at this stage.

Let us know how it goes.

Cheers
  David
0
 
lamaslanyCommented:
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)'?

0
 
jdhackettAuthor Commented:
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

0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
David ToddSenior DBACommented:
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

0
 
jdhackettAuthor Commented:
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


0
 
jdhackettAuthor Commented:
Good idea, I may well have skipped the named instance part. I'll try it today and update here.
0
 
jdhackettAuthor Commented:
Yep, worked with named instance
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.