SQL and HTML

[joanne79]

Hi,

I have sql server 2005. I used business intelligence development studio and created an html page for others to view on the server. My problem is that others cannot view it. Is there a way to insert sql into the page so that it looks at a table of net logins to allow access to view?

Thanks,
Joanne

 

[Qik3Coder]

Not sure I understand what you are doing, but let me sort some things out.

1. You have an SQL Server
Q1. Is this on YOUR pc, or another machine?

2. You have a product called Business Development Studio(BDS)
Q2. Is this a M$ product?
Q3. Is this "attached" to the SQL Server?

3. You have a PLAIN html page
Q4. Did you write this by hand?
Q5. Is this "in" BDS
Q6. Is the .html file stored on the SQL Server?


What I can tell you without any of those answered:
1. HTML is for display, it has no logic unto itself. This is what asp, .Net, php, etc. are for.
2. Visual Web Developer Express is a free download, which will let you create basic pages, which you can "hook up" to your SQL Database, and then do display from.
3. Whatever BDS is, it is probably designed to be on whatever machine wants to look at the data that you are getting from the SQL Server.


If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]

 

[joanne79]

I have Microsoft SQL Server 2005 which was installed with Microsoft Business Intelligence Development Studio. With this we have an intranet site (through work). We have written an html page for other employees to send us feedback. The other reports on the site are linked to a table that has their network id's. The access they have to the site is based on their network id's. We would like everyone to have access to the feedback page but it is coming up that they do not have enough permission to access. Not sure if there is a way to link the feedback page to the table with the network id's or if there is a way to make the feedback page open for anyone without needing to use their network id's. The SQL server is based at a data center but the programs to use it are on my PC. The html was written by hand in Microsoft Business Intelligence Development Studio.

Thanks,
Joanne

 

[Qik3Coder]

What is the actual error that you are getting? Is it an SQL error or a network error?

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]

 

[joanne79]

The error says that the user does not have sufficient permission to access the page.

Thanks,
Joanne

 

[philhege]

Hi Joanne,

Where does the page live? What are the AD permissions on the directory? What are the IIS perms on the site folder? What do you get back in a remote debugging session? What info do you get when you enable detailed error results for the user? If this is an .aspx page, have you enabled impersonation or delegation?

Post the detailed error results, including the stack trace, and I'm sure the collective mind here can solve your problem.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[joanne79]

I have only been working with these applications for about a month so I am not sure of some of the answers to your questions.
The exact error message that a user gets is this 'The permissions granted to user 'NetworkID' are insufficient for performing this operation. (rsAccessDenied) Get Online Help'
We have a Server at our companies datacenter. We use Microsoft SQL Server 2005 and Business Intelligence Development Studio. We have an intranet site that the url is our server name. On our SQL Server we have table with employee names and network id's. We have put other reports on the intranet site that employees are able to access, there is a piece of code written in them that says to look at the table of employees and if the users network id matches one in the table they can access. All other reports work fine for everyone, we were trying to create a feedback page and that is where we are having problems. The page is written in HTML. We deployed it and the link appears on our intranet site but when you try to open it you get the error above. We are trying to create a feedback page where an employee can type in a text box and click on a submit button and an email will come to us automatically.
I really appreciate all the help.

Thanks,
Joanne

 

[philhege]

That's decent information, Joanne. When you say that the error says 'NetworkID', is that verbatim or is the individual's ID in that spot?

Can you post the code snippet that detects the user's ID and looks at the table?

tks,

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[philhege]

Oh, and by reports, do you mean reports that are deployed to a SQL Server Reporting Services (SSRS) site?

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[joanne79]

The reports are deployed to a SSRS site.
The error message doesn't say 'Network ID' verbatim, it says the employees actual network id.
The code that we use for the other reports joins an employee table that we have on the server.
example would be-
join employee table
where system_user=net_login
So far by doing it this way employees have been able to run the reports on the server so that they can only see activity that they have done themselves(like sales and such). We tried to set the access on the feedback page so that it would be open to everyone and not need to look at the network id. Everything we have tried still comes up with the same error as I mentioned above.

Thanks,
Joanne

 

[philhege]

You still need permissions to the data. Check the SSRS management page to see if the user is a member of a group that has the correct rights to view a report in the folder you published to.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[joanne79]

We checked the permissions and they are supposed to have access to everything in the folder.
Do you know of anything in SSRS that would let you set up a feedback page other than using HTML, XML or ASP.NET?

Thanks,
Joanne

 

[philhege]

An SSRS site is designed to serve report pages using .RDL files.

I would set up another site (ASP.NET, HTML, whatever) for the feedback page.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.