Showing posts with label program. Show all posts
Showing posts with label program. Show all posts

Monday, March 26, 2012

Installing Express2005 SQL

I am trying to setup a new server for a non-profit i donate my services to.

I want to have SQL for an intranet based program that will be converted from a currently used Access database.

I can not get Express (any version to install). Below are the specs of the server and the log from the install.

Any suggestions and thanks in advance,

Lynn

Operating System System Model Windows 2000 Advanced Server Service Pack 4 (build 2195) COMPAQ PROLIANT 800 Processor a Main Circuit Board b 500 megahertz Intel Pentium III
32 kilobyte primary memory cache
512 kilobyte secondary memory cache BIOS: 12/31/99 Drives Memory Modules c,d 27.05 Gigabytes Usable Hard Drive Capacity
23.01 Gigabytes Hard Drive Free Space

COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]

IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0 192 Megabytes Installed Memory Local Drive Volumes

c: (NTFS on drive 0) 18.19 GB 14.45 GB free f: (NTFS on drive 3) 4.54 GB 4.26 GB free g: (NTFS on drive 1) 4.33 GB 4.30 GB free

Network Drives None detected


Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


Time : Mon Nov 06 15:23:26 2006

Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:

Pentium III-compatible processor or higher required

Minimum: 600 MHz

Recommended: 1 GHz or higher

Minimum: 192 MB

Recommended: 512 MB or more

Maximum: OS maximum

--
SvenC

|||

The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.

Once you take care of that, you should be able to attempt another Express install again.

|||

Thanks for all your help.

You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.

Thanks for your keen eye R. Green

|||

hi

if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?

Installing Express2005 SQL

I am trying to setup a new server for a non-profit i donate my services to.

I want to have SQL for an intranet based program that will be converted from a currently used Access database.

I can not get Express (any version to install). Below are the specs of the server and the log from the install.

Any suggestions and thanks in advance,

Lynn

Operating System

System Model

Windows 2000 Advanced Server Service Pack 4 (build 2195)

COMPAQ PROLIANT 800

Processor a

Main Circuit Board b

500 megahertz Intel Pentium III
32 kilobyte primary memory cache
512 kilobyte secondary memory cache

BIOS: 12/31/99

Drives

Memory Modules c,d

27.05 Gigabytes Usable Hard Drive Capacity
23.01 Gigabytes Hard Drive Free Space

COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]

IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0

192 Megabytes Installed Memory

Local Drive Volumes

c: (NTFS on drive 0)

18.19 GB

14.45 GB free

f: (NTFS on drive 3)

4.54 GB

4.26 GB free

g: (NTFS on drive 1)

4.33 GB

4.30 GB free

Network Drives

None detected


Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.


Time : Mon Nov 06 15:23:26 2006

Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:

Pentium III-compatible processor or higher required

Minimum: 600 MHz

Recommended: 1 GHz or higher

Minimum: 192 MB

Recommended: 512 MB or more

Maximum: OS maximum

--
SvenC

|||

The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.

Once you take care of that, you should be able to attempt another Express install again.

|||

Thanks for all your help.

You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.

Thanks for your keen eye R. Green

|||

hi

if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?

Friday, March 23, 2012

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.com
Hi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>
|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>
|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal
|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>
|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.comHi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.comHi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
--
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>sql

Wednesday, March 21, 2012

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?
Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
http://www.sqlserver.co.za
"ruthsieg" wrote:

> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
http://www.sqlserver.co.za
"ruthsieg" wrote:

> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>sql

installed eval and only have config tools

I installed the Sql Server 2005 Enterprise Edition 180 day eval.
However, under SQL Server 2005 program group, all I have is Configuration
Tools.
What happened to Query Analyzer, Enterprise Manager, etc?Hi Ruthsieg
I have encountered this problem before but not on the eval, it is related to
the windows installer. If you perform a manual install from the tools folder
on the installation cd you will have the management tools available.
Regards
Charl
--
http://www.sqlserver.co.za
"ruthsieg" wrote:
> I installed the Sql Server 2005 Enterprise Edition 180 day eval.
> However, under SQL Server 2005 program group, all I have is Configuration
> Tools.
> What happened to Query Analyzer, Enterprise Manager, etc?
>

Monday, March 19, 2012

Installation Problems.

I have tried installing SQL Server Express several times. The installation program never completes. It displays a message indicating it found traces of previous versions of SQL Server or Beta versions.

I have verified thouroughly that no beta versions are installed yet I keep getting the same error message. I have uninstalled Visual Studio and related applications and I am still getting the same message.

Can you assit me with this issue? Any help would be appreciated.

Rich -

After uninstalling everything, did you try to run the beta cleaner ?

http://msdn.microsoft.com/vstudio/express/support/uninstall/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Monday, March 12, 2012

installation problems : product ID rejected

Hello,

Maybe is it a newbie question : it is the first time I install a SQL Server licence purchased with the eopen program.

My SQL server licence is a french one. I purchased the correct media kit.

During the installation, I am asked the name, and the company name but the product key is greyed with product id which begin with "RY62Q". I guess it is normal (?)

But later on, when it comes to installing SQL server itself, i get a message telling that my product ID is incorrect. (id : 28021; event type : sqlca\sqlcax.cpp@.DetectProductID@.DetectProductID@.x6d75).

I tried dozens of times :

-with another admin account

-after cleaning up the temp and program files subdirectories

-after cleaning up the registry (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server,HKEY_LOCAL_MACHINE\Software\Microsoft\MSFTESQLInstMap; there was nothing anyway)

If it helps, I first try the installation from a wrong media. As I had no key, I went not far away.

I did received the authorisation number etc from Microsoft but I have no clue of what have to do from that.

As you understood, any help would be appreciated.

It is solved. I am really not sure how, but it solved.

I was about to reinstall the server. As it is a remote server, I had to upload the cds. In order not to have to do it again, I moved the cds to another partition. Just to be sure, I tried once again the installation...and it worked. The only possible cause I see is that the installation program detected a subfolder named "sql2005_cd1"(with a wrong media) in the same folder as my "newsql2005_cd1" (which actually contained the correct media). Maybe it is a dummy anti-piracy system, don't know...but now it worked and I am happy Wink

Installation problem - can't find startup program

I installed SQL Server 2005.

In the add/remove programs are all the programs visible. But when I use "Start -> All programs -> Microsoft SQL Server 2005", there are only 5 configuration tools, no management studio.

What is going wrong?

Where can I find the executable that start up SQL Server 2005?

Hi,

you either installed SQL Server Express which does not come with a graphical administration surface (but you can either install the SQL Server Management Express Studio as an add-on or install the SQL Server Express Adavnced Edition from scratch which includes everything) or you deselected the Client tools option for any non-Express edition.

The tools for Express can be download from:

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Installation Problem

I tried to install SQL Server 2000 but after a while it stalled. The PC seemed to be "hanged".

Then I closed the Setup program manually.
The installation have actually gone half-way and there was a registration of it in the Control panel's Programs List, but there was no program shortcut being created for it.

Then I tried to click the remove/change button (for SQL Server 2000) on the programs list, an error message appeared saying "the uninstall.isu file is invalid or has been corrupted".

What should I do to uninstall it ?

Thanks in advance.Insert the installation disk, the system will identify previous installation & will ask you to reinstall or remove.

OR

Try to reinstall it, once it's install successfully you can use it or easily uninstall / remove it from add-remove program...|||But I haven't got the installation disk. Mine is an Evaluation version only.|||But I haven't got the installation disk. Mine is an Evaluation version only.

OK, try to install from that source but make sure that installation source is not corrupted. If you find the source is corrupted (If it gives error in between the installation) then download it once again & install it.

Note : Make sure your computer is compatible with the standard requirement for SQL Server Evaluation Version.|||No, no.
The problem is that I couldn't uninstall it. The error message is "...uninstall.isu file is corrupted..."|||Yes, it worked (when I picked Modify Existing Installation). Thank you very much.

installation problem

Hi,
I am facing a problem installing MSDE2000 on some computers. When i run my application setup program MSDE gets installed on some computers while it does not install on some others consistently.
I am using a merge module to install MSDE2000 with InstallShiel 9.
The target OS is NT4.0 SP6.
Any inputs will be most welcome.
regards,
Henry
Make sure you download the DevStudio 9.01 service pack from Install Shield
(just to do Tools | Check for Updates from within DevStudio). The merge
module for SQL gets updated with that. Otherwise, Install Shield tech
support might suggest to use the Install Shield redistributable for MSDE
instead.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:EAFBF9A8-B3A3-4D55-82B7-78F4224CB685@.microsoft.com...
> Hi,
> I am facing a problem installing MSDE2000 on some computers. When i run my
application setup program MSDE gets installed on some computers while it
does not install on some others consistently.
> I am using a merge module to install MSDE2000 with InstallShiel 9.
> The target OS is NT4.0 SP6.
> Any inputs will be most welcome.
> regards,
> Henry

Sunday, February 19, 2012

Installation error in SQL Server Evaluation Edition

I downloaded the SQL Server Evaluation Edition from Microsoft.com in ISO form and burned a CD using Nero 7. I have tried to install the program, but I keep getting the error:

"the procedure entry point_create_locale could not be located in the dynamic link library MSVCR80.dll"

I have tried to reinstall Native Client and Setup Support Files with no effect... I have .NET 2.0 installed along with VB Express 2005 and VWB Express 2005... I am running on Windows XP Home SP2.

If anyone could help me, I would greatly appreciate it... I am stuck and can't get any work done until I get this program installed...

You need to look at the setup logs for context. They're located here:

%Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG

If you can find where the error occurs you may see more info on what's going on and that should help figure out what to do next. If you can't figure it out, post a link to the log files here and someone will take a look.

Paul