Do not have instance of SQL Express 2005 installed

I am attempting to install SQL Express 2005 on a laptop that already has MS Sql Server installed.

I downloaded the SQLEXPR_TOOLKIT.EXE from Microsoft's website and let it go through its installation routine accepting all the default answers.

When I open SQL Server Management Studio Express, I can only connect to the SQL 2000 instance. I have issued the 'SELECT @.@.VERSION' command, and When I try to connect to the instance COMPUTERNAME\SQLEXPRESS, the following error message is displayed:
Cannot connect to YOUR-F8A010A9D0\SQLEXPRESS.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified) (Microsoft SQL Server)

When I go to remove SQL Express 2005 using the add/remove programs, there is a check box that says
"Remove SQL Server 2005 instance components"
and in the box underneath where it lists all the instances it says: "No instances have been installed"

How do I create an instance for SQL Server 2005?

Thank you
SusanYou go to the incorrect location to install SQL Express. Instead, you choose to install tools only. Please go to the directory ...\SQLEXPR\setup.exe. Note, if .NET Framework is still not installed on the machine, you need to install it first.

Do I want the Developer version?

I've downloaded 2005 Express but I want to do SSIS and don't see any way to do that with Express. The Developer Edition apparently has all features, but says you can upgrade to Enterprise, which I don't need (Standard would probably be fine).

Here are my questions:

1) Is there any way to develop SSIS packages in Developer and run them in Express?

2) Is it possible to upgrade Developer to something less than Enterprise, such as Workgroup or Standard?

3) This page is titled "How to Obtain SQL Server 2005 Developer Ediiton" but doesn't explain how to obtain it. Instead it talks about which edition to select, trial software, blah blah:

http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Are there any catches or preconditions to buying Developer, or is it just a simple $50 (or less, depending on where you buy it)? I want to explore more 2005 features than Express offers but I don't want a trial version that will expire.

Thanks for any clarification that can be provided.

Hi,

1)

SQL Server 2005 Editions and Integration Services
(http://www.sqlis.com/default.aspx?31)

Microsoft SQL Server: SQL Server 2005 Features Comparison
(http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx)

2) Yes, sure but the developer edition has the exact same features as the enterprise edition, so you have to keep in mind only to use the standard feature while developing if you want to deploy them later on a standad licenced server.

3) The only limitation to Developer Edition is that you can use it in production due to the agreed licence agreement during the setup process.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I understand the answers to 2 and 3 but still not clear on 1.

Is there a way to run 2005 integration packages created in Developer Edition under Express Edition? I've browsed the links and they don't give me a clear answer to this question.

|||

I'm going to move your thread to the Integration Services forum where I think you'll get a quicker response.

-Jeffrey

|||

I am pretty sure you can NOT run SSIS packages using only installable components from the sql server express edition. Basically, there is no free runtime available to run SSIS packages, you have to pay...

|||

Ken is correct, you can't run packages using Express Edition.

Also, just to correct one thing that Jens said. Functionality in Enterprise and Standard is NOT the same. You get extra functionality in Enterprise.

-Jamie

|||Thats not hat I said, if you read my post you will recognize that I compaed developer against the enterpise edition (not the standard edition) :-)

-Jens Suessmeyer.|||

Pardon me Jens, you did indeed. My apologies!!! :)

Do I HAVE to have IIS installed to use SQL Server Express 2005? and do I have to install SQLE2K5

Hi,

I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer.

I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc.

I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005.

I'm so confused, and frustrated that I dare'nt install SQLE2005...

...Can anyone put me out of my misery?

All advice greatly appreciated.

SQLEB

Hi,

If you have downloaded SQL Express edition with Advance Services then only you require to have IIS installed on your system Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005Advanced.htm

and if you have installed SQL Express w/o Advance Services you don't require to have IIS Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm

HTH

Hemantgiri S. Goswami

|||No, IIS is NOT required for the use and operation of SQL Server.sql