Establishing a remote connection..! (Again)

Hi,

I am trying to connect via the Management Studio Express. I share a LAN with the server. In Netowrk connections I can see the server and I can even access the "Shared" folders. However,when I try to connect I get an error that says the error may be caused by the server not allowing remote connections. I have already done the following:

With the Surface Area Configuration facility I have set the server to allow remote connections I have selected TCP/IP as the preferred mode of connection. I have selected Windows authentification as mode of authorisation

What else can I do?

Please help.

Derekprinsloo

Verify that there is no local firewall blocking.

These resources should help you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Errors while Deploying Analysis services projects in server

Hi,

I am using Sql server Business Intelligence Development Studio 2005 and SQL server Management studio.

I created a Analysis services project in the BI Dev Studio, and set the correct server attributes in the project properties -> deployment tab.

I have created a data source , then a datasource view and then cube and dimensions.

1) When I tried deploying with the database name as 'xyz'. (again set in the project properties -> database ,target attribute),

and the database 'xyz' is previously created and thus present in the Analysis server 2005. I get the following error:

"The database , 'xyz', contains an ImpersonationMode that is reserved for server administrators."

---

2.) When i tried deploying with the database name as 'abc'. (again set in the project properties -> database ,target attribute),

but NOTE now there is no analysis server database with the name 'abc' already existing in the analysis server. now I get the following error:

"Either the 'myUserName' user does not have permission to create a new object in 'myServerName', or the object does not exist."

I checked the Sql server management studio and under the 'xyz' analysis database in the 'Roles' Folder my username is a member of the Administrators who have full priliviges.

Please do tell me as to where I am going wrong.

Thanks and regards

Vijay R

Hi Vijay,

I had the same problem as you and found the following on http://www.eggheadcafe.com/forumarchives/SQLServerdatamining/Jun2005/post23396286.asp. Changing the impersonation mode to the service account sorted things out straight away for me, hopefully it'll do the same for you.

"The impersonation mode tells Anaylsis Server what credentials to use when connecting to the database specified in the datasource object. When you create the datasource using the Data Source Wizard, there's an "Impersonation Information" page where you can set this information. If the data source is used for processing (i.e. you are training mining structures/models from that data source), you are not allowed to set the ImpersonationMode to "Use the credentials of the current user" due to security considerations - you must either use the service account or use a specific username/password. You can change the impersonation mode by opening the data source in BI Dev Studio and selecting one of the allowed options above on the "Impersonation Information" tab."

Errors during import and export

I am unable to import anything from one sql 2000 database to another using the 2005 Management Studio - When I try I get an error similar to this -

Could not set up data flow connections.

The connection type "OLEDB" specified for connection manager {ccccc}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(SQL Server Import and Export Wizard)

Thanks Richard

I saw this solution on another MSDN forum which worked for me:

"It is a SSIS issue.

Open SQL Server Configuration Manager. Right click on SQL Server

Integration Services. Select properties and in the Log On tab change

the built-in account."

I'm only a newbie to this so I don't know what the implications of this change are, other than I was able to import my Access Db.

Errors during import and export

I am unable to import anything from one sql 2000 database to another using the 2005 Management Studio - When I try I get an error similar to this -

Could not set up data flow connections.

The connection type "OLEDB" specified for connection manager {ccccc}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(SQL Server Import and Export Wizard)

Thanks Richard

I saw this solution on another MSDN forum which worked for me:

"It is a SSIS issue. Open SQL Server Configuration Manager. Right click on SQL Server Integration Services. Select properties and in the Log On tab change the built-in account."

I'm only a newbie to this so I don't know what the implications of this change are, other than I was able to import my Access Db.

error:25 - connection string is not valid

I have installed SQL Server 2005 Developer edition. When I open SQL Server Management Studio, and try to connect to the database engine, I enter these credentials:

Server name: LT2000\MSSQLSERVER
Login: sa
Password: my password

When I try to connect I receive the following error:
An error has occured while trying to establish a connection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: sql network interfaces, error:25 - connection string is not valid)(Microsoft SQL Server, Error:87)

What can I do?

Is that an error message you are seeing via a ASP.NET page trying to connect?|||

Peter Smith:

I have installed SQL Server 2005 Developer edition. When I open SQL Server Management Studio, and try to connect to the database engine, I enter these credentials:

What can I do?

I don't understand what you mean by connecting to the database engine because I have not had the need for that in 8years plus using SQL Server, but your error means you are trying to connect with only named pipes you need to use both named pipes and TCP/IP. Then enable remote connection that is covered by Microsoft below. Hope this helps.

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

|||

The surface area configuration tool used to configure SQL Serve 2005 check the doc below remote connection.

http://msdn2.microsoft.com/en-us/library/ms178763.aspx

|||

Actually the error has nothing to do with pipes. If you look in the error message you find the message "error:25 - connection string is not valid", that is the error. If you are sure those are that is your valid credential you should use a connection string just like this one: "Data Source=LT2000\MSSQLSERVER;Initial Catalog=Northwind;User ID=sa;Password=mypassword"; Initial catalog is of course the name of your database. If that doesn't work, then use a data source wizard and enter your credentials, then test the connection and see if it works. If it doesn't you probably have wrong credentials. You can try also using the Windows Authentication('cause you set your sql server to user mixed authentication mode), in that way your connection string will be: "Data Source=LT2000\MSSQLSERVER;Initial Catalog=Northwind;Integrated Security=true".

Tell us if that works for you.

|||

Hi,

When I use MS SQL Management Studio and I want to connect, I get to see a dropdown...in this dropdown I can select "database engine".
I then fill in the type of authentication (sql server in this case), and I can log on.

I dont have the problem anymore, but that might be that out of frustration I just reinstalled SQL Server...it works fine now :)

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.