Showing posts with label installing. Show all posts
Showing posts with label installing. Show all posts

Wednesday, March 21, 2012

ms sql server 2000 personal edition

Error is occured such as "c:\Program Files\Microsoft SQL Server\80\
tools\BINN\Resources\1033\SEMCROS.RLL could not be loaded" while installing in windows xp sp2Question moved to SQL Server Forum.

Ms SQL Server 2000 Installation Problem

Hi all

when installing MS SQL Server 2k i got these errors :

'This program is used internally by PackageFromTheWeb. It should no be executed directly.' (displays 2 times)

... and at the end of setup .. :

'Setup failed to configure the server. Refer to the server error logs and F:\WINNT\sqlstp.log for more information.'

i have also MSDE installed from visual studio.net

anyone got similar problem ?, anyone has an idea how to cope with this ?

thx in advance

in attachment i include sqlstp.logOriginally posted by krotuski
'This program is used internally by PackageFromTheWeb...
'Setup failed to configure the server. see F:\WINNT\sqlstp.log for more information.'
i have also MSDE installed from visual studio.net

I could only find these 2 error messages that relate to the 2nd error message of the issue you reported.

http://support.microsoft.com/default.aspx?scid=kb;en-us;305680

http://support.microsoft.com/default.aspx?scid=kb;en-us;285100

As for the first Message, I couldn't find anything relating to PackageFromTheWeb. Hope the other 2 help.

As a suggestion, I would suggest doing a backup before attempting anything relating to data manipulation/upgrade.

I also noticed a couple of issues related to upgrading MSDE to SQL server 2000 so be prepared for problems and have your backups handy :)|||thx for answer, but none of these were the cause of a problem, anyway, thx for replying|||Did you determine what the problem was, I am getting the same error.
Thanks|||I have msde and SQL personal edition running simultaniously on my xp development box at home so I don't think there should be a problem running both. I use named instances. computername\msde and computername\sql2000

MS SQL Server 2000 Enterprise Edition! Need Help!

hi everyone, i am doing a project on asp.net and i'm want to use the sql server 2000 EE and is using WinXp Pro.
I have problems installing the s/w. It says "Microsoft Server 2000 Enteprise Edition Server Components is not supported on this OS. Only Client components will be available for installation."
Is it true that i can't install SQL Server 2000 EE on XP Pro?
And is it true that i can only use the Standard Edition?

Need Help!
ThanksYes it is true, but you cannot use Standard neither as it needs Server OS as well.

See this page for exact details:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp|||ok..
thanks very much..|||On WindowsXP Pro, you can either use:

a) MSDE
b) SQL Server Developer Edition (available through MSDN Subscription etc)
c) SQL Server Personal Edition

Cheers
Ken

Edit: oops, didn't scroll down far enough on Teemu's link - personal edition is listed on that page! Sorry for the redundant post.|||u mean the Developer Edition can be downloaded from MSDN?|||If you have an MSDN subscription...

http://msdn.microsoft.com/subscriptions/

Cheers
Ken|||thanks

Friday, March 9, 2012

MS SQL Cluster w/ Clariion SAN

Okay, assume that I have read every technical document from MS and Dell about installing SQL into a cluster on a Clariion SAN (I haven't actually read them all yet, but I'm getting there).

What gotcha's are waiting to bite me? I am using:

1. An Active/Passive 2-node cluster
2. Windows 2000 Advanced Server
3. SQL 2000 Enterprise Server
4. EMC Clariion CX400 15-drive array

I have never before configured a cluster server. I got dropped into this project. No one else in the project has any real experience with clusters either.

I have the step-by-step instructions from both Dell and MS: I plan to follow these very carefully. I'm not looking for step-by-step instructions here, I'm hoping for some, "when I tried this, it did that..." or "watch out, the instruction says to do x, but you should really do y..." sort of thing. Also, if you have any additional documentation outside of the vendor required reading, I wuld be grateful for a link.

I understand that there are issues around:
1. Snapview backup from EMC (doesn't work on multi-volume DBs)
2. SQL Mail and SQL Agent Mail (Outlook is not cluster-aware)

I realize this is kind of open-ended; but I really would like to get this right the first time around since it appears that I will be supporting this installation long term.

Regards,

hmscott- http://support.microsoft.com/default.aspx?scid=kb;EN-US;254321 - cluster do's and dont's.
- http://www.sql-server-performance.com/sqlserver2000_clustering_install_part1.asp to stop unnecessary services during setup.

- http://support.microsoft.com/default.aspx?scid=/support/sql/content/70papers/70clstr.asp from the step by step guide pay attention on post installation topics.

- http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/clustering/scconbp.mspx though this refers to cluster on windows2003 best practices, for information.

HTH