help for starting SQL Express Manager 2005

Can anyone advise how I access SQL Express Manager ?

After starting Express Manager (preview 1) and selecting "Windows Authentication" I am asked for "Server Instance" What is meant by server Instance ?
Or with "SQL Server authentication" option selected I'm asked for name and passsword as well.

Is this something I ovelooked setting up when installing SQL 2005 Express ? I dont remember setting any passwords.

WHich option should I be going for ?

Have read accompanying documentation and looked on web but have not found a guide on this.

RECEIVED THIS REPLY TO MY QUERY ON ANOTHER THREAD

Hi,

SQL Server Express default instance which is the instance that gets created when you do not specify a name is installed as SQLExpress.

In Windows Authentication the current interactive Windows User is used for logging on so you just need to supply the instance name as .\SQLExpress or
MachineName\SQLExpress.

SQL Express also supports SQL Authentication. In case you want to take that route please go through the following post:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=62998
(Scrolll down to see the thread where I have provided the steps.)

Regards,
Vikram

.\SQLExpress - worked for me for the Windows Authentication - 0oseven

Help applying SP2 Beta

Help!!!
After applying SP2 beta to my Test Server I get the following message when
launching the Report Manager:
"The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'Unknown'. The expected
version is 'C.0.6.54'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase)"
Get Online Help URL:
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
I tried following the Get Online Help link instructions without success.
I even uninstalled Report Server and re-installed my SP1 version!
Do I need to drop the Report Server Databases before re-installing?
I have back-up of the orignal tables
I need to acces some reports that I had created in the test environment.
--
Application Engineer / DBA
UCLA SOMMake sure that all of your SPs are in the dbo namespace.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> Help!!!
> After applying SP2 beta to my Test Server I get the following message when
> launching the Report Manager:
> "The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'Unknown'. The expected
> version is 'C.0.6.54'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)"
> Get Online Help URL:
> http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> I tried following the Get Online Help link instructions without success.
> I even uninstalled Report Server and re-installed my SP1 version!
> Do I need to drop the Report Server Databases before re-installing?
> I have back-up of the orignal tables
> I need to acces some reports that I had created in the test environment.
> --
> Application Engineer / DBA
> UCLA SOM|||Thanks Daniel, could you be a bit morer specific on how to ensure SPs in dbo
namespace!
"Daniel Reib [MSFT]" wrote:
> Make sure that all of your SPs are in the dbo namespace.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> > Help!!!
> >
> > After applying SP2 beta to my Test Server I get the following message when
> > launching the Report Manager:
> >
> > "The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'Unknown'. The expected
> > version is 'C.0.6.54'. To continue, update the version of the report
> > server
> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >
> > Get Online Help URL:
> >
> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >
> > I tried following the Get Online Help link instructions without success.
> >
> > I even uninstalled Report Server and re-installed my SP1 version!
> > Do I need to drop the Report Server Databases before re-installing?
> >
> > I have back-up of the orignal tables
> >
> > I need to acces some reports that I had created in the test environment.
> >
> > --
> > Application Engineer / DBA
> > UCLA SOM
>
>|||If you go to enterprise manager, find the reportserver database and look at
it's SPs. Who is the owner of the SPs?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> dbo
> namespace!
> "Daniel Reib [MSFT]" wrote:
>> Make sure that all of your SPs are in the dbo namespace.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> > Help!!!
>> >
>> > After applying SP2 beta to my Test Server I get the following message
>> > when
>> > launching the Report Manager:
>> >
>> > "The version of the report server database is either in a format that
>> > is
>> > not
>> > valid, or it cannot be read. The found version is 'Unknown'. The
>> > expected
>> > version is 'C.0.6.54'. To continue, update the version of the report
>> > server
>> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >
>> > Get Online Help URL:
>> >
>> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >
>> > I tried following the Get Online Help link instructions without
>> > success.
>> >
>> > I even uninstalled Report Server and re-installed my SP1 version!
>> > Do I need to drop the Report Server Databases before re-installing?
>> >
>> > I have back-up of the orignal tables
>> >
>> > I need to acces some reports that I had created in the test
>> > environment.
>> >
>> > --
>> > Application Engineer / DBA
>> > UCLA SOM
>>|||Ok... I have verified that the dbo is the owner or the Stored Procedures in
both the
ReportServer and ReportServerTembDB. There is also an RSExecute Role which
currently contains no users.
could this be the cause of the error?
I also need to metion that I had installed SQL SERVER SP4 beta.
Could this be cause problems with Reporting Services'
"Daniel Reib [MSFT]" wrote:
> If you go to enterprise manager, find the reportserver database and look at
> it's SPs. Who is the owner of the SPs?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> > dbo
> > namespace!
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Make sure that all of your SPs are in the dbo namespace.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> > Help!!!
> >> >
> >> > After applying SP2 beta to my Test Server I get the following message
> >> > when
> >> > launching the Report Manager:
> >> >
> >> > "The version of the report server database is either in a format that
> >> > is
> >> > not
> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> > expected
> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> > server
> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >
> >> > Get Online Help URL:
> >> >
> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >
> >> > I tried following the Get Online Help link instructions without
> >> > success.
> >> >
> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >
> >> > I have back-up of the orignal tables
> >> >
> >> > I need to acces some reports that I had created in the test
> >> > environment.
> >> >
> >> > --
> >> > Application Engineer / DBA
> >> > UCLA SOM
> >>
> >>
> >>
>
>|||Do you know what user you use to connect to the database server? You may
want to run rsconfig.exe to set the user to a specific user. You would then
need to manually add that user to each RSExecRole. There are four roles, on
in each of the following DB:
ReportServer
ReportServerTempDB
Master
Msdb
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> Ok... I have verified that the dbo is the owner or the Stored Procedures
> in
> both the
> ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> currently contains no users.
> could this be the cause of the error?
> I also need to metion that I had installed SQL SERVER SP4 beta.
> Could this be cause problems with Reporting Services'
> "Daniel Reib [MSFT]" wrote:
>> If you go to enterprise manager, find the reportserver database and look
>> at
>> it's SPs. Who is the owner of the SPs?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
>> > in
>> > dbo
>> > namespace!
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Make sure that all of your SPs are in the dbo namespace.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> > Help!!!
>> >> >
>> >> > After applying SP2 beta to my Test Server I get the following
>> >> > message
>> >> > when
>> >> > launching the Report Manager:
>> >> >
>> >> > "The version of the report server database is either in a format
>> >> > that
>> >> > is
>> >> > not
>> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> > expected
>> >> > version is 'C.0.6.54'. To continue, update the version of the report
>> >> > server
>> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >> >
>> >> > Get Online Help URL:
>> >> >
>> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >
>> >> > I tried following the Get Online Help link instructions without
>> >> > success.
>> >> >
>> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> > Do I need to drop the Report Server Databases before re-installing?
>> >> >
>> >> > I have back-up of the orignal tables
>> >> >
>> >> > I need to acces some reports that I had created in the test
>> >> > environment.
>> >> >
>> >> > --
>> >> > Application Engineer / DBA
>> >> > UCLA SOM
>> >>
>> >>
>> >>
>>|||May I jump in here? I am having a similar problem, but my error originally
differed slightly.
Instead of "found version 'Unknown'", mine reported "found version
'T.0.6.51'. Cause apparently
due to me using RSCONFIG to try to change the credentials used to connect to
the RS SQL
Server databases. Commands I issued:
rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p xxxxxx
RSAdmin was a created as user in ReportServer2000 and ReportServer2000TempDB
with same
permissions as the original account (an AD account versus SQL account, in
case that's important).
Restarted ReportServer service and got the error. Then realized from this
thread I had missed
MASTER and MSDB databases, so added RSAdmin user to those as well, then
issued "rsconfig"
commands as above for those two databases. NOW, the "found version" is
"Unknown", just
as Marcial is getting.
Hoping very much you can help! Thank you.
"Daniel Reib [MSFT]" wrote:
> Do you know what user you use to connect to the database server? You may
> want to run rsconfig.exe to set the user to a specific user. You would then
> need to manually add that user to each RSExecRole. There are four roles, on
> in each of the following DB:
> ReportServer
> ReportServerTempDB
> Master
> Msdb
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> > Ok... I have verified that the dbo is the owner or the Stored Procedures
> > in
> > both the
> > ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> > currently contains no users.
> > could this be the cause of the error?
> >
> > I also need to metion that I had installed SQL SERVER SP4 beta.
> > Could this be cause problems with Reporting Services'
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> If you go to enterprise manager, find the reportserver database and look
> >> at
> >> it's SPs. Who is the owner of the SPs?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
> >> > in
> >> > dbo
> >> > namespace!
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> > Help!!!
> >> >> >
> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> > message
> >> >> > when
> >> >> > launching the Report Manager:
> >> >> >
> >> >> > "The version of the report server database is either in a format
> >> >> > that
> >> >> > is
> >> >> > not
> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> > expected
> >> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> >> > server
> >> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >> >
> >> >> > Get Online Help URL:
> >> >> >
> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >
> >> >> > I tried following the Get Online Help link instructions without
> >> >> > success.
> >> >> >
> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >> >
> >> >> > I have back-up of the orignal tables
> >> >> >
> >> >> > I need to acces some reports that I had created in the test
> >> >> > environment.
> >> >> >
> >> >> > --
> >> >> > Application Engineer / DBA
> >> >> > UCLA SOM
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||You only want to issue rsconfig for the report server database, not for the
temp or any other. RSConfig.exe does NOT update the RSExecRole that is
present in the 4 databases that you mention, you must do this manually.
So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
RSAdmin to the rsexecrole in the 4 databases mentioned below.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <JNoble@.discussions.microsoft.com> wrote in message
news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> May I jump in here? I am having a similar problem, but my error
> originally
> differed slightly.
> Instead of "found version 'Unknown'", mine reported "found version
> 'T.0.6.51'. Cause apparently
> due to me using RSCONFIG to try to change the credentials used to connect
> to
> the RS SQL
> Server databases. Commands I issued:
> rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> xxxxxx
> RSAdmin was a created as user in ReportServer2000 and
> ReportServer2000TempDB
> with same
> permissions as the original account (an AD account versus SQL account, in
> case that's important).
> Restarted ReportServer service and got the error. Then realized from this
> thread I had missed
> MASTER and MSDB databases, so added RSAdmin user to those as well, then
> issued "rsconfig"
> commands as above for those two databases. NOW, the "found version" is
> "Unknown", just
> as Marcial is getting.
> Hoping very much you can help! Thank you.
>
> "Daniel Reib [MSFT]" wrote:
>> Do you know what user you use to connect to the database server? You may
>> want to run rsconfig.exe to set the user to a specific user. You would
>> then
>> need to manually add that user to each RSExecRole. There are four roles,
>> on
>> in each of the following DB:
>> ReportServer
>> ReportServerTempDB
>> Master
>> Msdb
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
>> > Ok... I have verified that the dbo is the owner or the Stored
>> > Procedures
>> > in
>> > both the
>> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
>> > which
>> > currently contains no users.
>> > could this be the cause of the error?
>> >
>> > I also need to metion that I had installed SQL SERVER SP4 beta.
>> > Could this be cause problems with Reporting Services'
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> If you go to enterprise manager, find the reportserver database and
>> >> look
>> >> at
>> >> it's SPs. Who is the owner of the SPs?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
>> >> > SPs
>> >> > in
>> >> > dbo
>> >> > namespace!
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Make sure that all of your SPs are in the dbo namespace.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> >> > Help!!!
>> >> >> >
>> >> >> > After applying SP2 beta to my Test Server I get the following
>> >> >> > message
>> >> >> > when
>> >> >> > launching the Report Manager:
>> >> >> >
>> >> >> > "The version of the report server database is either in a format
>> >> >> > that
>> >> >> > is
>> >> >> > not
>> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> >> > expected
>> >> >> > version is 'C.0.6.54'. To continue, update the version of the
>> >> >> > report
>> >> >> > server
>> >> >> > database and verify access rights.
>> >> >> > (rsInvalidReportServerDatabase)"
>> >> >> >
>> >> >> > Get Online Help URL:
>> >> >> >
>> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >> >
>> >> >> > I tried following the Get Online Help link instructions without
>> >> >> > success.
>> >> >> >
>> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> >> > Do I need to drop the Report Server Databases before
>> >> >> > re-installing?
>> >> >> >
>> >> >> > I have back-up of the orignal tables
>> >> >> >
>> >> >> > I need to acces some reports that I had created in the test
>> >> >> > environment.
>> >> >> >
>> >> >> > --
>> >> >> > Application Engineer / DBA
>> >> >> > UCLA SOM
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Fantastic. Thanks very much.
Bad assumption on my part to initially run RSConfig against both db's. I see
some logic in the reported versions now, though. 'C' being the main db,
'T' being the Temp db, and 'Unknown' referring to Master and Msdb.
"Daniel Reib [MSFT]" wrote:
> You only want to issue rsconfig for the report server database, not for the
> temp or any other. RSConfig.exe does NOT update the RSExecRole that is
> present in the 4 databases that you mention, you must do this manually.
> So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
> RSAdmin to the rsexecrole in the 4 databases mentioned below.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "J Noble" <JNoble@.discussions.microsoft.com> wrote in message
> news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> > May I jump in here? I am having a similar problem, but my error
> > originally
> > differed slightly.
> > Instead of "found version 'Unknown'", mine reported "found version
> > 'T.0.6.51'. Cause apparently
> > due to me using RSCONFIG to try to change the credentials used to connect
> > to
> > the RS SQL
> > Server databases. Commands I issued:
> > rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> > rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> > xxxxxx
> > RSAdmin was a created as user in ReportServer2000 and
> > ReportServer2000TempDB
> > with same
> > permissions as the original account (an AD account versus SQL account, in
> > case that's important).
> > Restarted ReportServer service and got the error. Then realized from this
> > thread I had missed
> > MASTER and MSDB databases, so added RSAdmin user to those as well, then
> > issued "rsconfig"
> > commands as above for those two databases. NOW, the "found version" is
> > "Unknown", just
> > as Marcial is getting.
> >
> > Hoping very much you can help! Thank you.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Do you know what user you use to connect to the database server? You may
> >> want to run rsconfig.exe to set the user to a specific user. You would
> >> then
> >> need to manually add that user to each RSExecRole. There are four roles,
> >> on
> >> in each of the following DB:
> >>
> >> ReportServer
> >> ReportServerTempDB
> >> Master
> >> Msdb
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> >> > Ok... I have verified that the dbo is the owner or the Stored
> >> > Procedures
> >> > in
> >> > both the
> >> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
> >> > which
> >> > currently contains no users.
> >> > could this be the cause of the error?
> >> >
> >> > I also need to metion that I had installed SQL SERVER SP4 beta.
> >> > Could this be cause problems with Reporting Services'
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> If you go to enterprise manager, find the reportserver database and
> >> >> look
> >> >> at
> >> >> it's SPs. Who is the owner of the SPs?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
> >> >> > SPs
> >> >> > in
> >> >> > dbo
> >> >> > namespace!
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> >> > Help!!!
> >> >> >> >
> >> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> >> > message
> >> >> >> > when
> >> >> >> > launching the Report Manager:
> >> >> >> >
> >> >> >> > "The version of the report server database is either in a format
> >> >> >> > that
> >> >> >> > is
> >> >> >> > not
> >> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> >> > expected
> >> >> >> > version is 'C.0.6.54'. To continue, update the version of the
> >> >> >> > report
> >> >> >> > server
> >> >> >> > database and verify access rights.
> >> >> >> > (rsInvalidReportServerDatabase)"
> >> >> >> >
> >> >> >> > Get Online Help URL:
> >> >> >> >
> >> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >> >
> >> >> >> > I tried following the Get Online Help link instructions without
> >> >> >> > success.
> >> >> >> >
> >> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> >> > Do I need to drop the Report Server Databases before
> >> >> >> > re-installing?
> >> >> >> >
> >> >> >> > I have back-up of the orignal tables
> >> >> >> >
> >> >> >> > I need to acces some reports that I had created in the test
> >> >> >> > environment.
> >> >> >> >
> >> >> >> > --
> >> >> >> > Application Engineer / DBA
> >> >> >> > UCLA SOM
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

Help ... new to SQL

Hi,

I am working on a school project ...

I have the following schema:
<b>
DIVISION (dvname, manager)
DEPT (dname, parent-dname/parent-dvname, manager, floor#)
EMP (ename, salary, dname/dvname)
ITEM (iname, color, price, type)
SELL (dname, iname)
SUPPLY (sname, iname, dname)
</b>
Each of the first fields is the PKey.

I have to figure out the SQL for the following statement:

<b>List the items supplied by all companies that supply all items of type A.</b>

I have gotten this far, but do not understand division in SQL well enough .. I have a relational algebra solution that works ... but am having a hell of a time with a SQL solution ... Please help,

This is what I have in SQL:
SELECT SE.iname FROM SUPPLY SE WHERE NOT EXISTS
(SELECT I.iname FROM ITEM I WHERE I.type='A' AND NOT EXISTS
(SELECT S.iname FROM SUPPLY S WHERE S.iname=I.iname AND S.dname=SE.dname))

I have not work with SQL much so please help out ... I am using SQL Server if that matters ... Thanks--should give you the supply name where type = 'A'

select s.sname, i.iname, i.color, i.price, i.type
from supply s, item, i
where s.iname = i.iname and i.type = 'A'

if there is more to it let me know, but that should give you the items by supplier, if you want just distinct iname then just put

select distinct i.iname
from supply s, item, i
where s.iname = i.iname and i.type = 'A'

have fun

HELP !! HELP: Trigger to send REPORT !!!

Hi all,

Report Manager is failing to email out the reports !!!

And... I can not use Report Manager to configure the trigger !

How can I trigger manually to have SQL 2005 email out the reports again?

OR how can I trigger to run those emailing jobs again ?

Thanks,

Frank

I don't really understand the question. How are the subscriptions configured? (Timed or Snapshot?)

If they are configured to fire on a snapshot then you just need to update the report execution snapshot. If they are on a schedule, you could fire the SQL Agent job manually or call FireEvent passing in TimedSubscription and the subscriptionId.

Does that answer your question?

|||

Hi,

Yes, they are "TimedSubscription".

Do you mean to run one of the jobs under "SQL Server Agent"?

and how do I call "FireEvent" passing in TimedSubscription or the subscriptionId?

Thanks,

Frank

|||To trigger an subscription you could make your own small app which uses:
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.fireevent.aspx|||Yes, I meant you could use Sql Server Agent or do as BenniG. Suggested and have an app call the FireEvent method|||

Ok... let's say I want to use SQL Server Agent to run the job that can trigger the Report Manager to email out reports, do you guys have any documents that can show me how to do so?

I checked and ran some jobs under the SQL Server Agent, I don't see anyone of the jobs that were created to email out the reports, if there were no jobs created to do such task, how did those subscriptions email out before they started failing one by one?

Thanks,

Frank

|||

All report server jobs are named as Guids in SQL agent. Every job does essentially the same thing, which is add an event to the Report Server queue. You would need to match up which job created the correct event. If the subscription is to a shared schedule, the schedule ID will be the same as the job name, otherwise the only way to figure it out is find the schedule Id via the RS tables or trial and error.

However the recommened way is to call the FireEvent method.

HELP ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
Bernard
Sound like someone has turned on ODBC tracing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without any problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and
> each click on a table takes again ages until the rows are shown. Even paging takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in total max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show 40-50 rows !
> I have reorganized the DB, but that does not help at all for the performance.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and the live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, then I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anything special these last
> days. And more importantly, how do I get back to the previous status, where everything was real
> quick ? I just can't work properly anymore if every single click is taking minutes !!!
> Thanks for help.
> Bernard
|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>
|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
The ldf file is a part of the database. You can't get rid of it. If you consider it being too large,
then you should read in Books Online about recovery model and decide whether or not you want to do
regular transaction log backups. If you have had the db in full recovery model and not been doing
regular transaction log backups and have a very large ldf file, you can shrink it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:

HELP ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
BernardSound like someone has turned on ODBC tracing.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without any problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and
> each click on a table takes again ages until the rows are shown. Even paging takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in total max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show 40-50 rows !
> I have reorganized the DB, but that does not help at all for the performance.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and the live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, then I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anything special these last
> days. And more importantly, how do I get back to the previous status, where everything was real
> quick ? I just can't work properly anymore if every single click is taking minutes !!!
> Thanks for help.
> Bernard|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
The ldf file is a part of the database. You can't get rid of it. If you consider it being too large,
then you should read in Books Online about recovery model and decide whether or not you want to do
regular transaction log backups. If you have had the db in full recovery model and not been doing
regular transaction log backups and have a very large ldf file, you can shrink it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate it ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:
>> Sound like someone has turned on ODBC tracing.

HELP ! Suddenly, terribly slow SQLServer Enterprise Manager

Hi,
I am using SQLServer on my development laptop, and it's running without
any problems since at least 6 or 7 months. Suddenly, since yesterday,
when I start the Entreprise Manager, it takes absolute AGES (minutes,
with a very intensive disk activity) until it shows the console root,
and each click on a table takes again ages until the rows are shown.
Even paging takes now 10 times longer as before. My DB is very snmall,
something like 50,000 rows in total max. A double click on the table
icon of the largest table (20,000 rows) takes 2 MINUTES to complete ! A
click on the "Run" icon in the tool bar takes more than 10 seconds to
complete, to show 40-50 rows !
I have reorganized the DB, but that does not help at all for the
performance.
I noticed that the log file is 76 Megabytes whereas the DB after
shrinking is only 8 Meg. I have done a backup of the log file, but it is
only a ridicule 196 KBytes, and the live log is just as big as before !
The very strange thing is that, if I log as another user on my laptop,
then I have the normal speed in Enterprise Manager. How is that possible ?
What's going on ? Why suddenly, where I can't remember having done
anything special these last days. And more importantly, how do I get
back to the previous status, where everything was real quick ? I just
can't work properly anymore if every single click is taking minutes !!!
Thanks for help.
BernardSound like someone has turned on ODBC tracing.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:%230mAl35kFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am using SQLServer on my development laptop, and it's running without an
y problems since at
> least 6 or 7 months. Suddenly, since yesterday, when I start the Entrepris
e Manager, it takes
> absolute AGES (minutes, with a very intensive disk activity) until it show
s the console root, and
> each click on a table takes again ages until the rows are shown. Even pagi
ng takes now 10 times
> longer as before. My DB is very snmall, something like 50,000 rows in tota
l max. A double click on
> the table icon of the largest table (20,000 rows) takes 2 MINUTES to compl
ete ! A click on the
> "Run" icon in the tool bar takes more than 10 seconds to complete, to show
40-50 rows !
> I have reorganized the DB, but that does not help at all for the performan
ce.
> I noticed that the log file is 76 Megabytes whereas the DB after shrinking
is only 8 Meg. I have
> done a backup of the log file, but it is only a ridicule 196 KBytes, and t
he live log is just as
> big as before !
> The very strange thing is that, if I log as another user on my laptop, the
n I have the normal
> speed in Enterprise Manager. How is that possible ?
> What's going on ? Why suddenly, where I can't remember having done anythin
g special these last
> days. And more importantly, how do I get back to the previous status, wher
e everything was real
> quick ? I just can't work properly anymore if every single click is taking
minutes !!!
> Thanks for help.
> Bernard|||THANK YOU ! I DID turn it on, and did not see any log at all coming up,
so I thought it had not worked and totally forgot about it !
Yes, now my Enterprise Manager is back to normal.
You made my day ! Sometimes, it's so simple...
Ah, what a relief it is...
And what about my <database>_Log.LDF file ? How do I get rid of/truncate
it ?
Regards, and thanks again.
Bernard
Tibor Karaszi wrote:
> Sound like someone has turned on ODBC tracing.
>|||> And what about my <database>_Log.LDF file ? How do I get rid of/truncate i
t ?
The ldf file is a part of the database. You can't get rid of it. If you cons
ider it being too large,
then you should read in Books Online about recovery model and decide whether
or not you want to do
regular transaction log backups. If you have had the db in full recovery mod
el and not been doing
regular transaction log backups and have a very large ldf file, you can shri
nk it using DBCC
SHRINKFILE. Also check out http://www.karaszi.com/SQLServer/in...ver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"bthouin" <bernard_thouin@.bluewin.com> wrote in message
news:OKNqi36kFHA.2472@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> THANK YOU ! I DID turn it on, and did not see any log at all coming up, so
I thought it had not
> worked and totally forgot about it !
> Yes, now my Enterprise Manager is back to normal.
> You made my day ! Sometimes, it's so simple...
> Ah, what a relief it is...
> And what about my <database>_Log.LDF file ? How do I get rid of/truncate i
t ?
> Regards, and thanks again.
> Bernard
>
> Tibor Karaszi wrote:

Help - MS SQL 7.0 Enterprise Manager Error

Please, Take al ook at this picture attached and the name of the server.
There is one "zig-zag" vertical line inserted right before the server name.
What does it mean?
Thanks.
eddieRE:
Please, Take a look at this picture attached and the name of the server.
There is one "zig-zag" vertical line inserted right before the server name.

Q1 What does it mean? Thanks. eddie

A1 Symbols in that area of EM generally refer to connection / service status, (the "zig-zag" refers to the current EM connection status).

Help - Formulas with Functions across Databases

I'm trying to build a table that uses a formula with a function in another database on the same server group. Enterprise Manager validates the formula, then when I save the table, an ODBC error pops up stating that the function is an invalid object name. I'm calling the function in the formula as follows: ([OtherDatabase].[dbo].[FunctionName](parameters)). Any ideas?

-- JakeAre you running at least sp2 ?

-PatP|||Yes, I'm running SP2.

-- Jake|||I know that certain situations do force you to use cross-database DML. But if you're creating a calculated field (is that what you're trying to do?) with a function in another database this means that both databases, AND THEIR NAMES (!!!) must go together, right? Why don't you move the function to the same database as the table? And if the function does reference objects in another database, then it would be transparent for the table. If you want to apply "reusability" and you happen to have a table(-s) in another database that has a calculated field that utilizes the same function, then you can just reference that function within the function wrapper.|||The Database I'm working on is a template that will be replicated for numerous individual projects, so I'm trying to reduce the number of locations the generalized Function code will be stored in. Otherwise, I was curious why I can put ([OtherDatabase].[dbo].[FunctionName](parameters)) in a View (for example) and get the desired result, yet have it not recognize the object when said code is placed in the Formula field (even after it supposedly validates the code). If I'm missing something syntax-wise, please let me know.