Install New Instance/ Store Data & Log Files in existing drive

Hello,
I need to install a new instance of SQL Server 2000 on a cluster.
Currently, we have three instances. Each instances stores program files on
the E:\ Drive. Each instance has its own drive for data and another for
logs. However, there is no more unallocated space on the array to create
another partitioned drive.
My question is: If I create the new instance, can I store the data and log
files on an existing drive? Are there any performance or overhead costs that
should be considered?
Thank you,
Caroline
Each instance must have separate disk resources from any other instances.
You will need new disks to create another instance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Caroline" <Caroline@.community.nospam> wrote in message
news:4E870F35-33B9-4E92-91E6-1993FD8FE4C4@.microsoft.com...
> Hello,
> I need to install a new instance of SQL Server 2000 on a cluster.
> Currently, we have three instances. Each instances stores program files
> on
> the E:\ Drive. Each instance has its own drive for data and another for
> logs. However, there is no more unallocated space on the array to create
> another partitioned drive.
> My question is: If I create the new instance, can I store the data and
> log
> files on an existing drive? Are there any performance or overhead costs
> that
> should be considered?
> Thank you,
> Caroline
sql

Install MSDE2000 by InstallShield Professional 6.1

How can I include the MSDE2000 installation in an InstallShield Professional 6.1 project?
I have get a set of MSDE setup files including an MSI file, and how can I use it?
Thank you for any reply!Have you gotten this to work? I am looking at doing something similar.

Thanks.

Install Error

I am recieving an "Error!" message while installing just
the Microsoft SQL Server Reporting Services Setup Support
Files".
I have met all the pre-requirements and have this running
fine on a development server.
Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
Installer 2.0, and the .NET framework.
The install bombs almost immediately and no log files are
being created for me to troubleshoot.
Thanks.Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
"Chris" wrote:
> I am recieving an "Error!" message while installing just
> the Microsoft SQL Server Reporting Services Setup Support
> Files".
> I have met all the pre-requirements and have this running
> fine on a development server.
> Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> Installer 2.0, and the .NET framework.
> The install bombs almost immediately and no log files are
> being created for me to troubleshoot.
> Thanks.
>|||Same problem here as well. Any tips? /Chris2
"DRS" wrote:
> Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> "Chris" wrote:
> > I am recieving an "Error!" message while installing just
> > the Microsoft SQL Server Reporting Services Setup Support
> > Files".
> >
> > I have met all the pre-requirements and have this running
> > fine on a development server.
> >
> > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > Installer 2.0, and the .NET framework.
> >
> > The install bombs almost immediately and no log files are
> > being created for me to troubleshoot.
> >
> > Thanks.
> >|||Here was the response from Chris, it worked for me, hope this helps you:
"Yes it was strange. I was able to resolve if I remember correctly by
installing from another location. This is what I did and it appeared to
have something to do with the CDROM drive. I donâ't know why. I was
installing to an older HP Netserver and a new Dell Poweredge.
1. I shared my cdrom drive.
2. From the box in question, log onto the share.. start/run
\\â'pcnameâ'\cdrom
3. I ran the setup like that and it worked fine. "
"Chris Leaf" wrote:
> Same problem here as well. Any tips? /Chris2
> "DRS" wrote:
> > Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> >
> > "Chris" wrote:
> >
> > > I am recieving an "Error!" message while installing just
> > > the Microsoft SQL Server Reporting Services Setup Support
> > > Files".
> > >
> > > I have met all the pre-requirements and have this running
> > > fine on a development server.
> > >
> > > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > > Installer 2.0, and the .NET framework.
> > >
> > > The install bombs almost immediately and no log files are
> > > being created for me to troubleshoot.
> > >
> > > Thanks.
> > >

Installation / development questions

I have a client that uses SQL Server 2000. They would like to automate some
reports, including saving them as PDF files. I'm considering the use of SQL
Server 2000 Reporting Services. Currently, their server that is hosting sql
server is only being used for the application.
My questions:
1. What all is involved in installing this on their server?
2. What all is involved in being able to create the reports?
3. Do I have to be able to connect to their server to create reports?
4. Can reporting services be installed on a developer edition of sql
services?
5. Are there any other requirements that I need to be aware of to do this?
Would I be better off going with a different product?
Thanks!See comments inline.
"Wayne Sheffield" <wayne_sheffield@.hotmail.com> wrote in message
news:egifJpR9GHA.3264@.TK2MSFTNGP04.phx.gbl...
>I have a client that uses SQL Server 2000. They would like to automate some
>reports, including saving them as PDF files. I'm considering the use of SQL
>Server 2000 Reporting Services. Currently, their server that is hosting sql
>server is only being used for the application.
> My questions:
> 1. What all is involved in installing this on their server?
Install and set up reporting services on SQL Server is not too difficult.
However, since the Reporting Services is combination of ASP.NET web
application and Windows service and access to high secureable SQL Server,
you need understand user accounts that are used to run these services, in
order to choose correct one during installation.
> 2. What all is involved in being able to create the reports?
Autoring the reports and deploy them to reporting service server. Do author
report, you need VS2003 and install Reporting Services' client tool (report
designer, which is VS2003 add-in) on the developing box
> 3. Do I have to be able to connect to their server to create reports?
You do not need to access a real production data source to design report.
You do not need to connect to a rrunning reporting services either. However,
you do need a test data source (the database where report gets data from) to
develop report.
> 4. Can reporting services be installed on a developer edition of sql
> services?
Yes, SQL Server 2000 Developer Edition runs reporting services. (To run it,
you also need IIS running)
> 5. Are there any other requirements that I need to be aware of to do this?
> Would I be better off going with a different product?
> Thanks!
>

Install Database Components SP3a

Hi,
Do I need to know the sa password when I install Database Components for
SP3a? The extracted service pack files is in the directory of the local
computer.
Thanks.Only if you're installing on the SQL Server/MSDE, not for the clients.
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Yes, preferably. But any account that has system administrator privileges to
SQL Server should suffice I suppose. "sa" account is safe and sure to have
all the access to the database files for sure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
http://www.extremeexperts.com
"Samuel Yap" <yaphcs@.yahoo.com> wrote in message
news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> Hi,
> Do I need to know the sa password when I install Database Components for
> SP3a? The extracted service pack files is in the directory of the local
> computer.
> Thanks.
>|||Noted. Thanks.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eqSUIi0dDHA.3992@.TK2MSFTNGP11.phx.gbl...
> Yes, preferably. But any account that has system administrator privileges
to
> SQL Server should suffice I suppose. "sa" account is safe and sure to have
> all the access to the database files for sure.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD
> http://www.extremeexperts.com
>
> "Samuel Yap" <yaphcs@.yahoo.com> wrote in message
> news:%231rcsX0dDHA.3596@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Do I need to know the sa password when I install Database Components for
> > SP3a? The extracted service pack files is in the directory of the local
> > computer.
> >
> > Thanks.
> >
> >
>

Install Client Connectivity (SQL Server 2000) Only w/ Less Files?

I have a 500-MB full installation CD for SQL Server 2000. All I need
is to install "Client Connectivity" component (about 272K) on a bunch
of workstations for users across the nation.

How do I reduce the installation file size, by eliminating most of the
unwanted files?

Thanks.(pengfrank@.gmail.com) writes:
> I have a 500-MB full installation CD for SQL Server 2000. All I need
> is to install "Client Connectivity" component (about 272K) on a bunch
> of workstations for users across the nation.
> How do I reduce the installation file size, by eliminating most of the
> unwanted files?

What precisely are you looking for? Client Connectivity is mainly
MDAC 2.6 I believe, even if there are also files needed for DB-Library.

If you are looking for MDAC, keep in mind that computers running
Windows XP and Windows 2003 already have MDAC 2.7 and 2.8 respectively.
For Windows 2000, Windows NT and the toy Windowses you need MDAC 2.6
though. But you can download MDAC 2.6 from www.microsoft.com. Be sure
to also download the latest service pack for the MDAC.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks for your information. I will just download the MDAC which has
only 5 MB.

Install

I just installed sql server 2005 express and everything seemed to go well. However I only see the configuration tools under program files in the start menu.

Any suggestions would be appreciated.

Thanks!

I'd suggest that you start using SQL Express! (Sorry, had to do it.)

SQL Express only includes the database engine and the configuration tools, so you're seeing exactly what you should. You can work with the engine using a number of different tools, here are a few:

SQLCmd - Command line tool included with SQL Express to run T-SQL Commands.|||

Thanks, this helps.

I actually wanted to initially load the free msde but got an error that said:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer tp the readme for more details. Setup will now exit"

I downloaded msde 2000 release A. Is that the correct version for the old msde?

Can you give me any advice on this. Thanks!

David

|||

Hi David,

SQL Express is newer than MSDE 2000 and offers some improved functionality, but if you want to use the older version...

I would go for MSDE 2000 SP4 since that is newer than Release A. The behavior you describe is by design since you must supply a strong password for the SA account when installing MSDE. The readme file that is available on the download page for MSDE explains how to install it and the correct usage of the SAPWD switch.

Mike

Inserting XML with SSIS - VERY URGENT!!!

Hello everybody,

I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example:

Files Tables

user.xml user

purchase.xml purchase

...and so

but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day.
Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way? If it's possible, how?

Thanks in advance for your help,

Radamante71

You might want to post your question at SQL Server Integration Services forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1.

Inserting with XML files - VERY URGENT!!!

Hello everybody,

I have a problem. I need to insert an unknown number of xml files in a database (all files are always in the same folder), in different tables, each file has the same name that the corresponding table. For example:

Files Tables

user.xml user

purchase.xml purchase

...and so

but the number of files is not always the same, I mean, it can be 6 one day and only 4 the next day.
Can I insert the data in the xml files into the tables with a Foreach Loop Container or any other way? If it's possible, how?

Thanks in advance for your help,

Radamante71

Create a ForEach Loop task to read the files from the directory and assign the name to a variable. Then add a dataflow task to the foreach loop and in your XML source file, select "XML File from variable", then select the variable name.|||

Tom suggestion will work if all file/tables had the same structure, which I doubt. To the original poster: I think what you want to accomplish is not possible. Basically you are asking to create the source-to-target data mapping on the fly and that is something you cannot do in a SSIS package (at least to my knowledge).

Rafael Salas

|||

Rafael,

One question:

Do you speak spanish? Because if you do, we can continue in spanish. I'm spanish and I think that I can explain you my problem in a better way if I do it in my language.

Thanks

|||You are correct. I don't see any way to use a variable XSD file.

However, you could use the "Inline Schema" in the file, that would work.|||

Radamante,

Yes, I do speak; but I don't think it would be a good idea to continue this thread in Spanish; that could irritate some non-Spanish speaker folks in this forum. If you want, send me an e-mail with your problem (be sure to de-spam my email address before) to see if I can help you.

Rafael Salas