472,976 Members | 1,228 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,976 software developers and data experts.

SQL Server 2005: setup problem

Hello,
(sorry for my English...)
Could you help me please with installing SQL Servera 2005 Express
Edition. I downloaded files:

SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition
SSEUtilSetup.EXE - SQL Server Express Utility
SqlServer2K5_BOL_Dec2005.msi - Books Online December 2005

and I tried to run them sequentially. After installing SQLEXPR.EXE
I had impression that I have little icons in Start menu (comparing to
my SQL Server 2000); I have a submenu:

Microsoft SQL Server 2005 / Configuration Tools
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration

I would like to have sth like Enterprise Manager (to see Northwind
database) and Query Analyzer (to query Northwind).
So I decided to run SQLEXPR.EXE again: I see a report:

System Configuration Check
- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed
- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed
- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed
- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed
- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed
- ASP.Net Version Registration Requirement (Success)
Messages
* ASP.Net Version Registration Requirement
* Check Passed
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed

....and screen Feature Selection where I see Client Components not
checked. I decided to mark these components:

Client Components "Will be installed on local hard drive"
Connectivitiy Compenents "Will be installed on local hard drive"
Software Development Kit "Will be installed on local hard drive"

(I have free disk space); then I pressed "Next":

Named instance: SQLExpress

and "Next" again: on screen Existing compenents I see popup with a
message:

"None of selected features can be installed or upgraded. Setup cannot
proceed since no effective change is being made to the machine. (...)"

but I had marked Client Components!
Could you explain me please what I am doing wrong?
Thank you very much for your help!
(MP)
Feb 1 '06 #1
2 11006
Mały Piotru˝ (ma**********@poczta.onet.pl) writes:
and I tried to run them sequentially. After installing SQLEXPR.EXE
I had impression that I have little icons in Start menu (comparing to
my SQL Server 2000); I have a submenu:

Microsoft SQL Server 2005 / Configuration Tools
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration

I would like to have sth like Enterprise Manager (to see Northwind
database) and Query Analyzer (to query Northwind).
So I decided to run SQLEXPR.EXE again: I see a report:


The SQL Express download does not come with any query tool. There is
however a separate download for SQL Server Mangagement Studio Express,
which a slimmed down version of the tool that comes with the other
editions.

You find it at
http://www.microsoft.com/downloads/i...splayLang%3den
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Feb 1 '06 #2
> The SQL Express download does not come with any query tool. There is
however a separate download for SQL Server Mangagement Studio Express,
which a slimmed down version of the tool that comes with the other
editions.


FWIW, Visual Web Developer Express 2005 has a much better tool set.
--
Darryl Kerkeslager
Feb 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: pinos | last post by:
when i install the SQL server 2005, it occured the follow message: Product: Microsoft SQL Server 2005 CTP -- Error 29628. The setup has encountered an unexpected error in datastore. The action is...
0
by: jens Jensen | last post by:
Hello, Does anyone know of a setup issue of VS 2005 on an encrypted file system? I'm installing on an encrypted PC. The isntallation reports faillure on "optional components" which in turn causes...
2
by: | last post by:
hii all, im new on ASP.Net and working on a website project now. im using Visual Studio.Net 2005(c#.net) and SQL Server 2005. i made a connection to database from Default.aspx, and my...
0
by: rathi.vis | last post by:
Problem:Jet 4.0 Ole DB Provider stops working the momemt SQL 2005 server is installed. Environmental steps: 1.Installed XP Sp2 2.Installed SQL 2005 Server with SP1 3.Trying to import...
1
by: jshunter | last post by:
I've recently migrated all databases to SQL Server 2005. I couldn't figure out how to create an SSIS package in the time I had, so I just stuck with the DTS packages. They all worked fine during...
1
by: Zeljko Bilandzija | last post by:
Hello! I have a problem, and I looking for help if someone can handle this. I use asp.net 2.0, and I create web site which support users from internet (Web Site Administration Tool) and with...
1
by: alenak | last post by:
Hi Everybody, I have a web application that makes large number of insertions and updates in DB. In this application I send a sql query which is sql transaction shown below. The problem is that...
3
by: DL | last post by:
I'm installing sql server 2005 express distribution version on an Asus EEE PC with XP home OS, and doing installing and uninstalling several times, and each time, it generated some abitrariy...
0
by: nagmvs | last post by:
Hello Guys, I am not able to install Sql Server 2005 in my system..NET 2005 is already installed un my system. If try to install S s 2005 means it shows some error.So please give me some solution.
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.