We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?
Thanks very much in advance.First step is to look in SQL Servers errorlog file for the reason why SQL Server won't start.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We cannot
> get back into Enterprise Manager to reset the startup parameters. How can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>|||> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
The parameters for a default SQL 2000 instance are in the registry under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters
If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>
Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts
Tuesday, March 27, 2012
Can't start SQL Server 2000
We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?
Thanks very much in advance.
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
The parameters for a default SQL 2000 instance are in the registry under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ MSSQLServer\Parameters
If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>
sql
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?
Thanks very much in advance.
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
The parameters for a default SQL 2000 instance are in the registry under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\ MSSQLServer\Parameters
If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"Moishe Much" <MoisheMuch@.discussions.microsoft.com> wrote in message
news:C69EDED1-03A5-4B92-B5D4-DFE80C2B1A19@.microsoft.com...
> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
> error is that it cannot find master database and will not start. We
> cannot
> get back into Enterprise Manager to reset the startup parameters. How
> can
> we reset the parameters and, more importantly, restart SQL Server?
> Thanks very much in advance.
>
sql
Tuesday, March 20, 2012
Can't see stored proc results
I have this stored proc:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[usp_CrimRecTest]
-- Add the parameters for the stored procedure here
@.caseID [nvarchar]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT dbo.tblCASENOMASTER.CASENO, dbo.tblCASEMAST.LASTNAME, dbo.tblCASEMAST.FRSTNAME
FROM dbo.tblCASENOMASTER LEFT OUTER JOIN
dbo.tblCASEMAST ON dbo.tblCASENOMASTER.CASENO = dbo.tblCASEMAST.CASENO
WHERE (dbo.tblCASENOMASTER.CASENO = @.caseID)
END
When I run this with an EXEC statement, the result pane shows no results but the message pane says it completed successfully and one row is affected. I know my input data is good. I also get nothing when I call this sproc from a VB front end. Any ideas?
Thanks.
What did you mean by --Insert statements for procedure here ? Is there something which you commented out for posting here ? The insert can prdouce x rows affected also as the Select part can. So the insert suceeded with X rows, but the query didn′t bring back any results.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||All comment lines in this post are from the template produced when I created the sproc in SQL Server 2005. The code posted is copied directly from my sproc - nothing deleted, altered or commented out.|||
I found the problem.
@.caseID [nvarchar] was changed to:
@.caseID nvarchar(12)
This ran correctly.
Thanks for your reply Jens.
Monday, March 19, 2012
Can't Save Report Parameters
I have looked at the SOAP method of integration as well as the URL method,
and it is just not possible to save report parameters as selected by the
user! The only way you can save them is if you re-invent your own parameter
inputs! And keep in mind that a complete integration solution should be able
to accept any possible combination of report parameters!
I think this is another oversight in the design of this product from
microsoft. They have specially designed ways to cache report data, saving
history, etc... But what about the more common case of wanting fresh data
for the same parameters? I am amazed that they did not think of this...
Is there anything like this in the works for version 2... Yes?
Please tell me yes :-]
MalikLet me also clarify that the difficulty here is getting the parameter input
from the user.
If I already know what parameters I want to run the report for, there is no
problem.
The problem is, the user can change them and then re-run the report, and I
have no idea
what parameters are currently in the report being displayed!
Malik
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> I have looked at the SOAP method of integration as well as the URL method,
> and it is just not possible to save report parameters as selected by the
> user! The only way you can save them is if you re-invent your own
parameter
> inputs! And keep in mind that a complete integration solution should be
able
> to accept any possible combination of report parameters!
> I think this is another oversight in the design of this product from
> microsoft. They have specially designed ways to cache report data, saving
> history, etc... But what about the more common case of wanting fresh data
> for the same parameters? I am amazed that they did not think of this...
> Is there anything like this in the works for version 2... Yes?
> Please tell me yes :-]
> Malik
>
>|||Donovan,
Thanks very much for your report. This is exactly the kind of solution I
need, although there are still a few problems.
I thought of doing it this way, but I am trying to fully integrate SQL RS
with our Web Application. I don't want to have to explain to our customers
that in order to design reports for use with our application you have to
always have those extra data sources present along with code to retrieve the
parameters. This puts the onus on the report developer to be a coder rather
than me taking care of the whole solution myself.
I suppose I could come up with some kind of template report that our
customers can start with, and that would make this a workable solution for
us. I am going over your report in more detail to see what I can learn from
it.
Your help has been quite valuable for my project, and I really appreciate
you sending the report!
Thank you very much indeed,
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> Take a look at the attached report for help. It goes against the pubs
sample database and requires
> a SQL script to be run on the db prior to use.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Let me also clarify that the difficulty here is getting the parameter
input
> > from the user.
> >
> > If I already know what parameters I want to run the report for, there is
no
> > problem.
> >
> > The problem is, the user can change them and then re-run the report, and
I
> > have no idea
> > what parameters are currently in the report being displayed!
> >
> > Malik
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > I have looked at the SOAP method of integration as well as the URL
method,
> > > and it is just not possible to save report parameters as selected by
the
> > > user! The only way you can save them is if you re-invent your own
> > parameter
> > > inputs! And keep in mind that a complete integration solution should
be
> > able
> > > to accept any possible combination of report parameters!
> > >
> > > I think this is another oversight in the design of this product from
> > > microsoft. They have specially designed ways to cache report data,
saving
> > > history, etc... But what about the more common case of wanting fresh
data
> > > for the same parameters? I am amazed that they did not think of
this...
> > >
> > > Is there anything like this in the works for version 2... Yes?
> > >
> > > Please tell me yes :-]
> > >
> > > Malik
> > >
> > >
> > >
> >
> >
>
>|||If the web application provided it's own parameter prompting area and passed along that data to our
Report Viewer then you could build this logic into your web application instead of relying on RS to
do it.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Donovan,
> Thanks very much for your report. This is exactly the kind of solution I
> need, although there are still a few problems.
> I thought of doing it this way, but I am trying to fully integrate SQL RS
> with our Web Application. I don't want to have to explain to our customers
> that in order to design reports for use with our application you have to
> always have those extra data sources present along with code to retrieve the
> parameters. This puts the onus on the report developer to be a coder rather
> than me taking care of the whole solution myself.
> I suppose I could come up with some kind of template report that our
> customers can start with, and that would make this a workable solution for
> us. I am going over your report in more detail to see what I can learn from
> it.
> Your help has been quite valuable for my project, and I really appreciate
> you sending the report!
> Thank you very much indeed,
> Malik
> "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > Take a look at the attached report for help. It goes against the pubs
> sample database and requires
> > a SQL script to be run on the db prior to use.
> >
> > --
> > Thanks.
> >
> > Donovan R. Smith
> > Software Test Lead
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Let me also clarify that the difficulty here is getting the parameter
> input
> > > from the user.
> > >
> > > If I already know what parameters I want to run the report for, there is
> no
> > > problem.
> > >
> > > The problem is, the user can change them and then re-run the report, and
> I
> > > have no idea
> > > what parameters are currently in the report being displayed!
> > >
> > > Malik
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > I have looked at the SOAP method of integration as well as the URL
> method,
> > > > and it is just not possible to save report parameters as selected by
> the
> > > > user! The only way you can save them is if you re-invent your own
> > > parameter
> > > > inputs! And keep in mind that a complete integration solution should
> be
> > > able
> > > > to accept any possible combination of report parameters!
> > > >
> > > > I think this is another oversight in the design of this product from
> > > > microsoft. They have specially designed ways to cache report data,
> saving
> > > > history, etc... But what about the more common case of wanting fresh
> data
> > > > for the same parameters? I am amazed that they did not think of
> this...
> > > >
> > > > Is there anything like this in the works for version 2... Yes?
> > > >
> > > > Please tell me yes :-]
> > > >
> > > > Malik
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>|||Yes, I could write my own code to take care of parameter input, which would
have to do the following:
- prompt for any combination of parameters
- include default values and available values, with queried available
values in a drop-down list
- validate all parameter data types entered, null and blank values
- correctly take hidden parameters from the URL when they are passed
This would have to be robust enough for any report that my customers can
design to work with my web app.
I don't want to be lazy, but since RS already does all of this, I don't want
to re-invent the wheel.
I think it would be much easier for someone who already knows what
parameters are in the reports. In my scenario, our customers will expect to
just open a SQL RS report from our web app. They may design their own, or
get reports from elsewhere. It is a full integration.
I am still very much in design mode (although I should have finished long
ago :-) so I am quite open to suggestions.
Thanks again for your help.
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:eCLqPftiEHA.3896@.TK2MSFTNGP15.phx.gbl...
> If the web application provided it's own parameter prompting area and
passed along that data to our
> Report Viewer then you could build this logic into your web application
instead of relying on RS to
> do it.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> > Donovan,
> >
> > Thanks very much for your report. This is exactly the kind of solution I
> > need, although there are still a few problems.
> >
> > I thought of doing it this way, but I am trying to fully integrate SQL
RS
> > with our Web Application. I don't want to have to explain to our
customers
> > that in order to design reports for use with our application you have to
> > always have those extra data sources present along with code to retrieve
the
> > parameters. This puts the onus on the report developer to be a coder
rather
> > than me taking care of the whole solution myself.
> >
> > I suppose I could come up with some kind of template report that our
> > customers can start with, and that would make this a workable solution
for
> > us. I am going over your report in more detail to see what I can learn
from
> > it.
> >
> > Your help has been quite valuable for my project, and I really
appreciate
> > you sending the report!
> >
> > Thank you very much indeed,
> > Malik
> >
> > "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in
message
> > news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > > Take a look at the attached report for help. It goes against the pubs
> > sample database and requires
> > > a SQL script to be run on the db prior to use.
> > >
> > > --
> > > Thanks.
> > >
> > > Donovan R. Smith
> > > Software Test Lead
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > > Let me also clarify that the difficulty here is getting the
parameter
> > input
> > > > from the user.
> > > >
> > > > If I already know what parameters I want to run the report for,
there is
> > no
> > > > problem.
> > > >
> > > > The problem is, the user can change them and then re-run the report,
and
> > I
> > > > have no idea
> > > > what parameters are currently in the report being displayed!
> > > >
> > > > Malik
> > > >
> > > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > > I have looked at the SOAP method of integration as well as the URL
> > method,
> > > > > and it is just not possible to save report parameters as selected
by
> > the
> > > > > user! The only way you can save them is if you re-invent your own
> > > > parameter
> > > > > inputs! And keep in mind that a complete integration solution
should
> > be
> > > > able
> > > > > to accept any possible combination of report parameters!
> > > > >
> > > > > I think this is another oversight in the design of this product
from
> > > > > microsoft. They have specially designed ways to cache report data,
> > saving
> > > > > history, etc... But what about the more common case of wanting
fresh
> > data
> > > > > for the same parameters? I am amazed that they did not think of
> > this...
> > > > >
> > > > > Is there anything like this in the works for version 2... Yes?
> > > > >
> > > > > Please tell me yes :-]
> > > > >
> > > > > Malik
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
and it is just not possible to save report parameters as selected by the
user! The only way you can save them is if you re-invent your own parameter
inputs! And keep in mind that a complete integration solution should be able
to accept any possible combination of report parameters!
I think this is another oversight in the design of this product from
microsoft. They have specially designed ways to cache report data, saving
history, etc... But what about the more common case of wanting fresh data
for the same parameters? I am amazed that they did not think of this...
Is there anything like this in the works for version 2... Yes?
Please tell me yes :-]
MalikLet me also clarify that the difficulty here is getting the parameter input
from the user.
If I already know what parameters I want to run the report for, there is no
problem.
The problem is, the user can change them and then re-run the report, and I
have no idea
what parameters are currently in the report being displayed!
Malik
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> I have looked at the SOAP method of integration as well as the URL method,
> and it is just not possible to save report parameters as selected by the
> user! The only way you can save them is if you re-invent your own
parameter
> inputs! And keep in mind that a complete integration solution should be
able
> to accept any possible combination of report parameters!
> I think this is another oversight in the design of this product from
> microsoft. They have specially designed ways to cache report data, saving
> history, etc... But what about the more common case of wanting fresh data
> for the same parameters? I am amazed that they did not think of this...
> Is there anything like this in the works for version 2... Yes?
> Please tell me yes :-]
> Malik
>
>|||Donovan,
Thanks very much for your report. This is exactly the kind of solution I
need, although there are still a few problems.
I thought of doing it this way, but I am trying to fully integrate SQL RS
with our Web Application. I don't want to have to explain to our customers
that in order to design reports for use with our application you have to
always have those extra data sources present along with code to retrieve the
parameters. This puts the onus on the report developer to be a coder rather
than me taking care of the whole solution myself.
I suppose I could come up with some kind of template report that our
customers can start with, and that would make this a workable solution for
us. I am going over your report in more detail to see what I can learn from
it.
Your help has been quite valuable for my project, and I really appreciate
you sending the report!
Thank you very much indeed,
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> Take a look at the attached report for help. It goes against the pubs
sample database and requires
> a SQL script to be run on the db prior to use.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Let me also clarify that the difficulty here is getting the parameter
input
> > from the user.
> >
> > If I already know what parameters I want to run the report for, there is
no
> > problem.
> >
> > The problem is, the user can change them and then re-run the report, and
I
> > have no idea
> > what parameters are currently in the report being displayed!
> >
> > Malik
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > I have looked at the SOAP method of integration as well as the URL
method,
> > > and it is just not possible to save report parameters as selected by
the
> > > user! The only way you can save them is if you re-invent your own
> > parameter
> > > inputs! And keep in mind that a complete integration solution should
be
> > able
> > > to accept any possible combination of report parameters!
> > >
> > > I think this is another oversight in the design of this product from
> > > microsoft. They have specially designed ways to cache report data,
saving
> > > history, etc... But what about the more common case of wanting fresh
data
> > > for the same parameters? I am amazed that they did not think of
this...
> > >
> > > Is there anything like this in the works for version 2... Yes?
> > >
> > > Please tell me yes :-]
> > >
> > > Malik
> > >
> > >
> > >
> >
> >
>
>|||If the web application provided it's own parameter prompting area and passed along that data to our
Report Viewer then you could build this logic into your web application instead of relying on RS to
do it.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Donovan,
> Thanks very much for your report. This is exactly the kind of solution I
> need, although there are still a few problems.
> I thought of doing it this way, but I am trying to fully integrate SQL RS
> with our Web Application. I don't want to have to explain to our customers
> that in order to design reports for use with our application you have to
> always have those extra data sources present along with code to retrieve the
> parameters. This puts the onus on the report developer to be a coder rather
> than me taking care of the whole solution myself.
> I suppose I could come up with some kind of template report that our
> customers can start with, and that would make this a workable solution for
> us. I am going over your report in more detail to see what I can learn from
> it.
> Your help has been quite valuable for my project, and I really appreciate
> you sending the report!
> Thank you very much indeed,
> Malik
> "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
> news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > Take a look at the attached report for help. It goes against the pubs
> sample database and requires
> > a SQL script to be run on the db prior to use.
> >
> > --
> > Thanks.
> >
> > Donovan R. Smith
> > Software Test Lead
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Let me also clarify that the difficulty here is getting the parameter
> input
> > > from the user.
> > >
> > > If I already know what parameters I want to run the report for, there is
> no
> > > problem.
> > >
> > > The problem is, the user can change them and then re-run the report, and
> I
> > > have no idea
> > > what parameters are currently in the report being displayed!
> > >
> > > Malik
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > I have looked at the SOAP method of integration as well as the URL
> method,
> > > > and it is just not possible to save report parameters as selected by
> the
> > > > user! The only way you can save them is if you re-invent your own
> > > parameter
> > > > inputs! And keep in mind that a complete integration solution should
> be
> > > able
> > > > to accept any possible combination of report parameters!
> > > >
> > > > I think this is another oversight in the design of this product from
> > > > microsoft. They have specially designed ways to cache report data,
> saving
> > > > history, etc... But what about the more common case of wanting fresh
> data
> > > > for the same parameters? I am amazed that they did not think of
> this...
> > > >
> > > > Is there anything like this in the works for version 2... Yes?
> > > >
> > > > Please tell me yes :-]
> > > >
> > > > Malik
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>|||Yes, I could write my own code to take care of parameter input, which would
have to do the following:
- prompt for any combination of parameters
- include default values and available values, with queried available
values in a drop-down list
- validate all parameter data types entered, null and blank values
- correctly take hidden parameters from the URL when they are passed
This would have to be robust enough for any report that my customers can
design to work with my web app.
I don't want to be lazy, but since RS already does all of this, I don't want
to re-invent the wheel.
I think it would be much easier for someone who already knows what
parameters are in the reports. In my scenario, our customers will expect to
just open a SQL RS report from our web app. They may design their own, or
get reports from elsewhere. It is a full integration.
I am still very much in design mode (although I should have finished long
ago :-) so I am quite open to suggestions.
Thanks again for your help.
Malik
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:eCLqPftiEHA.3896@.TK2MSFTNGP15.phx.gbl...
> If the web application provided it's own parameter prompting area and
passed along that data to our
> Report Viewer then you could build this logic into your web application
instead of relying on RS to
> do it.
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> news:OBI3I2piEHA.3320@.TK2MSFTNGP11.phx.gbl...
> > Donovan,
> >
> > Thanks very much for your report. This is exactly the kind of solution I
> > need, although there are still a few problems.
> >
> > I thought of doing it this way, but I am trying to fully integrate SQL
RS
> > with our Web Application. I don't want to have to explain to our
customers
> > that in order to design reports for use with our application you have to
> > always have those extra data sources present along with code to retrieve
the
> > parameters. This puts the onus on the report developer to be a coder
rather
> > than me taking care of the whole solution myself.
> >
> > I suppose I could come up with some kind of template report that our
> > customers can start with, and that would make this a workable solution
for
> > us. I am going over your report in more detail to see what I can learn
from
> > it.
> >
> > Your help has been quite valuable for my project, and I really
appreciate
> > you sending the report!
> >
> > Thank you very much indeed,
> > Malik
> >
> > "Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in
message
> > news:u8UcIjjiEHA.348@.tk2msftngp13.phx.gbl...
> > > Take a look at the attached report for help. It goes against the pubs
> > sample database and requires
> > > a SQL script to be run on the db prior to use.
> > >
> > > --
> > > Thanks.
> > >
> > > Donovan R. Smith
> > > Software Test Lead
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > news:ekCjdEPiEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > > Let me also clarify that the difficulty here is getting the
parameter
> > input
> > > > from the user.
> > > >
> > > > If I already know what parameters I want to run the report for,
there is
> > no
> > > > problem.
> > > >
> > > > The problem is, the user can change them and then re-run the report,
and
> > I
> > > > have no idea
> > > > what parameters are currently in the report being displayed!
> > > >
> > > > Malik
> > > >
> > > > "Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
> > > > news:uL2wf3OiEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > > > I have looked at the SOAP method of integration as well as the URL
> > method,
> > > > > and it is just not possible to save report parameters as selected
by
> > the
> > > > > user! The only way you can save them is if you re-invent your own
> > > > parameter
> > > > > inputs! And keep in mind that a complete integration solution
should
> > be
> > > > able
> > > > > to accept any possible combination of report parameters!
> > > > >
> > > > > I think this is another oversight in the design of this product
from
> > > > > microsoft. They have specially designed ways to cache report data,
> > saving
> > > > > history, etc... But what about the more common case of wanting
fresh
> > data
> > > > > for the same parameters? I am amazed that they did not think of
> > this...
> > > > >
> > > > > Is there anything like this in the works for version 2... Yes?
> > > > >
> > > > > Please tell me yes :-]
> > > > >
> > > > > Malik
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
Saturday, February 25, 2012
Can't pass parameter - rsAccessDenied
I am having a problem passing a parameter. When it gets to the last line of code where I set the parameters, I get this error. Can anyone help? The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)
Here is my code:
ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)
I have the same problem. It seems that setting user access rights in RS is a big nightmare. One wrong step, and the whole thing collapses, you need to reinstall YUKON from scratch.
|||You'll need to grant network service permission to view the report.
Do that in report manager or management studio. If you have the default roles, you should just assign the Browser role.
If the report server is on a remote computer, you'll need to grant to the machine account: <domain>\<machinename>$.
Does that answer your question?
-Lukasz
|||John, what specifically are you referring to? Do you know that if you login as a member of the local administrators group on the computer that hosts the report server, you can always set permissions?
-Lukasz
Can't pass parameter - rsAccessDenied
I am having a problem passing a parameter. When it gets to the last line of code where I set the parameters, I get this error. Can anyone help? The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied)
Here is my code:
ReportParameters(0) = New ReportParameter("ProjectKey", 262)
rv.ShowParameterPrompts = False
rv.ServerReport.ReportServerUrl = u.ConvertFromString("http://localhost/ReportServer/")
rv.ServerReport.ReportPath = "/Test/Duplicate_MIU_Report"
rv.ServerReport.SetParameters(ReportParameters)
I have the same problem. It seems that setting user access rights in RS is a big nightmare. One wrong step, and the whole thing collapses, you need to reinstall YUKON from scratch.
|||You'll need to grant network service permission to view the report.
Do that in report manager or management studio. If you have the default roles, you should just assign the Browser role.
If the report server is on a remote computer, you'll need to grant to the machine account: <domain>\<machinename>$.
Does that answer your question?
-Lukasz
|||John, what specifically are you referring to? Do you know that if you login as a member of the local administrators group on the computer that hosts the report server, you can always set permissions?
-Lukasz
Subscribe to:
Posts (Atom)