Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts

Friday, March 9, 2012

Encrypt passwords

Can anyone tell me the best way to encrypt password in a
SQL Server 2000 database? We are using IIS 5.0 and MS
Interdev. Hopefully, we will be moving to .Net in the
next couple of months, but for now I still need to find a
way to encrypt passwords in the current application.See: Storing Database Connection Strings Securely
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/SecNetch12.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||take a look at www.xpcrypt.com|||"Michelle" <michelle.vanden@.eglin.af.mil> wrote in message
news:0b4b01c3c57a$ae8db3b0$a601280a@.phx.gbl...
quote:

> Can anyone tell me the best way to encrypt password in a
> SQL Server 2000 database? We are using IIS 5.0 and MS
> Interdev. Hopefully, we will be moving to .Net in the
> next couple of months, but for now I still need to find a
> way to encrypt passwords in the current application.

Assuming you would like to store the password in an encrypted format
(as opposed to transmitting the data securely over the wire)
I found the following article to be helpful:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9809
I have used the method described successfully in a coldfusion application
using SQL Server 2000, and
the article is written for both 7.0 and 2000.
Benefit is, it's completely native to SQL, no 3rd party software to muck
about with.
xpcrypt does appear to be more robust from a security perspective (stronger
encryption algorithms, etc.)
but if all you want to do is not have plain text in the database,
pwdencrypt() should work fine.
Regards,
Jason

Friday, February 17, 2012

Empty RS Home-folder after changing IIS properties

Hi,
I've installed Reporting Services on my laptop and built some folders and
reports, works great. But when other persons tried to access my reports they
only got an empty Home-folder when connecting (to http://myserver/Reports). I
tried to change properties at IIS/default website/reports/properties
(directory security/anonymous access and auth control/anonymous access) and
after that also I get an empty Home-folder. I can do/see nothing! As you
already noticed I'm a total newbie to webservers/security/domains etc. Any
tips to get the access to my reports back ? I've changed nothing but IIS
props.
/jerome kThis is not an IIS issue. You have to go in and set security on your folders in
Report Manager. Users must have at least Browser permissions to see anything in
the folders, including your root folder.
/jerome k wrote:
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports they
> only got an empty Home-folder when connecting (to http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access) and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k|||The problem here is when you set anonymous then everybody is treated the
same, i.e. not given access. Change IIS back the way it was. Then create a
local group and put the people you want to have access to it in the group.
Next read up about roles. RS is role based. You have to put Window users or
groups into a role (using Report Manager). The window user or group can
either be local or domain. I create a local group and then add my domain
user and groups to the local group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"/jerome k" <jeromek@.discussions.microsoft.com> wrote in message
news:1C173666-89C0-46EC-86E2-360F3202095D@.microsoft.com...
> Hi,
> I've installed Reporting Services on my laptop and built some folders and
> reports, works great. But when other persons tried to access my reports
> they
> only got an empty Home-folder when connecting (to
> http://myserver/Reports). I
> tried to change properties at IIS/default website/reports/properties
> (directory security/anonymous access and auth control/anonymous access)
> and
> after that also I get an empty Home-folder. I can do/see nothing! As you
> already noticed I'm a total newbie to webservers/security/domains etc. Any
> tips to get the access to my reports back ? I've changed nothing but IIS
> props.
> /jerome k