New SQL Server Install Advice

I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
containers as the machine has a PERC 4 controller. The machine has x2 73GB
SCSI and x4 146GB SCSI HDD.
Container 1
--
The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which has
56GB free.
Container 2
--
A D drive for Data I created and also L for Log which I assigned as dynamic
drives.
Is this setup Ok for running SQL2000. The Data files will reside in D and
the Log files will reside in L. Is this Ok for the read/write access that
occurs when SQL is accessed?
Please help.
skcI assume there is at least one processor and some memory on the server as
well.
It will work. It depends on what performance, capacity, and availability
you are needing.
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> containers as the machine has a PERC 4 controller. The machine has x2
> 73GB
> SCSI and x4 146GB SCSI HDD.
> Container 1
> --
> The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> has
> 56GB free.
> Container 2
> --
> A D drive for Data I created and also L for Log which I assigned as
> dynamic
> drives.
> Is this setup Ok for running SQL2000. The Data files will reside in D and
> the Log files will reside in L. Is this Ok for the read/write access that
> occurs when SQL is accessed?
> Please help.
> skc|||Xeon 2.8 x2 and 2GB RAM.
We want max. performance. Is this OK?
Furthermore, I installed SQL2000 and it came with 4 CDs:
1> SQL 2000 Standard (Personal)
2> SQL 2000 Standard
3> SP4
4> Reporting Tools
I installed Disk #1, asked me no product key, I selected 5 CALS from the
dropdown (which was how many I bought) and that was it. I have the SQL
Service running and the SQL Tools (enterprise manager). What is the
difference between the 2 Cds mentioned above?
In Enterprise Manager, when I right-click the (local) Server, it says I have
Microsoft SQL Server Std Edition installed. This is very odd, I hope I have
done this right as it did not ask for a serial product key or anything.
Please verify the above it OK.
"Danny" wrote:

> I assume there is at least one processor and some memory on the server as
> well.
> It will work. It depends on what performance, capacity, and availability
> you are needing.
> "Skc" <Skc@.discussions.microsoft.com> wrote in message
> news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>
>

New SQL Server Install Advice

I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
containers as the machine has a PERC 4 controller. The machine has x2 73GB
SCSI and x4 146GB SCSI HDD.
Container 1
The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which has
56GB free.
Container 2
A D drive for Data I created and also L for Log which I assigned as dynamic
drives.
Is this setup Ok for running SQL2000. The Data files will reside in D and
the Log files will reside in L. Is this Ok for the read/write access that
occurs when SQL is accessed?
Please help.
skc
I assume there is at least one processor and some memory on the server as
well.
It will work. It depends on what performance, capacity, and availability
you are needing.
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> containers as the machine has a PERC 4 controller. The machine has x2
> 73GB
> SCSI and x4 146GB SCSI HDD.
> Container 1
> --
> The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> has
> 56GB free.
> Container 2
> --
> A D drive for Data I created and also L for Log which I assigned as
> dynamic
> drives.
> Is this setup Ok for running SQL2000. The Data files will reside in D and
> the Log files will reside in L. Is this Ok for the read/write access that
> occurs when SQL is accessed?
> Please help.
> skc
|||Xeon 2.8 x2 and 2GB RAM.
We want max. performance. Is this OK?
Furthermore, I installed SQL2000 and it came with 4 CDs:
1> SQL 2000 Standard (Personal)
2> SQL 2000 Standard
3> SP4
4> Reporting Tools
I installed Disk #1, asked me no product key, I selected 5 CALS from the
dropdown (which was how many I bought) and that was it. I have the SQL
Service running and the SQL Tools (enterprise manager). What is the
difference between the 2 Cds mentioned above?
In Enterprise Manager, when I right-click the (local) Server, it says I have
Microsoft SQL Server Std Edition installed. This is very odd, I hope I have
done this right as it did not ask for a serial product key or anything.
Please verify the above it OK.
"Danny" wrote:

> I assume there is at least one processor and some memory on the server as
> well.
> It will work. It depends on what performance, capacity, and availability
> you are needing.
> "Skc" <Skc@.discussions.microsoft.com> wrote in message
> news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>
>

New SQL Server Install Advice

I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
containers as the machine has a PERC 4 controller. The machine has x2 73GB
SCSI and x4 146GB SCSI HDD.
Container 1
--
The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which has
56GB free.
Container 2
--
A D drive for Data I created and also L for Log which I assigned as dynamic
drives.
Is this setup Ok for running SQL2000. The Data files will reside in D and
the Log files will reside in L. Is this Ok for the read/write access that
occurs when SQL is accessed?
Please help.
skcI assume there is at least one processor and some memory on the server as
well.
It will work. It depends on what performance, capacity, and availability
you are needing.
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
>I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> containers as the machine has a PERC 4 controller. The machine has x2
> 73GB
> SCSI and x4 146GB SCSI HDD.
> Container 1
> --
> The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> has
> 56GB free.
> Container 2
> --
> A D drive for Data I created and also L for Log which I assigned as
> dynamic
> drives.
> Is this setup Ok for running SQL2000. The Data files will reside in D and
> the Log files will reside in L. Is this Ok for the read/write access that
> occurs when SQL is accessed?
> Please help.
> skc|||Xeon 2.8 x2 and 2GB RAM.
We want max. performance. Is this OK?
Furthermore, I installed SQL2000 and it came with 4 CDs:
1> SQL 2000 Standard (Personal)
2> SQL 2000 Standard
3> SP4
4> Reporting Tools
I installed Disk #1, asked me no product key, I selected 5 CALS from the
dropdown (which was how many I bought) and that was it. I have the SQL
Service running and the SQL Tools (enterprise manager). What is the
difference between the 2 Cds mentioned above?
In Enterprise Manager, when I right-click the (local) Server, it says I have
Microsoft SQL Server Std Edition installed. This is very odd, I hope I have
done this right as it did not ask for a serial product key or anything.
Please verify the above it OK.
"Danny" wrote:
> I assume there is at least one processor and some memory on the server as
> well.
> It will work. It depends on what performance, capacity, and availability
> you are needing.
> "Skc" <Skc@.discussions.microsoft.com> wrote in message
> news:46CDFADB-7AC6-4719-B0A8-8154D6977397@.microsoft.com...
> >I have a new Dell PowerEdge 2800 running windows 2003. I have 2 RAID
> > containers as the machine has a PERC 4 controller. The machine has x2
> > 73GB
> > SCSI and x4 146GB SCSI HDD.
> >
> > Container 1
> > --
> > The OS C drive (partition of 12GB) is in RAID 1 and so is E drive which
> > has
> > 56GB free.
> >
> > Container 2
> > --
> > A D drive for Data I created and also L for Log which I assigned as
> > dynamic
> > drives.
> >
> > Is this setup Ok for running SQL2000. The Data files will reside in D and
> > the Log files will reside in L. Is this Ok for the read/write access that
> > occurs when SQL is accessed?
> >
> > Please help.
> >
> > skc
>
>

New Install Error

Hi,
I'm installing Reporting Services on our productions
server which is a domain controller, Windows 2003.
The database is on a different server, so it would be a
remote install of the databases. I keep getting error
messages that say 'can not create database'. I'm using sa
as a sql login, which has administrative rights.
Please let me know if you need anymore information.
Thanks in Advance,
MarciaBy default, setup uses the credentials of the user running setup to create
the report server database. The screen where you configure the report
server database only allows you to specify credentials the report server
uses to access the database (after setup is over).
To use a SQL login to create the report server database, you need to specify
RSSETUPACCOUNT and RSSETUPPASSWORD on the command line when running setup.
More info here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_6h6h.asp
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcia" <anonymous@.discussions.microsoft.com> wrote in message
news:461701c47332$7e57f870$a501280a@.phx.gbl...
> Hi,
> I'm installing Reporting Services on our productions
> server which is a domain controller, Windows 2003.
> The database is on a different server, so it would be a
> remote install of the databases. I keep getting error
> messages that say 'can not create database'. I'm using sa
> as a sql login, which has administrative rights.
> Please let me know if you need anymore information.
> Thanks in Advance,
> Marcia