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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.