Showing posts with label step. Show all posts
Showing posts with label step. Show all posts

Wednesday, March 21, 2012

Deployment Failed

Hi Team,

Happy New Year to you all,

When i try to deploy my project (SSAS Step by Step) with a calculated Member, the deployment fails.

I actually get the following error.

Error 1 The 'Database' with 'ID' = 'SSAS Step by Step ' doesn't exist in the collection. 0 0

When I try to change the transactional deployment property to true so as for me to overwrite the existing database i get the following error;

Error 1 Members belong to different hierarchies in the function. 0 0

Could you please advise me on how to go about this.

Any help will highly appreciated.

Regards,

Ronald

Please provide the expression of the calculated member. From the error message it seems like you are trying to build a set from the members in different hierarchies. Might be you only wanted to build a tuple instead of set - but it is hard to tell without actual expression.

Posted by pre at 12:43 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Deployment

I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK

This is your problem:

<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.

|||

Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Unable to connect to the remote server (Microsoft.ReportingServices.Designer)

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK|||

I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:

TITLE: Surface Area Configuration

Unable to connect to the remote server (System)


ADDITIONAL INFORMATION:

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||

Hey Roger,

Did you ever find a solution or cause to your problem? I am now experiencing the same problem.

I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:

"Unable to connect to remote server (System)"

"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"

Thanks!

Dan

Posted by pre at 12:28 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Deployment

I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK

This is your problem:

<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.

|||

Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Unable to connect to the remote server (Microsoft.ReportingServices.Designer)

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK

|||

I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:

TITLE: Surface Area Configuration

Unable to connect to the remote server (System)


ADDITIONAL INFORMATION:

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK

|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||

Hey Roger,

Did you ever find a solution or cause to your problem? I am now experiencing the same problem.

I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:

"Unable to connect to remote server (System)"

"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"

Thanks!

Dan

Posted by pre at 12:28 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Deployment

I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK

This is your problem:

<li>Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>

Looks like the account that SSRS is running under doesn't have permissions on \ReportServer. Make sure the account in question can read from the folder.

|||

Thanks, but it still doesn't work even with admin permissions. I restarted IIS and RS and that reduced the error to the following:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.


ADDITIONAL INFORMATION:

Unable to connect to the remote server (Microsoft.ReportingServices.Designer)

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK|||

I went to the Surface Area Configuration for Features and Reporting Services is enabled. But when I select "Windows Integrated Security" I get this error:

TITLE: Surface Area Configuration

Unable to connect to the remote server (System)


ADDITIONAL INFORMATION:

No connection could be made because the target machine actively refused it (System)


BUTTONS:

OK|||I should mention that I have SQL Server 2005 installed on my machine and am trying to deploy to it. I'm not working over a net.|||

Hey Roger,

Did you ever find a solution or cause to your problem? I am now experiencing the same problem.

I am not trying to deploy a report, rather install SQL 2005 SP1, which fails stating I could not authenticate to all instances. Then, when poking around in the Surface Area Configuration Manager, clicking on SQL Server Reporting Services - Windows Integrated Security, I get the same error you get:

"Unable to connect to remote server (System)"

"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)"

Thanks!

Dan

sql
Posted by pre at 12:27 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Saturday, February 25, 2012

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié X
System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) X
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) X
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
Thanks
Hi
"malek_che" wrote:

> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,( Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,i nter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié X
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHa ndle hrHandle<c/> RetCode
> retcode) X System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) X
> System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) X
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) X System... The
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John
Posted by pre at 11:32 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR &#
91;IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuv
able et
nom de pilote non spécifié _
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) _
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) _
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection
owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
ThanksHi
"malek_che" wrote:

> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Erro
r:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR
[IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,i
nterdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,i
nterdata,inter,,Execute
d
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Erro
r:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR
[IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données intro
uvable et
> nom de pilote non spécifié _
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCod
e
> retcode) _ System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) _
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOption
s
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) _
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) _ System... T
he
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John
Posted by pre at 11:31 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Deployement of integration services project

I am getting the following error when I test a Job in SQL Server 2005 :
Date,Source,Severity,Step ID,Server,Job Name,Step
Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
Emailed,Operator Net sent,Operator Paged,Retries Attempted
05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
package execution fa... The step failed.,00:00:02,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,(Job
outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
_secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
nom de pilote non spécifié Ã
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
environmentHandle) Ã
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
DbConnection owningObject) Ã
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
package execution fa... The step failed.,00:00:05,0,0,,,,0
Why am I getting this, and how do I resolve it?
ThanksHi
"malek_che" wrote:
> I am getting the following error when I test a Job in SQL Server 2005 :
> Date,Source,Severity,Step ID,Server,Job Name,Step
> Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator
> Emailed,Operator Net sent,Operator Paged,Retries Attempted
> 05/07/2007 15:06:38,interdata,Error,0,KHEIREDDINE,interdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:02,0,0,,,,0
> 05/07/2007 15:06:38,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:06:38 Error:
> 2007-05-07 15:06:39.90 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
> package execution fa... The step failed.,00:00:02,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,0,KHEIREDDINE,interdata,(Job
> outcome),,The job failed. The Job was invoked by User KHEIREDDINE\Kheiro.
> The last step to run was step 1 (inter).,00:00:05,0,0,,,,0
> 05/07/2007 15:04:58,interdata,Error,1,KHEIREDDINE,interdata,inter,,Executed
> as user: KHEIREDDINE\SYSTEM. ...9.00.3042.00 for 32-bit Copyright (C)
> Microsoft Corp 1984-2005. All rights reserved. Started: 15:05:00 Error:
> 2007-05-07 15:05:03.32 Code: 0xC0047062 Source: Autres Tbles Excel
> _secteur [752] Description: System.Data.Odbc.OdbcException: ERROR [IM002]
> [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et
> nom de pilote non spécifié Ã
> System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle<c/> RetCode
> retcode) Ã System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
> connection<c/> OdbcConnectionString constr<c/> OdbcEnvironmentHandle
> environmentHandle) Ã
> System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions
> options<c/> Object poolGroupProviderInfo<c/> DbConnectionPool pool<c/>
> DbConnection owningObject) Ã
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection
> owningConnection<c/> DbConnectionPoolGroup poolGroup) Ã System... The
> package execution fa... The step failed.,00:00:05,0,0,,,,0
> Why am I getting this, and how do I resolve it?
>
> Thanks
It seems that the datasources have not been set up correctly, you could open
the installed package in BI studio and check the connections.
John
Posted by pre at 11:31 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Friday, February 24, 2012

deploy Service pack remotely

How can we deploy SP3a remotely on all our SQL servers ? Is this doable ? Is
there step by step instructions on how to do so and also verify remotely
once completed that it was successful
ThanksI suppose SMS could do this.
You might also try software policies for the Operating System... For
Software policy, that would be doc'c with the operating system and not SQL..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>|||By the way, you might also try a login script which runs the setup...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>
Posted by pre at 4:54 AM 0 comments
Labels: , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)