Wednesday, March 7, 2012

IIS and Sql report server

I use a hosting company that offers SQL reporting tools. However, they have basic authentication setup and will not remove it. So, when I use reportviewer, it prompts for a iis username and password. I only have one user account for the reporting tools and they do not create anymore. I do not want to give other people this username and password. So, with that being said. Is there anyway to auto populate the username and password field in asp.net? There is a way to do it in javascript. Like so:

<html>
<head>
<title>Frames</title>
<script language="javascript">
function populate()
{
var p = parent.frames["body"];
p.frm.elements["txtUsername"].value = "username";
p.frm.elements["txtPassword"].value = "password";
}
</script>
</head>
<frameset>
<frame name="body" src="http://pics.10026.com/?src=loginpage.aspx" onload="populate()">
</frameset>
</html>

However, if you did a view source, you'd have the username and password information. Is there any way to achieve this effect whether it be auto population through a frameset or some other method. My site and the sql reporting tools are on TWO different servers and have two different username and passwords. Someone had mentioned doing impersonation but it was not successful. Any ideas?

how bout u store ur username and name in the webconfig file.. and u call the report set the credentials...

so that u dont have to display the username and password to the user.

No comments:

Post a Comment