Estimate disk space required for my DB

Hi All,
I got some hints on estimating the table size from BOL.
But how do I estimate other objects like SP, UDF etc.
I want to estimate the disk size required at my deployment
SQL Server box.
Is there any tool available to estimate the DB size?
Thanks in advance,
Hari
These objects basically don't use any space. Well, the do use a row per object in sysobjects, a row
per parameter in syscolumns and a row per object in syscomments. The last one will contain the
actual source code for the object. I wouldn't worry about these things...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari
|||Hi
The biggest size will always be the data, stored procedures and function
definitions are mainly held in the syscomments tables. It should be pretty
static therefore once you have loaded them into the database it will not
change.
John
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari
|||Hi,
Add on to Tiber,
Is there any tool available to estimate the DB size?
No tool can suggest you the actual hard disk requirement.
There is no easy way to estimate precisely the storage requirements for a
given database.
If an accurate size estimate is needed, it is suggested that a test database
is setup in a test server with
suitable fields, numbers of tables and queries. It should be filled with
suitable random data
and operated as a database for a short time before attempting to measure the
disk storage needed
to store and manage all the information.
If you have an existing system you can calculate the hard disk requirement
based on that.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
> These objects basically don't use any space. Well, the do use a row per
object in sysobjects, a row
> per parameter in syscolumns and a row per object in syscomments. The last
one will contain the
> actual source code for the object. I wouldn't worry about these things...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
> news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
>
|||Thanks Hari for your reply.
I fully agree with you. But I'm looking for a tool/script
which will implement the table estimate calculation (as in
BOL). Instead of applying those calculation manually for
each table, a script/tool may help me.
What is the standard approach for disk sizing for an
application?
Thanks a lot.
Hari
>--Original Message--
>Hi,
>Add on to Tiber,
>Is there any tool available to estimate the DB size?
>No tool can suggest you the actual hard disk requirement.
>There is no easy way to estimate precisely the storage
requirements for a
>given database.
>If an accurate size estimate is needed, it is suggested
that a test database
>is setup in a test server with
>suitable fields, numbers of tables and queries. It should
be filled with
>suitable random data
>and operated as a database for a short time before
attempting to measure the
>disk storage needed
>to store and manage all the information.
>If you have an existing system you can calculate the hard
disk requirement
>based on that.
>--
>Thanks
>Hari
>MCDBA
>"Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in[vbcol=seagreen]
>message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
do use a row per[vbcol=seagreen]
>object in sysobjects, a row
syscomments. The last[vbcol=seagreen]
>one will contain the
about these things...[vbcol=seagreen]
wrote in message[vbcol=seagreen]
BOL.[vbcol=seagreen]
deployment
>
>.
>

Estimate disk space required for my DB

Hi All,
I got some hints on estimating the table size from BOL.
But how do I estimate other objects like SP, UDF etc.
I want to estimate the disk size required at my deployment
SQL Server box.
Is there any tool available to estimate the DB size?
Thanks in advance,
HariThese objects basically don't use any space. Well, the do use a row per object in sysobjects, a row
per parameter in syscolumns and a row per object in syscomments. The last one will contain the
actual source code for the object. I wouldn't worry about these things...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari|||Hi
The biggest size will always be the data, stored procedures and function
definitions are mainly held in the syscomments tables. It should be pretty
static therefore once you have loaded them into the database it will not
change.
John
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari|||Hi,
Add on to Tiber,
Is there any tool available to estimate the DB size?
No tool can suggest you the actual hard disk requirement.
There is no easy way to estimate precisely the storage requirements for a
given database.
If an accurate size estimate is needed, it is suggested that a test database
is setup in a test server with
suitable fields, numbers of tables and queries. It should be filled with
suitable random data
and operated as a database for a short time before attempting to measure the
disk storage needed
to store and manage all the information.
If you have an existing system you can calculate the hard disk requirement
based on that.
--
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
> These objects basically don't use any space. Well, the do use a row per
object in sysobjects, a row
> per parameter in syscolumns and a row per object in syscomments. The last
one will contain the
> actual source code for the object. I wouldn't worry about these things...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
> news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
> > Hi All,
> >
> > I got some hints on estimating the table size from BOL.
> > But how do I estimate other objects like SP, UDF etc.
> >
> > I want to estimate the disk size required at my deployment
> > SQL Server box.
> >
> > Is there any tool available to estimate the DB size?
> >
> > Thanks in advance,
> > Hari
>|||Thanks Hari for your reply.
I fully agree with you. But I'm looking for a tool/script
which will implement the table estimate calculation (as in
BOL). Instead of applying those calculation manually for
each table, a script/tool may help me.
What is the standard approach for disk sizing for an
application?
Thanks a lot.
Hari
>--Original Message--
>Hi,
>Add on to Tiber,
>Is there any tool available to estimate the DB size?
>No tool can suggest you the actual hard disk requirement.
>There is no easy way to estimate precisely the storage
requirements for a
>given database.
>If an accurate size estimate is needed, it is suggested
that a test database
>is setup in a test server with
>suitable fields, numbers of tables and queries. It should
be filled with
>suitable random data
>and operated as a database for a short time before
attempting to measure the
>disk storage needed
>to store and manage all the information.
>If you have an existing system you can calculate the hard
disk requirement
>based on that.
>--
>Thanks
>Hari
>MCDBA
>"Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
>> These objects basically don't use any space. Well, the
do use a row per
>object in sysobjects, a row
>> per parameter in syscolumns and a row per object in
syscomments. The last
>one will contain the
>> actual source code for the object. I wouldn't worry
about these things...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Hari Shankar" <anonymous@.discussions.microsoft.com>
wrote in message
>> news:23b5101c45f37$15b43c70$a601280a@.phx.gbl...
>> > Hi All,
>> >
>> > I got some hints on estimating the table size from
BOL.
>> > But how do I estimate other objects like SP, UDF etc.
>> >
>> > I want to estimate the disk size required at my
deployment
>> > SQL Server box.
>> >
>> > Is there any tool available to estimate the DB size?
>> >
>> > Thanks in advance,
>> > Hari
>>
>
>.
>sql

Estimate disk space required for my DB

Hi All,
I got some hints on estimating the table size from BOL.
But how do I estimate other objects like SP, UDF etc.
I want to estimate the disk size required at my deployment
SQL Server box.
Is there any tool available to estimate the DB size?
Thanks in advance,
HariThese objects basically don't use any space. Well, the do use a row per obje
ct in sysobjects, a row
per parameter in syscolumns and a row per object in syscomments. The last on
e will contain the
actual source code for the object. I wouldn't worry about these things...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx
.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari|||Hi
The biggest size will always be the data, stored procedures and function
definitions are mainly held in the syscomments tables. It should be pretty
static therefore once you have loaded them into the database it will not
change.
John
"Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
news:23b5101c45f37$15b43c70$a601280a@.phx
.gbl...
> Hi All,
> I got some hints on estimating the table size from BOL.
> But how do I estimate other objects like SP, UDF etc.
> I want to estimate the disk size required at my deployment
> SQL Server box.
> Is there any tool available to estimate the DB size?
> Thanks in advance,
> Hari|||Hi,
Add on to Tiber,
Is there any tool available to estimate the DB size?
No tool can suggest you the actual hard disk requirement.
There is no easy way to estimate precisely the storage requirements for a
given database.
If an accurate size estimate is needed, it is suggested that a test database
is setup in a test server with
suitable fields, numbers of tables and queries. It should be filled with
suitable random data
and operated as a database for a short time before attempting to measure the
disk storage needed
to store and manage all the information.
If you have an existing system you can calculate the hard disk requirement
based on that.
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
> These objects basically don't use any space. Well, the do use a row per
object in sysobjects, a row
> per parameter in syscolumns and a row per object in syscomments. The last
one will contain the
> actual source code for the object. I wouldn't worry about these things...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hari Shankar" <anonymous@.discussions.microsoft.com> wrote in message
> news:23b5101c45f37$15b43c70$a601280a@.phx
.gbl...
>|||Thanks Hari for your reply.
I fully agree with you. But I'm looking for a tool/script
which will implement the table estimate calculation (as in
BOL). Instead of applying those calculation manually for
each table, a script/tool may help me.
What is the standard approach for disk sizing for an
application?
Thanks a lot.
Hari
>--Original Message--
>Hi,
>Add on to Tiber,
>Is there any tool available to estimate the DB size?
>No tool can suggest you the actual hard disk requirement.
>There is no easy way to estimate precisely the storage
requirements for a
>given database.
>If an accurate size estimate is needed, it is suggested
that a test database
>is setup in a test server with
>suitable fields, numbers of tables and queries. It should
be filled with
>suitable random data
>and operated as a database for a short time before
attempting to measure the
>disk storage needed
>to store and manage all the information.
>If you have an existing system you can calculate the hard
disk requirement
>based on that.
>--
>Thanks
>Hari
>MCDBA
>"Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:OWbFFozXEHA.712@.TK2MSFTNGP11.phx.gbl...
do use a row per[vbcol=seagreen]
>object in sysobjects, a row
syscomments. The last[vbcol=seagreen]
>one will contain the
about these things...[vbcol=seagreen]
wrote in message[vbcol=seagreen]
BOL.[vbcol=seagreen]
deployment[vbcol=seagreen]
>
>.
>

Errors using the uninstall tool - 'vs_uninst_betas'

Hi Folks

getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it.

the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds

What are you trying to uninstall?

This tool was written by VS, it might be valueable to post this question into one of the VS forums.

Mike

|||

Hi Mike,

i am trying to install SQL server express edition 2005 however i am being told that there are incompatable components from beta versions of visual studio, .net framework or sql 2005. I have removed all of these and rebooted and run the tool however it makes no difference.

Previously both the express edition and the full edition of sql2005 have been on this computer at seperate times, however both have been removed. I have tried to install the full version however the same error occurs.

I have removed everything remotely connected with sql 2005, .net and visual studio and the problem remains.

I can email you screen shots of all error messages if required

thanks for the help

Nick

|||

Hi Nick,

The setup log should list the specific components that are causing the problem on your computer. If you can not find those components listed in Add/Remove Programs, you can remove them manually using the following in the Run dialog:

msiexec /x <product id>

Product ID will be a long number listed in the setup log for each of the offending product. Run this for each of the products listed in the log.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi Mike,

again thanks for replying to me!

Unfortunately your reply was of limited help. I am not sure what/where the setup log is that you refer to. When the original error messages appear after running the tool, there are no product id’s and no indication of what they are.

if you let me know where to get the setup log i will run

msiexec /x <product id>

for the offending products

thanks in advance

nick

|||

Hi Nick,

You can find the setup logs at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. The summary.txt has general information, will usually tell you which specific component of SQL failed to install and point you to a more detailed log in the Files folder. The detailed log should contain the product IDs.

Mike

|||

hi,

the information stored in the summary.txt is as follows -

Microsoft SQL Server 2005 Setup beginning at Mon Jul 17 12:27:30 2006
Process ID : 1268
c:\b4bd99cb30de03073795be5c67\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/6/17 12:27:30
Complete: LoadResourcesAction at: 2006/6/17 12:27:30, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30
Loaded DLL:c:\b4bd99cb30de03073795be5c67\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30, returned true
Running: ValidateWinNTAction at: 2006/6/17 12:27:30
Complete: ValidateWinNTAction at: 2006/6/17 12:27:30, returned true
Running: ValidateMinOSAction at: 2006/6/17 12:27:30
Complete: ValidateMinOSAction at: 2006/6/17 12:27:30, returned true
Running: PerformSCCAction at: 2006/6/17 12:27:30
Complete: PerformSCCAction at: 2006/6/17 12:27:30, returned true
Running: ActivateLoggingAction at: 2006/6/17 12:27:30
Complete: ActivateLoggingAction at: 2006/6/17 12:27:30, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1268" returned false.
Running: PerformSCCAction2 at: 2006/6/17 12:27:30
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.

i am unable to manually delete the last two using the run command that you supplied as it says the installation package could not be opened when i place the product id in the run command. is it possible to manually remove these last two items in some other way?

as always mike - thanks for your help

nick

|||

sorry for the delay Nick, this one fell off the radar.

If the manual uninstall trick doesn't work, it could be that the product is actually already uninstalled and only the Add/Remove Programs entry still exists, which is messing things up. As a last resort, you can try the Windows Installer Cleanup Utility, which removes entries from the ARP list. If that doesn't resolve the issue, I'm not sure what is wrong with your computer. You may need to phone into support to get more directed help.

Mike

|||

Hi Mike

I think a reformat may be in order! Thanks for all the help.

By the way, would you know of a good article/thread on how to preform sql 2005 express back ups by any chance?

thanks again for all the help

nick

|||

just what i needed.. great application

many thanks

:)

|||

I don't think the definitive article exists on backup for Express, we pretty much default to "just use Windows Task Scheduler" like that really helps. That said, I've found a few interesting bits to suffice untill I finally write the definitive article.

One of our MVPs wrote a couple articles, a SProc and a tool that helps with maintenance of your database. Check it out at http://www.sqldbatips.com/showarticle.asp?ID=27.sql

Errors using the uninstall tool - 'vs_uninst_betas'

Hi Folks

getting the following error message when using the tool and can get past it. i can email the error dialog to you if required, i just cant post it.

the setup has encountered an unexpected error in data store. The action is RestoreSetupParams. The error is: Failed to read property installl ds

What are you trying to uninstall?

This tool was written by VS, it might be valueable to post this question into one of the VS forums.

Mike

|||

Hi Mike,

i am trying to install SQL server express edition 2005 however i am being told that there are incompatable components from beta versions of visual studio, .net framework or sql 2005. I have removed all of these and rebooted and run the tool however it makes no difference.

Previously both the express edition and the full edition of sql2005 have been on this computer at seperate times, however both have been removed. I have tried to install the full version however the same error occurs.

I have removed everything remotely connected with sql 2005, .net and visual studio and the problem remains.

I can email you screen shots of all error messages if required

thanks for the help

Nick

|||

Hi Nick,

The setup log should list the specific components that are causing the problem on your computer. If you can not find those components listed in Add/Remove Programs, you can remove them manually using the following in the Run dialog:

msiexec /x <product id>

Product ID will be a long number listed in the setup log for each of the offending product. Run this for each of the products listed in the log.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi Mike,

again thanks for replying to me!

Unfortunately your reply was of limited help. I am not sure what/where the setup log is that you refer to. When the original error messages appear after running the tool, there are no product id’s and no indication of what they are.

if you let me know where to get the setup log i will run

msiexec /x <product id>

for the offending products

thanks in advance

nick

|||

Hi Nick,

You can find the setup logs at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG. The summary.txt has general information, will usually tell you which specific component of SQL failed to install and point you to a more detailed log in the Files folder. The detailed log should contain the product IDs.

Mike

|||

hi,

the information stored in the summary.txt is as follows -

Microsoft SQL Server 2005 Setup beginning at Mon Jul 17 12:27:30 2006
Process ID : 1268
c:\b4bd99cb30de03073795be5c67\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/6/17 12:27:30
Complete: LoadResourcesAction at: 2006/6/17 12:27:30, returned true
Running: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30
Loaded DLL:c:\b4bd99cb30de03073795be5c67\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/6/17 12:27:30, returned true
Running: ValidateWinNTAction at: 2006/6/17 12:27:30
Complete: ValidateWinNTAction at: 2006/6/17 12:27:30, returned true
Running: ValidateMinOSAction at: 2006/6/17 12:27:30
Complete: ValidateMinOSAction at: 2006/6/17 12:27:30, returned true
Running: PerformSCCAction at: 2006/6/17 12:27:30
Complete: PerformSCCAction at: 2006/6/17 12:27:30, returned true
Running: ActivateLoggingAction at: 2006/6/17 12:27:30
Complete: ActivateLoggingAction at: 2006/6/17 12:27:30, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__1268" returned false.
Running: PerformSCCAction2 at: 2006/6/17 12:27:30
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

Class not registered.

i am unable to manually delete the last two using the run command that you supplied as it says the installation package could not be opened when i place the product id in the run command. is it possible to manually remove these last two items in some other way?

as always mike - thanks for your help

nick

|||

sorry for the delay Nick, this one fell off the radar.

If the manual uninstall trick doesn't work, it could be that the product is actually already uninstalled and only the Add/Remove Programs entry still exists, which is messing things up. As a last resort, you can try the Windows Installer Cleanup Utility, which removes entries from the ARP list. If that doesn't resolve the issue, I'm not sure what is wrong with your computer. You may need to phone into support to get more directed help.

Mike

|||

Hi Mike

I think a reformat may be in order! Thanks for all the help.

By the way, would you know of a good article/thread on how to preform sql 2005 express back ups by any chance?

thanks again for all the help

nick

|||

just what i needed.. great application

many thanks

:)

|||

I don't think the definitive article exists on backup for Express, we pretty much default to "just use Windows Task Scheduler" like that really helps. That said, I've found a few interesting bits to suffice untill I finally write the definitive article.

One of our MVPs wrote a couple articles, a SProc and a tool that helps with maintenance of your database. Check it out at http://www.sqldbatips.com/showarticle.asp?ID=27.

Errors in the high-level relational engine

I'm getting an error when processing a partition - Errors in the high-level relational engine. The table_name table that is required for a join cannot be reached based on the relationships in the data source view.

This table is actually joined to another dimension table, which is then joined to the fact table.

How can I resolve this error?

I did notice that there are no keys in the dimension table that relate to the fact table for this particular table. Is this a data issue?|||Well, that might be the reason... To be honest I can't imagine a business case where you have a dimension table without any link to a fact table... Perhaps you can help me to understand you issue...|||

Usually I find that missing dimension key issue when there is corruption in the data. My underlying view was actually pointed to the wrong database - I corrected that but surprisingly it still didn't fix the problem.

Interestingly enough, the previous AS 2000 database used the 'name' column as a key for some of the dimensions. In AS 2000 this was acceptable as long as they were unique. AS 2005 doesn't like that so much. So I went through each dimension & changed it's key column to the proper key.

I am still troubleshooting for some other dimensions. I think it has something to do with the datatype being bigint instead of double in a dimension key. I am finding this to be a very tedious and time-consuming process.

If there's any way of visuallizing the two queries side-by-side to compare dimension/fact table keys that may help me.

Also, are there any resources on how to best hook up a dimension that has a related dimension but no fact table key. (eg Dimension Group links to Dimension links to Fact)?

|||

Andrew,

you can define a snowflake schema (Dimension Group links to Dimension links to Fact). You simply define more than one table in your dimension...

I think SSAS 2005 is more restrictive when it comes to keys. And yes, I think it's good. It takes some time to get used to it but a good design helps you much in this case... And having a name as a key is everything but best practice...

Having a double as a key is also not best practice... It's much better to have int/bigint at this point...

You can also switch on the build-in "unknown member" support... It's much better to do that on your own in the ETL process but i.e. if you set your cube directly on top of a productive system it might be helpful...

|||

Good tips. thanks! I am just trying to get it processing successfully, so the double/bigint switch will be something to try afterwards. The dimension/fact table key data should line up and there is a big problem when every record has unknown dimension members.

Let's hope that processing 21m rows in the dimension today is faster than yesterday.

ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot be used

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot be used

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot be

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

ERROR: The cabinet file ''Sql.cab'' required for this installation is corrupt and cannot be

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

|||

Haha! installing over a network of sort!

I copied the files to a local path and it sure works.

Thanks.

ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

|||

Haha! installing over a network of sort!

I copied the files to a local path and it sure works.

Thanks.

ERROR: The cabinet file 'Sql.cab' required for this installation is corrupt and cannot

As the title indicates, I'm having this error during installation. It occurs when I try to install
the "Management Studio" part of the program. I've tried a bunch of things like
copying to hard drive and installing, but to no avail. To isolate the problem, i've even tried removing Reporting services, since at the time of failure it seems to be trying to install/configure the Microsoft.Reporting Services dll.

Additionally, I have SQL Express installed (installed it separately, not as part of the SQL 2005 DVD), VS 2005, .NET Framework 2.0, SQL Management Studio Express CTP. Could the Management Studio Express be causing a problem?

Please note:
Although the error is about missing / corrupt Sql.cab, I have searched the entire dvd for the said file, but there is no file called Sql.cab on the dvd. Am I missing something?

Any solution would be greatly appreciated.

TIA

We don't support Management Studio Express and Management Studio side by side on the same box. Remove Management Studio Express and I bet you'll be OK.

Alternate theory, if that doesn't work: possibly your media is corrupt, as the error message says.

|||

Hi Paul,

By installling SQL 2005 , I detected the same error.

Is there any solution for it ?

Thanks in advance

Marnix

|||Same Problem on the Sql2005 32bit developer cd. It trys to find dtserver.exe off of the sql.cab file and its not found. This is on an installed sql 2005 server, that is sp1 when I go back and try to install the integration services.|||

The exact error message I get when trying to install the services are:

Integration services install
Product version 9.00.1399.06

The File 'msdtssrvr.exe. cannot be installed because the file cannot be found in cabinet file 'sql.cab'. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1334

When I try to install reporting services
Product version 9.00.1399.06

The cabinet file 'sql.cab; required for this installation is corrupt and cannot be used. This could indicate a network error, an error reading from the cd-rom, or a problem with this package.
error 1335

Does anyone have suggestions? The only other point of interest is that this sql server is running on a Microsoft Virtual Server 2005 R2. The OS running is Windows 2003R2 enterprise sp1.

I've also gone back and tried to install after copying the cd to the virtual server.

|||

Resolved!...

I decided to try a command line install of the components i wanted to add..

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

That did not apparently help me, so I started searching the install cd for other options...

I ended up going to the install disc into the setup folder and running SqlRun_DTS.msi. It generated one error, apparently not fatal, continued and then allowed me to install the integration services off of the CD.

I've also reapplied the Sql2005 SP1 since I can't even run an csv file import without it ;)

Hope this helps others.

|||

That sounds encouraging. I'll give it a spin and post back with my results. If someone else tries it please post back too.

Update:
Hmm still no juice. I tried to run the SqlRun_Tools.msi (that's where the problem was) and this is what I'm now getting...

"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."

I have absolutely no idea where or what template.ini is. I have also removed all SQL Express items (i.e. SQL Express Management Studio, SQL Express Books Online, SQL Express - the server).

|||

Is Your Problem Solved

if Yes Please Tell meWhat is The Solution Of That One

Because I also Face Same Problem

Gaurav Kumar Jain

E-Mail:-- monu_jain2k4@.yahoo.com

|||I ended up installing those components from the Enterprise edition cd (the developer edition was throwing the error in my case).|||The components were corrupted on my Developer edition dvd. I installed them from the Enterprise Edition DVD. Just insert a different cd when doing the install and choosing that for the other components.|||

Hi people,

I have been having this problem and I believe this issue stems from the fact that we are all trying to install from either a virtual CD/DVD loaded from an ISO image or a CD/DVD drive shared across the network or the CD/DVD contents have been copied to a directory on the server itself.

The solution?

The only way I have gotten a trouble free installation of SQL 2005 is to do it from a CD/DVD drive directly connected to the server on which you want to have SQL installed to.

I am surprised that it is not possible to install SQL from a virtual CD drive with an ISO file, some of our servers have a temporary CD/DVD drive attached when making the base OS install which is then removed when fitting into the rack.

Can't believe this behaviour is by design.

Anyhow thought I would share my experiences with SQL installations thus far,hopefully it will help someone.

TTFN

|||

Haha! installing over a network of sort!

I copied the files to a local path and it sure works.

Thanks.

Error: 'table that is required for a join cannot be reached'

Hello all,

I'm running into an odd error when trying to process a newly created dimension, I've looked at the 2 postings with a similar error, but they don't appear to pertain. Here is the error:

Error 1 Errors in the high-level relational engine. The 'dbo_Company_Address' table that is required for a join cannot be reached based on the relationships in the data source view.

Error 2 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Company', Name of 'Company-Location' was being processed.

Error 3 Errors in the OLAP storage engine: An error occurred while the 'Company' attribute of the 'Company-Location' dimension from the 'datawarehouse' database was being processed.

... processing then fails.

I was running into the same error using a data view with the full database schema and working cubes, so I started over, trying to simplify: I created a new project for a new database, created a new DSV, reduced the number of tables and confirmed that all relationships were correct (I did need to add some relationships where the wizard did not pick up on some links). I confirmed that the DSV did show the relation between dbo.Company and dbo.Company_Address. This was discovered by the DSV wizard. The PK and FK columns both show as int(4) in the DSV, as they should... Next, I created a single dimension using the dbo.Company table. Interestingly, the Dimension wizard did NOT pick up on the FK relation to dbo.Company_Address, though it picked up on two other relations, and added tables and hierarchies. I then added the dbo.Company_Address table to the Dimension (without adding any attributes or attribute relations), and processed the project. This processed OK. Next, I Added the PK (Company_Address_RECID) of the dbo.Company_Address table to the dimension attributes, created an attribute relation for that attribute under the Company attribute, and reprocessed the project. I got the above error again...

The database I am trying to process comes from a third-party .NET application, which means that I can't easily change the underlying DB schema. For reference, the source DB is running under MSSQL 2000 (sp4).

I've also done numerous reports against this database (most using these tables and this pretty basic relation), so I don't think there is an issue with the underlying DB, but you never know.

... Anyone have any ideas?

It is hard to say what is going on.

The error indicates specifically problem with DSV. Not with database , not with the way you define your PK FK relationships in the SQL Server database. It is DVS.

I have seen such errors in the past. And in every case I would first look and will think everything is okay. But eventually this got to be DSV.

Try to simplify your case even more. Have only two tables, create only 2 attributes based on each table.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Edward,

Thanks for answering.

> The error indicates specifically problem with DSV.

That's the impression I was left with, glad to be able to start narrowing issues...

I went ahead and tried narrowing down possibilities. Here are the results:

Changed DSV to contain ONLY the tables for the dimension (Company, Company_Address, Company_Type, Company_Status). Wizard picked up on relations from all but Company_Address.
|||

Feel free to contact me by removing 'noreply.online.' from my Display E-mail.

I will try take a look at your problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Just updating this posting with the off line discussion so far. Edward has been unable to followup on this issue, and I really do need an answer...

--Jason

---

> --Original Message--
> From: Jpiterak
> Sent: Friday, June 09, 2006 9:29 AM
> To: Edward Melomed
> Subject: Error: 'table that is required for a join cannot be reached'
>
> Hello Edward,
> Again, thanks for taking the time to help with this...
>
> I'm attaching the contents of the .dsv and .dim xml to this email... Let
> me know if there is anything else I can send to help track this down (do
> you need the full project? -- I'd just need to cleanse any login
> info...).
>
> Thanks again,
> --Jason
Edward Melomed wrote:
> Are you having a case when a single company can have several addresses?
>
> One way to deal with this problem is to define single "primary" company
> address. So company and address have one-to-one relationship.
> Create a named query in DSV joining Company and Company address tables.
> Make sure you resolve ambiguity with addresses.
>
> If you absolutely need to maintain several addresses for company, you
> can create separate many-to-many dimension for Company address.
>
> Take a look at the AdventureWorks sample project shipped with the AS
> 2005. It has example of many-to-many dimensions.
>
>
> Edward.
> Analysis Services team. Microsoft Corp.
>


Hi Edward,
Thanks again for getting back to me...

The thing is, the relation between Company and Company_Address isn't
many to many, it's one to many (a company has several addresses, each of
which belong to one and only one company...)
All my other one to many relations seem to work fine, this one is just
plain stubbornly refusing to work.

Is there something in the xml schema files that presents the
co->co_addr relationship as something other than one to many, perhaps?

Anyway, thanks again for taking the time.

Take care,
--Jason

|||

Let me try to take another stab at it and explain it in a different way:

In the relational database you have one-to-many relationship between your company address and your company.

But the way you've defined your dimension, is you've marked your company as a key of the dimension and company address as a related attribute. This is just opposite to how you want to define your dimension.

The key attribute should be most granular attribute in your dimension and all other attributes are less granular.

So many examples... Take a look at the AdventureWorks database. You have Customer dimension there.

Any dimension you look, you see the relationships are one-to-many between attributes and the key attribute in the dimension.

Makes sense?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.