I have a report on my development server which opens fine in report manager
from MyComputer. I am not asked for credentials until I try to export it to
pdf. At that point, no matter what uid and pwd I enter the pdf will not come
up. When exporting the same report to Excel or HTML I am not asked for
credentials and the report comes up in those formats fine.
I need to get the report into a pdf. Please help. TIAHave you made any modifications to the config files? It sounds like
something broke or a permissions configuration got changed in your PDF
rendering extension.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"pdschuller" <pdschuller@.discussions.microsoft.com> wrote in message
news:1D476EAD-75E4-46A4-85C4-D5014BB6AAAD@.microsoft.com...
>I have a report on my development server which opens fine in report manager
> from MyComputer. I am not asked for credentials until I try to export it
> to
> pdf. At that point, no matter what uid and pwd I enter the pdf will not
> come
> up. When exporting the same report to Excel or HTML I am not asked for
> credentials and the report comes up in those formats fine.
> I need to get the report into a pdf. Please help. TIA|||Looks like you're basically correct. I installed SP1 for Reporting Services
and the report exports to a pdf fine now. Thanks.
"Jeff A. Stucker" wrote:
> Have you made any modifications to the config files? It sounds like
> something broke or a permissions configuration got changed in your PDF
> rendering extension.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "pdschuller" <pdschuller@.discussions.microsoft.com> wrote in message
> news:1D476EAD-75E4-46A4-85C4-D5014BB6AAAD@.microsoft.com...
> >I have a report on my development server which opens fine in report manager
> > from MyComputer. I am not asked for credentials until I try to export it
> > to
> > pdf. At that point, no matter what uid and pwd I enter the pdf will not
> > come
> > up. When exporting the same report to Excel or HTML I am not asked for
> > credentials and the report comes up in those formats fine.
> >
> > I need to get the report into a pdf. Please help. TIA
>
>sql
Showing posts with label required. Show all posts
Showing posts with label required. Show all posts
Monday, March 26, 2012
pdf export credentials required
Friday, March 9, 2012
Password Required on Open of Linked Access mdb file
Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:
>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:
>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!
Password Required on Open of Linked Access mdb file
Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!
That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:
>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that links to the SQL Server. Is there anywhere to store
my password so that I can bypass having to enter it
everytime I open a linked mdb? Thanks!
That information is stored in the tabledef properties of the linked
tables. One solution to this problem is to write code when the
application starts up. The code creates new tabledef objects,
supplying the user name and password (which you can collect from a
form). When the application shuts down, delete the tabledef objects.
This way security information persists only for the life of the
application instead of being permanently cached with the linked
tables.
--mary
On Mon, 3 May 2004 16:01:07 -0700, "mj"
<anonymous@.discussions.microsoft.com> wrote:
>Any help would be great. I have an mdb file that is linked
>to a table on my SQL Server which resides on a corporate
>Web Server. I have a non-Windows Authenticated username
>and password to the SQL Server database, so I have to
>enter the password everytime I open the Access database
>that links to the SQL Server. Is there anywhere to store
>my password so that I can bypass having to enter it
>everytime I open a linked mdb? Thanks!
Subscribe to:
Posts (Atom)