DBA Dilemma

We have a little dilemma with our DBA staff regarding reporting services and
using a general account, we call RSAdmin, for executing stored procs in the
background and bringing back the results via Reporting Services.
Our DBA is suggesting that we stay away from a general account like this
because of the implicit security that is associated with it. Our argument to
them is that if we start granting by individual, then that will make their
job even that much more complex and the maintenance on that is a nightmare
with people moving and quitting, etc..
Has anyone experience issues like this and how did you go about resolving
them.
Any answer is GREATLY appreciated and Thanks in advance.
wnfisbaI do not ever use the account of the person running the report. I have a
generic account say Reports (I run in mixed mode). This account is only used
for reports and is readonly. When I have a stored procedure it gives this
account execute permissions. This is very clean and is definitely not a
security hole. What user sees what is controled by who is given rights to
what report. So I control that at the Report Server.
Another advantage of this is that this allows connection pooling. Connection
pooling requires the connection to be exactly the same. If the connection is
for a different user then there will be a new connection created (or perhaps
multiple connections) per user running a report. Connection pooling both
puts less strain on the database server and it improves your performance.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:C576900D-1F8B-4DA6-B3EE-7F1642B034B4@.microsoft.com...
> We have a little dilemma with our DBA staff regarding reporting services
> and
> using a general account, we call RSAdmin, for executing stored procs in
> the
> background and bringing back the results via Reporting Services.
> Our DBA is suggesting that we stay away from a general account like this
> because of the implicit security that is associated with it. Our argument
> to
> them is that if we start granting by individual, then that will make their
> job even that much more complex and the maintenance on that is a nightmare
> with people moving and quitting, etc..
> Has anyone experience issues like this and how did you go about resolving
> them.
> Any answer is GREATLY appreciated and Thanks in advance.
> wnfisba

db url to image

Hi All, I am pretty new to reporting services, but i have question regarding how to display an image when i pull the url from a database. I cannot seem to figure out how to do it and it seems pretty simple. If anyone has any ideas please let me know.

Thanks so much

josh

Josh..

Set the source in the report as external and the mime type depending on whatever file it is.

Regards

Karen

|||

Hi Josh,

For that you can set the value property of Image to that field (ie: field which contain url) and the source property to External.If its a picture from a folder/directory(local) add like

"file://"+Fields!Picture.Value

Thanks,

Sonu

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.
Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>
|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>
sql

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Hello all,
>> I have been asked to research the tools available for reporting database
>> schema / links within SQL 2000.
>> I need a tool which will go through objects and also stored procedures /
>> queries and report all references / links. The idea being to end up with
>> a complete list of items in a db and what is effected by each.
>> Has anyone used such a tool or perhaps knows of one they could recommend
>> I look into?
>> All help is greatly appreciated, Simon.
>>
>

DB Maintenance Plan reporting

The previous DBA had setup writing DB Maintenance Plan reports to a remote server. I am new to MSSQL (I primarily work with Oracle). I have configured another MSSQL 2000 server similar to previous ones, but the reports are not going into the remote database tables. Everything on the 'Reporting' tab for the DB Maint. Plan looks the same as older ones. Also, the SQL Agent service starts as a domain user, such as previous setups.
I am not sure what to check from here. I appreciate any help. Thanks.On SQL Agent, properties select forwading server to the new server you just setup.

DB LOOK UP

Hello,
Is there a way to use something like LOOKUP COMBO in reporting services.
What I want to do is, to be able to GO AND LOOK FOR some value from another
table
in a report..
The report name is mainreport
mainreport :
[Product Code] 1243
Intervention# LabourCost MaterialCost
43 5$ 3$
45 7$ 8$
SUBTOTAL
#interventions:2 12$ 11$ --> Can
we make a lookup to SALES table where we can find
--> sales QTY of product 1243'
SALES : 50 ,
2*100/50 = %4
[Product Code] xxxxx
....
Thank you so much!This is a basic heterogeneous (cross dataset) join, which are not in the
current version of Reporting Services. Is there no way you can do the join
in the query?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"zitus" <zitus@.community.nospam> wrote in message
news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is there a way to use something like LOOKUP COMBO in reporting services.
> What I want to do is, to be able to GO AND LOOK FOR some value from
> another
> table
> in a report..
> The report name is mainreport
> mainreport :
> [Product Code] 1243
> Intervention# LabourCost MaterialCost
> 43 5$ 3$
> 45 7$ 8$
> SUBTOTAL
> #interventions:2 12$ 11$ -->
> Can
> we make a lookup to SALES table where we can find
> --> sales QTY of product 1243'
> SALES : 50 ,
> 2*100/50 = %4
> [Product Code] xxxxx
> ....
> Thank you so much!
>|||I will try..
Will it be possible in SP2 ? or RS2005 ? ( cross dataset )
"Brian Welcker" <bwelcker@.online.microsoft.com> wrote in message
news:e2KVbXoNFHA.644@.TK2MSFTNGP14.phx.gbl...
> This is a basic heterogeneous (cross dataset) join, which are not in the
> current version of Reporting Services. Is there no way you can do the join
> in the query?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "zitus" <zitus@.community.nospam> wrote in message
> news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
> > Hello,|||Sorry, no.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"zitus" <zitus@.community.nospam> wrote in message
news:u$MW8doNFHA.2736@.tk2msftngp13.phx.gbl...
>I will try..
> Will it be possible in SP2 ? or RS2005 ? ( cross dataset )
> "Brian Welcker" <bwelcker@.online.microsoft.com> wrote in message
> news:e2KVbXoNFHA.644@.TK2MSFTNGP14.phx.gbl...
>> This is a basic heterogeneous (cross dataset) join, which are not in the
>> current version of Reporting Services. Is there no way you can do the
>> join
>> in the query?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "zitus" <zitus@.community.nospam> wrote in message
>> news:%23xiY4KoNFHA.1396@.TK2MSFTNGP10.phx.gbl...
>> > Hello,
>