Estimated Execution Plan Fails, XML Error?

Good afternoon, all. Whenever I try to use Query | Display Estimated
Execution Plan in SQL Studio on any non-trivial query, I get this unhelpful
message:
Error processing execution plan results. The error message is:
There is an error in XML document (1, 501).
There is an unclosed literal string. Line 1, position 501.
The only suggestion I've heard of is to instal SQL SPs, but that didn't
help. This is SQL 2K5 running on Win2K3. I don't believe there's any
strangeness like odd characters in instance names, and all language settings
are default. I've seen this before on another server, but Google has nothing.
Any ideas? Thanks!
I think I heard that the XML used for this can not handle some unusual
object names, but at best that is a long shot.
Roy Harvey
Beacon Falls, CT
On Mon, 6 Aug 2007 13:32:02 -0700, JonOfAllTrades
<JonOfAllTrades@.discussions.microsoft.com> wrote:

> Good afternoon, all. Whenever I try to use Query | Display Estimated
>Execution Plan in SQL Studio on any non-trivial query, I get this unhelpful
>message:
>Error processing execution plan results. The error message is:
>There is an error in XML document (1, 501).
>There is an unclosed literal string. Line 1, position 501.
> The only suggestion I've heard of is to instal SQL SPs, but that didn't
>help. This is SQL 2K5 running on Win2K3. I don't believe there's any
>strangeness like odd characters in instance names, and all language settings
>are default. I've seen this before on another server, but Google has nothing.
> Any ideas? Thanks!

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

Establish connection to the server

Hi,

I have a problem editing my SQL databases in Visual Studio 2005, i have searched the web for answers, but those were not clear enough to me, somthing about changing my settings for SQL server, but i didn't follow it all to well, the current error mesage I get when i click in the Server Explorer on my data connections is:

An error has occured while establishing 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I do have followed some tips, bit end to this error mesage every time. Bevore i followed that tips the error said:

(provider: TCP/IP, error ... i dont remember anymore...)

I have tried to delete SQL and Visual Studio but it didn't help, and reinstall it.

Please can somebody help me, i am realy fFrustrated about the fact i cant fix it!By default SQL Server Express does not have remote connections enabled. You can do this using the following instructions: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx|||Yes, i have seen these instructions before, and i apply them again. But again without any succes. the error i now get is:

Connecting to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

I downloaded the file, open it. It recognizes the Named Instance as SQLExpress but then it said:

Name: Microsoft SQL Server 2005 Express Edition (SQLEXPRESS)

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

And the things i have in my Add or Remove Programs are:

Microsoft SQL Server 2005
Microsoft SQL Server 2005 Mobile
Microsoft SQL Server Native Client
Microsoft SQL Server Settup supporting files
Microsoft SQL Server VSS writer

What must i do?

|||

I encountered the same error message while trying to create a data connection from Visual Studio 2005 using the Server Explorer.

This is what I did:

# 1. Started Visual Studio 2005

# 2. Opened the Server Explorer (View | Server Explorer)

# 3. Right-clicked the Data Connections node

# 4. Selected Create New SQL Server Database... from the context menu

# 5. Selected my computer from the Server Name dropdown list

# 6. Selected authentication method (Use Windows Authentication)

# 7. Typed a name in the New Database Name field

# 8. Hit the OK button

That's when I received the following error message

An error has occured while establishing 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: Named Pipes Provider, error:40 – Could not open a connection to SQL Server)

It made absolutely no sense. I wasn't trying to connect to a remote computer. I was simply trying to connect to the SQL Server 2005 Express Edition which was installed on my local computer during the Visual Studio 2005 installation.

After numerous attempts on several computers, I finally realized what I was doing wrong. By adding the database instance name to the server name (# 5), it actually worked. Instead of selecting <server name> from the dropdown list, I entered <server name>\SQLExpress manually. That was obviously the problem.

SQL Server 2005 Express Edition is obviously installed as a named instance, since one has to provide the instance name in addition to the server name (even when there is only one instance running on the requested server).

|||

Hi

Have to tried

sp_configure 'remote admin connections',1

go

Reconfigure

go

Establish connection to the server

Hi,

I have a problem editing my SQL databases in Visual Studio 2005, i have searched the web for answers, but those were not clear enough to me, somthing about changing my settings for SQL server, but i didn't follow it all to well, the current error mesage I get when i click in the Server Explorer on my data connections is:

An error has occured while establishing 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I do have followed some tips, bit end to this error mesage every time. Bevore i followed that tips the error said:

(provider: TCP/IP, error ... i dont remember anymore...)

I have tried to delete SQL and Visual Studio but it didn't help, and reinstall it.

Please can somebody help me, i am realy fFrustrated about the fact i cant fix it!By default SQL Server Express does not have remote connections enabled. You can do this using the following instructions: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx|||Yes, i have seen these instructions before, and i apply them again. But again without any succes. the error i now get is:

Connecting to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

I downloaded the file, open it. It recognizes the Named Instance as SQLExpress but then it said:

Name: Microsoft SQL Server 2005 Express Edition (SQLEXPRESS)

Allowed Action: Maintain (Action is only available from Add or Remove Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs

And the things i have in my Add or Remove Programs are:

Microsoft SQL Server 2005
Microsoft SQL Server 2005 Mobile
Microsoft SQL Server Native Client
Microsoft SQL Server Settup supporting files
Microsoft SQL Server VSS writer

What must i do?

|||

I encountered the same error message while trying to create a data connection from Visual Studio 2005 using the Server Explorer.

This is what I did:

# 1. Started Visual Studio 2005

# 2. Opened the Server Explorer (View | Server Explorer)

# 3. Right-clicked the Data Connections node

# 4. Selected Create New SQL Server Database... from the context menu

# 5. Selected my computer from the Server Name dropdown list

# 6. Selected authentication method (Use Windows Authentication)

# 7. Typed a name in the New Database Name field

# 8. Hit the OK button

That's when I received the following error message

An error has occured while establishing 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: Named Pipes Provider, error:40 – Could not open a connection to SQL Server)

It made absolutely no sense. I wasn't trying to connect to a remote computer. I was simply trying to connect to the SQL Server 2005 Express Edition which was installed on my local computer during the Visual Studio 2005 installation.

After numerous attempts on several computers, I finally realized what I was doing wrong. By adding the database instance name to the server name (# 5), it actually worked. Instead of selecting <server name> from the dropdown list, I entered <server name>\SQLExpress manually. That was obviously the problem.

SQL Server 2005 Express Edition is obviously installed as a named instance, since one has to provide the instance name in addition to the server name (even when there is only one instance running on the requested server).

|||

Hi

Have to tried

sp_configure 'remote admin connections',1

go

Reconfigure

go

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 when trying to open the report designer

I am trying to open a report solution using the report designer (Visual
Studio .NET 2003) and I am getting several errors, here is the first one:
"Package 'ReportDesignerPackage' has failed to load properly ( GUID = {11B8903-8FFD-4Dfc-87CEF6A82D77AF68} ). Please contact package vendor for
assistance. Would you like to disable loading this package in the future?
You may use 'devenv/resetskippkgs' to re-enable package loading. Application
restart is recommended, due to possible environment corruption."
This error is followed by several more "Package failed to load properly"
ones before the report designer finally opens (but it will not load my
reporting services project folders and files).
Other people can open this solution without a problem. Is there some
security setting that is causing me to get these errors' Help please.
--
LaurieTHave a look to these articles
http://support.microsoft.com/?id=823245
http://support.microsoft.com/?id=830968
--
Bien cordialement
Med Bouchenafa
"LaurieT" <LaurieT@.discussions.microsoft.com> a écrit dans le message de
news: 05A1B2AE-4F32-4A80-AE7A-C57E4ED5E4D7@.microsoft.com...
>I am trying to open a report solution using the report designer (Visual
> Studio .NET 2003) and I am getting several errors, here is the first one:
> "Package 'ReportDesignerPackage' has failed to load properly ( GUID => {11B8903-8FFD-4Dfc-87CEF6A82D77AF68} ). Please contact package vendor for
> assistance. Would you like to disable loading this package in the future?
> You may use 'devenv/resetskippkgs' to re-enable package loading.
> Application
> restart is recommended, due to possible environment corruption."
> This error is followed by several more "Package failed to load properly"
> ones before the report designer finally opens (but it will not load my
> reporting services project folders and files).
> Other people can open this solution without a problem. Is there some
> security setting that is causing me to get these errors' Help please.
> --
> LaurieT

Errors in High Level Relational and OLAP Storage Engine

Hi Edward,

I have tried to go to the Partition tab of BI Development Studio. When i click the partition tab of the Development Studio, it discards an error that " An error prevented the view from loading".

Could you please outline me the steps of how to go about this.

I am really stack.

Ronald

Please, could someone bail me out on this.

Ronald

|||

Looks to me something gone wrong with your project. It is also possbile BI Dev Studio installation got corrupted.

I would suggest:

First, try re-create your cube. See if you can create more partitions for you cube and BI Dev Studio allows you to add new partitions.

Second. If you still getting an error trying to navigate to the partitions tab, try re-installing SQL Server on your machine.

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

|||I also found this error last week. My data source is ORACLE database. This raised when I used "OracleClient Data Provider" for provider in Data Source. When I changed the provider to "Native OLEDB\Oracle Provider for OLE DB", this problem was solved.

Hopefully, this post can help you.

Ashari Imamuddin

Errors in High Level Relational and OLAP Storage Engine

Hi Edward,

I have tried to go to the Partition tab of BI Development Studio. When i click the partition tab of the Development Studio, it discards an error that " An error prevented the view from loading".

Could you please outline me the steps of how to go about this.

I am really stack.

Ronald

Please, could someone bail me out on this.

Ronald

|||

Looks to me something gone wrong with your project. It is also possbile BI Dev Studio installation got corrupted.

I would suggest:

First, try re-create your cube. See if you can create more partitions for you cube and BI Dev Studio allows you to add new partitions.

Second. If you still getting an error trying to navigate to the partitions tab, try re-installing SQL Server on your machine.

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

|||I also found this error last week. My data source is ORACLE database. This raised when I used "OracleClient Data Provider" for provider in Data Source. When I changed the provider to "Native OLEDB\Oracle Provider for OLE DB", this problem was solved.

Hopefully, this post can help you.

Ashari Imamuddin

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.

Errors ASP.NET to SQL Server 2005 Express Edition

If I try to use mobile web applications created with Visual Studio .NET 7.1 in conjunction with SQL Server 2005 Express Edition on my locale computer I get a lot of errors.

Examples:

System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Instance failure.

Are there known issues related to ASP.NET Mobile Controls, SQL Server 2005 Express Edition, .NET Framework 1.1 or 2.0?

Thank you.Hi,

Is the SQL Express on a different machine? If so take a look at the following blog to troubleshoot issues with a remote connection:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Regards,
Vikram|||Thank you for Your answer, Vikram.

But I have Visual Web Developer and SQL Server 2005 Express Edition on the same machine.|||Hi,

Have you been able to connect to the SQL Express Database using the Express Manager? What is the ConnectionString you are using ?

The default instance of SQL Server Express would need to be referenced as
.\SQLExpress or MachineName\SQLExpress

Regards,
Vikram|||Hallo Vikram,

yes, it is possible to connect with XM and the connection string fits.

From Visual Web Developer Beta 2 to SQL Server 2005 Express Edition I have the following error log with my mobile application:

2005-07-25 14:38:59.90 Logon Error: 17830, Severity: 20, State: 2.
2005-07-25 14:38:59.90 Logon A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 7 ms, enqueued 2 ms, network writes 1 ms, network reads 4 ms, establishing SSL 5 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]
2005-07-25 14:38:59.92 Logon Error: 17830, Severity: 20, State: 2.
2005-07-25 14:38:59.92 Logon A network error occurred while establishing a connection; the connection has been closed. This may have been caused by client or server login timeout expiration. Time spent during login: total 9 ms, enqueued 1 ms, network writes 1 ms, network reads 8 ms, establishing SSL 5 ms, negotiating SSPI 0 ms, validating login 0 ms. [CLIENT: <local machine>]

I do not know why but the connection works with other applications.

I think I have to create a user for the mobile application with the right permissions.

Thank you.

error:no report server found on the specified machine while setting up reporting services config

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

Hello Nirupa,

Can you make sure you have IIS installed and running? If so, make sure you have /Reports and /ReportServer showing in IIS management.

Then, check to see if you have the following three folders in the C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services directory (where x is the component number for RS). LogFiles, ReportManager, & ReportServer

Hope this helps.

Jarret

|||

Hi Jarret,

Thanks for your suggestions first,

yes I installed IIS and it is running,

and

I couldn't find any folder C:\Program Files\Microsoft SQL Server\MSSQL.1\ Reporting Services directory

...LogFiles, ReportManager, & ReportServer

I could see only path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ Backup

'' \Bin

'' \Install

'' \LOG

'' \repldata

'' \TemplateData

can you suggest me what might had happen.... or what shall be done

Thanks

Nirupa

|||

Do you have a MSSQL.2, MSSQL.3, or MSSQL.4 folder? If so, look in each for the 3 folders I listed in my last post. If you don't have these folders, you probably should reinstall Reporting Services.

Jarret

|||

Hello Jarret

I do not have the folders that you have mentioned....As you have mentioned will probably need reinstallation

Thank you

Nirupa

|||

That is correct, if you don't have these folders, you don't have RS installed. Try to re-install and see if that fixes your problem.

Jarret

|||

Hi Jarret,

Thanks for your suggestions.As you mentioned, I reinstalled SQL reporting services and got the above mention folders(MSSQL.1,MSSQL.2,MSSQL.3) and also I successfully configured reporting services.While trying to deploy my reporting services application in to localhost , I got the below mentioned error : " The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) "

can you please sugguest me work around for this issue.

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: use trust connect failure -urgent

i use visual studio.net 2003 version and when a progamme run , it told me

do not have trust connect .what is wrong ?how can I do to solute it?

We usually define trusted connection in web.congif like

<appSettings>

<addkey="connectionstring"value="server=localhost;Trusted_Connection=true;database=databaseNamw"/>

</appSettings>

In database users --> Add ServerName\ASPNET account.

That will create trusted connection for the application.

|||

i did as you told me.but it occurs new error as follows:

" database" server of application error.

abnormity particular information: system.data.sqlclient.sqlexception"BUSA_QFDKDIEDKDJ" landing fail.

BUSA_QFDKDIEDKDJ is my server name.

|||

Hi,

I have made little web application to show you how to add user in DB with trusted connection. The DB backup is in the TestDB folder called DB backup. Make Virtual directory and browse it to TestDB folder and Restore backup in MyDB (Create it). Here is link

http://www.riseofkingdoms.com/TestDB.rar

Hope it will work. Change the server name in the string like

<appSettings>

<addkey="connectionstring"value="server=BUSA_QFDKDIEDKDJ;Trusted_Connection=true;database=MyDB"/>

</appSettings>

|||

Hi:

I change the server name ,but it doesn't work. and i am a new proqrammer,and dosen't know much, can you say easily.

|||

i use Query Decomposition to land with trusted connection,and it success.but why

it can't work in the asp.net

|||it occurs the same error.|||

Hi,

You might try checking your SQL Server - make sure you select 'Mixed' security which allows SQL Server login & password to substitute for a trusted connection.

Good luck!

|||

I change the security for 'mixed' security ,but it

occurs error: trusted connection failed.and mayby

sql server's error,because when i use Query Decomposition to land with sa and no password

,bbut it failed .what is wrong?could anyone help?

|||what's wrong ?could anyone help?|||

This problem may be due to the way you have defined your Shared Datasource. Have you stored the login Credentials or used the prompt for login option?

If you used the latter you might want to change to the store credentials option. Hope this helps

|||That's all right.Aftar I select 'Mixed' security ,I didn't restart the computer.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipelin

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pip

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

Error: The task with the name "Data Flow Task" and the creation name "DTS.Pip

Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

Not exactly sure why this is happening but as a first stab can you do a search on your machine and in your registry for "DTSPipeline.DLL". it should be in "%PROGRAMFILES%\Microsoft SQL Server\90\DTS\Binn\DTSPipeline.dll"

-Jamie

|||

In the properties of the file DTSPipeline.dll for the Administrator account that I am using I have all the permissions checked, except for Special Permissions. For the SQLServer2005DTSUser$MyComputerName the permissions checked are 1.Read & Execute and 2.Read.

|||

And the registry...?

-Jamie

|||

I am not completely sure of where I am supposed to look for in the registry. Possible values you were asking me about:

\HKEY_CLASSES_ROOT\DTS.Pipeline -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_CLASSES_ROOT\DTS.Pipeline.1 -> Permissions: Administrator- 1.Full Control 2.Read

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS -> Permissions: Administrator- 1.Full Control 2.Read SQLServer2005UserType - 1.Read

|||

run regedit

press CTRL-F

search for DTSPipeline.dll. You should have an entry in HKEY_CLASSES_ROOT\CLSID

-Jamie

|||

Jaime, can you please let me know if the advise you were given was useful, or if you have solved the problems yourself - I'm experiencing exactly the same issues and I've checked all items that have been suggested and everything appears to be as it should be, but I'm still getting the error messages.

Please get back to me a.s.a.p.

David

|||Hi all, I have the same problem and no sulution for it......hmmm|||

I too have seen this problem. I was using a trial version of Visual Studio with a trial version of SQL Server Enterprise Edition. When I converted to Visual Studio Professional Edition and SQL Server Developer Edition, I found this problem. However, the problem disappeared after I installed the SQL Server 2005 SP1. Try it. It might work for you too.

|||

Sorry for not answering before. At that time I wasn't able to figure out what was the source of the problem, so I had to reinstall the OS again.

|||I had this error until I installed Sql Server Sp1.|||I am using the trial version of SSIS and faced the same problem. Just installed SP1 for SQL Server and the problem dissappeared.

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