MSSQL 2000 Does not Install

Dear Community,

I have recently downloaded the MSSQL 2000 Evaluation package from microsoft website,but i can't get it to install.I run the autorun normally,but when i select the option install database server nothing happens.I am trying to install it on Windows XP Service Pack 2 Edition 5.1....As this would help,in 3-4 hours of computer inactivity,i see the setup loader but nothing happens,it says not responding.

Thanks in advance,

Dimitris.

I believe you cannot install MS sql server 2000 in windows XP only client components can be installed......but you can install sql server 2005 in windows XP with SP2........you can download that and install as the support for sql 2000 is getting over by April 2008 and then only extended support is available........

MsSql , VPS , plsek software .... PROBLEM ! [:(]

Hi ,

like i said i have VPS plan but on this plan the plsek sofware does not support
MsSql , the stuff that host my website told me that they will not support anything that invovled to MsSql

so ... what i was doing till now ?

i download SqlExpress 2005 on the remote machine . and i can login to the Database engine using Windows Authentication ,

also , i have 'webs develeoper express' (asp.net) on my PC and also have SQLExpress 2005 - when i run my website on my PC i successfuly
insert some data into the DataTables .

but when i run the same file on the VPS (after i upload them using FTP)
that does not work and i see this message :

Cannot open database "horse" requested by the login. The login failed. Login failed for user 'VE326\IWPD_4(main)'.

my connectin string on my "DBLayer" class looks like this :

connString = @."Server=(local)\sqlexpress;Integrated Security=True;Database=horse";

ANY IDEA ?

thanks .

Hi greekhand,

The error messaged indicates that it's a login failure. So, just make sure the user account VE326\IWPD_4(main) has sufficient permission to the "horse" database. Open your Management Studio and connect to your db, select the "horse" database and expand it. In the "security" section, choose "Users" and verify if account "ve326\iwpd_4(main)" has been included. And if not, right click and slect "new users", you can assign permissions to that account here.

Hope my suggestion helps

MSDTC service not starting

I have to install MSDTC on an Active/Passive cluster. I got instructions
from microsoft's website on how to enable MSDTC:
http://support.microsoft.com/kb/817064/
but when I follow the instructions, the service never starts. Even when I
try to start the service manually I am unsuccessful.
P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
files will be stored on a Dell CX300 (SAN)..
Any suggestions on what may have caused this.
OK I got the service to start, but only after killing the cluster (in cluster
admin). Now while this was great at the time, it does not make much sense.
The reason being that anytime the cluster is present after that, the MSDTC
service stops. The new issue I have is that while configuring the MSDTC, I
was unable to create the "Physical Disk" resource (for the MSDTC Group),
because the wizard is unable to see/recognise any drives at all !!. Now I
really need some suggestions...
Can anyone help? It wil be most appreciated.
"iqv1" wrote:

> I have to install MSDTC on an Active/Passive cluster. I got instructions
> from microsoft's website on how to enable MSDTC:
> http://support.microsoft.com/kb/817064/
> but when I follow the instructions, the service never starts. Even when I
> try to start the service manually I am unsuccessful.
> P.S. The cluster is being prepared for use by SQL Server 2005, and the DB
> files will be stored on a Dell CX300 (SAN)..
> Any suggestions on what may have caused this.
|||Thank you very much for your assistance Edwin...
"Edwin vMierlo [MVP]" wrote:

> First of all, you need to properly configure MSDTC in your cluster.
> Exact instructions here : http://support.microsoft.com/kb/301600
> You do not necessarily have to create a seperate group with a seperate disk
> resource, unless you expect heavy usage of the MSDTC.
> It is acceptable to put your MSDTC in the default cluster group, using the
> Quorum disk.
> If you have problems adding disk to your cluster, you might want to try this
> article : http://support.microsoft.com/kb/555312
> Rgds,
> Edwin.
>
> "iqv1" <iqv1@.discussions.microsoft.com> wrote in message
> news:C6706333-DB5E-42AE-9CE0-0999A127BDE8@.microsoft.com...
> cluster
> sense.
> I
> instructions
> I
> DB
>
>