PDF Export Prompts for Authentication

I am having a weird problem with just one report in production. When
exporting to PDF format only, the browser prompts for user authentication.
No matter what you type in the window (even admin for server) it just keeps
popping up. When you click cancel you see the following error.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
The log file shows the following
w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query
execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
System.StackOverflowException exception:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.StackOverflowException: Exception of type
System.StackOverflowException was thrown.
w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker process
Other reports in production export to PDF without a problem, just this one
report is causing issues.
Any idea what might be causing this issue? The report exports to PDF fine
in development for this report. Has anyone else seen this issue before?Does this report render correctly in other formats like HTML? Can you help
me understand this error:
Query execution failed for data set 'dsChangesInLargeLoss'. -->
System.Data.SqlClient.SqlException: The conversion of a char data type to a
datetime data type resulted in an out-of-range datetime value.
If it isn't an obvious place in your report that's doing this and leading to
us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
can investigate?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>I am having a weird problem with just one report in production. When
> exporting to PDF format only, the browser prompts for user authentication.
> No matter what you type in the window (even admin for server) it just
> keeps
> popping up. When you click cancel you see the following error.
> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> credentials.
> Internet Information Services (IIS)
> The log file shows the following
>
> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> has
> occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> An
> error has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Query
> execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> System.StackOverflowException exception:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.StackOverflowException: Exception of type
> System.StackOverflowException was thrown.
> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> process
> Other reports in production export to PDF without a problem, just this one
> report is causing issues.
> Any idea what might be causing this issue? The report exports to PDF fine
> in development for this report. Has anyone else seen this issue before?
>|||It would be really creepy if this renders in HTML but not in PDF (makes no
sense)
I am looking forward getting the rdl ;-)
Jens Süßmeyer.
"Donovan Smith [MSFT]" <donovans@.online.microsoft.com> schrieb im
Newsbeitrag news:emN7AkRQFHA.3140@.tk2msftngp13.phx.gbl...
> Does this report render correctly in other formats like HTML? Can you
> help me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to
> a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading
> to us blowing up, can you email me a copy of your .rdl and .rdl.data file
> so I can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>>I am having a weird problem with just one report in production. When
>> exporting to PDF format only, the browser prompts for user
>> authentication.
>> No matter what you type in the window (even admin for server) it just
>> keeps
>> popping up. When you click cancel you see the following error.
>> HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> credentials.
>> Internet Information Services (IIS)
>> The log file shows the following
>>
>> w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown., ;
>> Info:
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> -- End of inner exception stack trace --
>> at
>> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> report, NameValueCollection reportServerParameters, NameValueCollection
>> deviceInfo, NameValueCollection clientCapabilities,
>> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> CreateAndRegisterStream createAndRegisterStream)
>> at
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> createChunkCallback, RenderingContext rc, GetResource
>> getResourceCallback)
>> -- End of inner exception stack trace --
>> w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> error
>> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> has
>> occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> An
>> error has occurred during report processing. -->
>> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> Query
>> execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> System.StackOverflowException exception:
>> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. -->
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> Exception of type
>> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
>> thrown. --> System.StackOverflowException: Exception of type
>> System.StackOverflowException was thrown.
>> w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> process
>> Other reports in production export to PDF without a problem, just this
>> one
>> report is causing issues.
>> Any idea what might be causing this issue? The report exports to PDF
>> fine
>> in development for this report. Has anyone else seen this issue before?
>|||We tested the report on another server and duplicated the problem. Once we
upgraded to SP1, the problem went away.
"Donovan Smith [MSFT]" wrote:
> Does this report render correctly in other formats like HTML? Can you help
> me understand this error:
> Query execution failed for data set 'dsChangesInLargeLoss'. -->
> System.Data.SqlClient.SqlException: The conversion of a char data type to a
> datetime data type resulted in an out-of-range datetime value.
> If it isn't an obvious place in your report that's doing this and leading to
> us blowing up, can you email me a copy of your .rdl and .rdl.data file so I
> can investigate?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
> >I am having a weird problem with just one report in production. When
> > exporting to PDF format only, the browser prompts for user authentication.
> > No matter what you type in the window (even admin for server) it just
> > keeps
> > popping up. When you click cancel you see the following error.
> >
> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
> > credentials.
> > Internet Information Services (IIS)
> >
> > The log file shows the following
> >
> >
> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown., ;
> > Info:
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> > -- End of inner exception stack trace --
> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> > has
> > occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> > An
> > error has occurred during report processing. -->
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> > Query
> > execution failed for data set 'dsChangesInLargeLoss'. -->
> > System.Data.SqlClient.SqlException: The conversion of a char data type to
> > a
> > datetime data type resulted in an out-of-range datetime value.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
> > System.StackOverflowException exception:
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.StackOverflowException: Exception of type
> > System.StackOverflowException was thrown.
> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
> > process
> >
> > Other reports in production export to PDF without a problem, just this one
> > report is causing issues.
> >
> > Any idea what might be causing this issue? The report exports to PDF fine
> > in development for this report. Has anyone else seen this issue before?
> >
>
>|||Well, that was an easier answer than I expected. Good to know it's working.
:)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"spindlej" <spindlej@.discussions.microsoft.com> wrote in message
news:6FFDE7FB-5525-469A-AEC4-4189555A94E8@.microsoft.com...
> We tested the report on another server and duplicated the problem. Once
> we
> upgraded to SP1, the problem went away.
> "Donovan Smith [MSFT]" wrote:
>> Does this report render correctly in other formats like HTML? Can you
>> help
>> me understand this error:
>> Query execution failed for data set 'dsChangesInLargeLoss'. -->
>> System.Data.SqlClient.SqlException: The conversion of a char data type to
>> a
>> datetime data type resulted in an out-of-range datetime value.
>> If it isn't an obvious place in your report that's doing this and leading
>> to
>> us blowing up, can you email me a copy of your .rdl and .rdl.data file so
>> I
>> can investigate?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "spindlej" <spindlej@.discussions.microsoft.com> wrote in message
>> news:87D82688-AEB0-4721-A115-8D160537514B@.microsoft.com...
>> >I am having a weird problem with just one report in production. When
>> > exporting to PDF format only, the browser prompts for user
>> > authentication.
>> > No matter what you type in the window (even admin for server) it just
>> > keeps
>> > popping up. When you click cancel you see the following error.
>> >
>> > HTTP Error 401.1 - Unauthorized: Access is denied due to invalid
>> > credentials.
>> > Internet Information Services (IIS)
>> >
>> > The log file shows the following
>> >
>> >
>> > w3wp!chunks!2dd8!04/01/2005-10:08:15:: i INFO: ###
>> > GetReportChunk('RenderingInfo_PDF', Other), chunk was not found!
>> > this=ea4cb70a-7dac-4390-bac8-140c7d6f67d5
>> > w3wp!reportrendering!2dd8!04/01/2005-10:08:15:: e ERROR: Throwing
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown., ;
>> > Info:
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > -- End of inner exception stack trace --
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> > -- End of inner exception stack trace --
>> > w3wp!webserver!2dd8!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!webserver!3234!04/01/2005-10:08:18:: e ERROR: Reporting Services
>> > error
>> > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
>> > has
>> > occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
>> > An
>> > error has occurred during report processing. -->
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
>> > Query
>> > execution failed for data set 'dsChangesInLargeLoss'. -->
>> > System.Data.SqlClient.SqlException: The conversion of a char data type
>> > to
>> > a
>> > datetime data type resulted in an out-of-range datetime value.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Found
>> > System.StackOverflowException exception:
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.StackOverflowException: Exception of type
>> > System.StackOverflowException was thrown.
>> > w3wp!library!2dd8!04/01/2005-10:08:19:: e ERROR: Terminating worker
>> > process
>> >
>> > Other reports in production export to PDF without a problem, just this
>> > one
>> > report is causing issues.
>> >
>> > Any idea what might be causing this issue? The report exports to PDF
>> > fine
>> > in development for this report. Has anyone else seen this issue
>> > before?
>> >
>>

Passwords in the SSIS configuration file

Thanks to some earlier help from this forum, I have my package running using configuration files and Windows Authentication. However, when I try to execute the package using Sql authentication, login fails for the user i am specifying. When I check out the configuration file, the connection string does not contain the password. I added the password to the connection string, but it does not cone back. I followed the instructions found on the following site:

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

After trying what was suggested there, I was still unsuccessful with my login attempt.

Anyone know how to set up a package to run using Sql authentication?

Thanks!

Craig

At the time of development, set the protection level of package to EncryptSensitiveWithUserKey, after this sertting the package will store the sensitive information like password in itself.

Atul

Passwords for the logins

Hi All,
Sql server 7
There are set of logins in sql server some are NT authentication and some are sql server authentication. How can i retrieve the passwords for both these logins.
TIA
AdilYou must be kind of foggy on the concept. They are passwords. They are supposed to be secret, and SQL Server keeps them that way.

If you have sufficient rights you can reset the passwords to whatever you want.

password synchronization - newbie question

We are using SQL Server authentication in a new W2k system that is replacing
a legacy UNIX system. I have a script that successfully recreates the user
accounts, but of course I have to default the password. Our security folks w
ill never agree to such a s
cheme, especially since I have read on this newsgroup that there is no way t
o force the users to change their passwords the first time they log on. Is t
here any way to port the users' UNIX passwords to SQL Server 2000? I can cap
ture the encrypted UNIX pas
swords, and was hoping there was a way to use them to populate the "password
" field of the master.sysxlogins table. Is the encryption used for UNIX in
any way compatible or "translate-able" to the encryption used by SQL Server?
This would probably be much easier if we were using Windows authentication,
but for our particular implementation, we have some other compelling reasons
not to.No the encryption algorithm is not going to be the same as any Unix based
system.
I would think that if you're writing a custom application you could force
the users to execute sp_password
at the same interval as the Unix system. But, if the users are simply
using Query Analyser and the other SQL tools,
there's no way to force this.
Yukon, the next release may address password policy enforcement that would
resolve issues like this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you, Kevin. I'll talk to our developers about adding a call to sp_pass
word.

Password security

Have SQL 7.0 running on a Windows 2000 server. Users
access the database on a front end client that utilizes
SQL authentication. I see no password restriction
properties anywhere. I need to set some restrictions,
such as password expiration in 90 days, unique password
requirements, and minimum password lengths. Where do I
set up these restrictions? I can't find anything.Those options are not availble for SQL logins in SQL 7 or 2000. Odds are
we'll have it for the next major release.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Password Change Date

Is there a way to retreive the date and time when a user last time changed
his/her SQL password? I am using SQL 2000/SQL Server Authentication.
TIA
SorinHi,
SQL Server will not store those information.
Thanks
Hari
SQL Server MVP
"SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
news:65DF9A86-8711-404D-B6C9-930113378751@.microsoft.com...
> Is there a way to retreive the date and time when a user last time changed
> his/her SQL password? I am using SQL 2000/SQL Server Authentication.
> TIA
> Sorin|||Check out the updatedate column in syslogins. Other changes might change this as well, like changing
default language or default database, but I doubt that you do that very often.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"SOPONL" <SOPONL@.discussions.microsoft.com> wrote in message
news:65DF9A86-8711-404D-B6C9-930113378751@.microsoft.com...
> Is there a way to retreive the date and time when a user last time changed
> his/her SQL password? I am using SQL 2000/SQL Server Authentication.
> TIA
> Sorin

Password Change

I am relatively new to SQL and have the developer edition
on my desktop. I think that I may have used the wrong
method of authentication as I have to change my password
on the network every 90 dys and now the SQL server
service will not start and I get a password error. When I
try to view the properties I get an error saying the
password is incorrect.You can also change the Windows service account password for the SQL Server
service under Windows 2000/XP as follows.
Right-click on My Computer and select Manage
Select 'Service and Applications' and then Services
Double-click on 'MSSQLSERVER' (or 'MSSQL$YourInstanceName') from the
services list and clock the 'Log On' tab
Once you've successfully started the SQL Server service, you can change the
service account to the system account via Enterprise Manager so that you
don't need to bother with periodically changing the service password.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike" <mrestall@.superbolt.com> wrote in message
news:965e01c3eb21$359cc320$a101280a@.phx.gbl...

quote:

---

> I am relatively new to SQL and have the developer edition
> on my desktop. I think that I may have used the wrong
> method of authentication as I have to change my password
> on the network every 90 dys and now the SQL server
> service will not start and I get a password error. When I
> try to view the properties I get an error saying the
> password is incorrect.

---

password cannot be saved

Hi, there;
I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..."

Did I do something wrong or anybody know how to save that password field?

CheersThe password in a SQL-authenticated connection is considered sensitive data. SSIS wants to encrypt any sensitive data in the package (see ProtectionLevel). By default it does this with your user key. Unless you've changed the ProtectionLevel, you should be able to save the package and reopen it (as the same user) and have it preserve your password. If you're going to be opening it from an application, your best bet for ProtectionLevel is probably to use the "EncryptSensitiveWithPassword" option, which uses a password to encrypt the sensitive data. The application (and any users) will need to supply this password when opening the package.

A good alternative to storing sensitive data in the package is to read the password into the package using a Package Configuration mechanism.
|||

Thanks.

Do you mean I need another password to open my package?

Where can I set the "ProtectionLevel" in the package?

|||See the link that JayH included.|||

Thank you.

I will try.

Pass-Through Authentication won't work when replicating via the ActiveX Library?

Hi all,
My sql2000 to sql2000 merge replication via internet is run via an
application on the subscriber using activex library.
I read about setting up pass-through authentication so that the user
accounts don't need to be on the same domain. So, I set up Sql Server
and Sql Agent to run on a user account set up identically on each
machine. But, it doesn't seem like the Sql Agent is even involved in
the communication on the subscriber.
Authentication at the publisher fails because it is trying to
authenticate - not the account that sql server and sql agent services
are running under - but the current windows account running on the
subscriber.
ie:
- sql server and sql agent running under "serviceAccount"
- windows user on subscriber machine logged in as "Joe"
- error at publisher = cannot authenticate Joe.
Now, if I create a Joe user on the publisher, with the same password as
on the subscriber, everything works. But this is an impossible setup to
work with because of course there will be many different unknown users.
Please, can anyone help with this? I can't find this problem
anywhere...
JJ
Its probably using the security context of the account you are logged in
under. If you were to run this program/script as a job spawned by SQL Server
agent it would work. Another option would be to use the run as command (have
a look at runas from the command prompt).
I think your best bet would be to use sql authentication though.
This could also be an rights issue when you connect to the snapshot share -
exactly what error message are you getting?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1121742075.969113.19600@.z14g2000cwz.googlegro ups.com...
> Hi all,
> My sql2000 to sql2000 merge replication via internet is run via an
> application on the subscriber using activex library.
> I read about setting up pass-through authentication so that the user
> accounts don't need to be on the same domain. So, I set up Sql Server
> and Sql Agent to run on a user account set up identically on each
> machine. But, it doesn't seem like the Sql Agent is even involved in
> the communication on the subscriber.
> Authentication at the publisher fails because it is trying to
> authenticate - not the account that sql server and sql agent services
> are running under - but the current windows account running on the
> subscriber.
> ie:
> - sql server and sql agent running under "serviceAccount"
> - windows user on subscriber machine logged in as "Joe"
> - error at publisher = cannot authenticate Joe.
> Now, if I create a Joe user on the publisher, with the same password as
> on the subscriber, everything works. But this is an impossible setup to
> work with because of course there will be many different unknown users.
>
> Please, can anyone help with this? I can't find this problem
> anywhere...
> JJ
>
|||Yes I'm pretty sure that it's a rights issue - i was seeing error 1326
(unknown user or bad password). Like you said, it's likely because it's
using the security context of the account that I am logged in under on
the subscriber. In fact, I know that's the issue, b/c if I change the
username and password of my windows account that i am logged in under
on the subscriber to match the publisher, everything works like a
charm. But this is an impossible setup for me.
The issue here is that this is supposed to be an installable
application (unknown users)using MSDE on the subscriber, and the
application is using the ActiveX library - so anything outside of the
control of what can be set up by an installation app won't be feasible.
Re SQL authentication, are you saying that if I change the SQL Server
setup on the subscriber to use SQL authentication instead of windows
authentication, that it might work?
JJ
|||Yes, I am suggesting you do both (SQL authentication on the publisher and
subscriber). You can also use a com component and have this component run
under different security credentials than the account the user is logged on
under.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"JJ" <joe.jabour@.gmail.com> wrote in message
news:1121776681.002861.67670@.o13g2000cwo.googlegro ups.com...
> Yes I'm pretty sure that it's a rights issue - i was seeing error 1326
> (unknown user or bad password). Like you said, it's likely because it's
> using the security context of the account that I am logged in under on
> the subscriber. In fact, I know that's the issue, b/c if I change the
> username and password of my windows account that i am logged in under
> on the subscriber to match the publisher, everything works like a
> charm. But this is an impossible setup for me.
> The issue here is that this is supposed to be an installable
> application (unknown users)using MSDE on the subscriber, and the
> application is using the ActiveX library - so anything outside of the
> control of what can be set up by an installation app won't be feasible.
>
> Re SQL authentication, are you saying that if I change the SQL Server
> setup on the subscriber to use SQL authentication instead of windows
> authentication, that it might work?
> JJ
>
|||SQL auth on both didn't work - It was still using the credentials of
the windows login on the subscriber.
Solution - I created a "launcher" application that starts the
application under credentials that match the publisher.
Thanks for the help.
|||Well, it worked on my LAN, but not when i tested it from outside the
LAN. Again, permission problems. Do I need to upgrade the server to a
domain controller?
JJ