Hi,

I am running SQL 2005 Express locally with the intent to learn the basics of
SQL Server before our business makes a purchase (Looking to move away from
Access)...

I am running Windows XP SP2 as a non-admin. As the local administrator I
have installed SQL 2005 Express Advanced Edition with the reporting services
component. I then installed Visual Basic 2005 Express thinking this had the
Report Builder components in it, then realised I needed the SQL Express
Toolkit, which I then downloaded and installed, and it updated the Visual
Basic 2005 Express installation.

I then installed the SQL 2005 version of the AdventureWorks OLTP database.
This has appeared in the SQL Management Studio and all looks good. I then ran
the Business Intelligence Development Studio (Using runas) and created a new
project.

I had to enable named pipes (What is a named pipe btw!), whilst leaving the
SQL Browser service off (As I knew where the database was), and made a
connection which was succesful. I then used the query builder to create a
simple select all statement from the employee table of the database. I then
published the report succesfully to the report server component.

If I launch IE as the local administrator the report loads fine, however if
I run it as myself (Integrated Authentication has been left on) then it says
I do not have permissions:

The permissions granted to user are insufficient for performing this
operation. (rsAccessDenied)

I really know nothing about setting permissions etc so I am not sure how to
fix this? Can someone advise? I tried looking at MSDN which said to go into
Management Studio and find the browse role and assign it to the relevant
users... but I cannot find this?