hardcoding password instead of showing password box everytime

Dear all
Everytime, when my aspx application connect with the reports, it will also
show the password box for the input of username and password, however, can we
avoid it to show the password box? I want to implicity hardcoding the
username and password into the aspx and i don't want to show the password box
in the IEYou can use stored credentials for the data sources. In report manager, go
to the properties page of the report, click on the data sources tab and
specify a user name / pwd and click apply to store these credentials.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:81E41716-A88F-4C3B-B785-6012F6767E9D@.microsoft.com...
> Dear all
> Everytime, when my aspx application connect with the reports, it will also
> show the password box for the input of username and password, however, can
> we
> avoid it to show the password box? I want to implicity hardcoding the
> username and password into the aspx and i don't want to show the password
> box
> in the IE
>|||No the password prompt is from I.E. it ask from the domain user password to
see whether it have the right to see the reports or not, not the data sources
password
"Robert Bruckner [MSFT]" wrote:
> You can use stored credentials for the data sources. In report manager, go
> to the properties page of the report, click on the data sources tab and
> specify a user name / pwd and click apply to store these credentials.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:81E41716-A88F-4C3B-B785-6012F6767E9D@.microsoft.com...
> > Dear all
> > Everytime, when my aspx application connect with the reports, it will also
> > show the password box for the input of username and password, however, can
> > we
> > avoid it to show the password box? I want to implicity hardcoding the
> > username and password into the aspx and i don't want to show the password
> > box
> > in the IE
> >
>
>

Hackes SQL Server 2000

Hi Folks,
i got hacked and the password perhaps also the username for connecting over enterprise manager was changed. Is there a possibility to get my old stuff back or to get the changed username and password ?
Please help.

Patrick

System: windows2000Server
DB: SQL 2000Q1 Is there a possibility to get my old stuff back or to get the changed username and password ? Please help. Patrick
System: windows2000Server
DB: SQL 2000

A1 Yes. One might redo the entire server using new secure passwords(then restore each user DB from backups taken well before the incident).|||Do you have any idea on how you were hacked ? How is sql used in your environment ? Do you have web access to your sql server through an asp page (a select/update/delete queries) - if so, you may have a problem with how the programmers created it - someone might be using sql injection to change things like the sa password.|||1. If you still have BUILTIN/Administrators login, you can change your EM registration properties from sa to WinAuth.

2. LDF/MDF files can be attached to other/reinstalled server. Users lost.|||Hi guys,

i have no chance to switch to winauth, it's not working.
But i still have admin rights on the Server ??!!??
I try now to copy the ldf/mdf files to another sql server to
access them. What will happen with my DTS packages ?

Patrick|||DTS is stored in system databases, probably msdb. You can also extract login names and probably passwords from master.

One good source is
http://www.sqlservercentral.com/

There are queries how to decrypt passwords, restore system databases ...

Master database can be attached to other server as MASTER2 and you can decrypt sa password from master2.dbo.sysxlogins !!!