Friday, March 30, 2012
i Get rsReportServerNotActivated error message although it is activated.
I get this error when I want to view a report in a browser:
Reporting Services Error
----
--
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
----
--
Microsoft Reporting Services
But when I run rsactivate I get the following message:
Failure initializing remote NT Service:
The service is already activated
Any suggestions?
My OS is WinXP Pro if it is of any use.Problem solved - uninstall an re-install did the trick.
"Howzit" <hrbotha@.absa.co.za> wrote in message
news:OW2Sn8PZEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> I get this error when I want to view a report in a browser:
> Reporting Services Error
> ----
--
> --
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> ----
--
> --
> Microsoft Reporting Services
> But when I run rsactivate I get the following message:
> Failure initializing remote NT Service:
> The service is already activated
> Any suggestions?
> My OS is WinXP Pro if it is of any use.
>
Wednesday, March 28, 2012
I did So..
dear sir,
i am facing problem while making perspectives in sql server2005(Analysis Services) through C#.perspectives are made well but cant update within a Cube...i mean cant be added to a cube... i dont know what is the problem.so if someone can help me in this regard i will be really thankful to u.
Thanks.
Hi,
I would suggest you to post this question in any of the ADO related or SQL Services (Analysis Services) related forums.
There you should find a quick answer to your question.
Rgds,
Rodrigo
|||dear sir,
i did post it on many of other forums like code project and microsoft india...but i dont know i got no clear response.anyhow thanks alot for giving me time and considering my problem...
thanks.
Adnan Khan.
|||Moved to SQL Server Analysis Services forum.
Thanks.
|||First question comes to mind after reading about your problem.
After creating perspective object did you do something like cube.Update(UpdateOptions.ExpandFull) ?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
dear sir,
thanks alot sir....i did appy ur option is working perfectly...thanks alot sir.....i am really happy for ur help...all my senior developers are shocked when i told then that i have done it......thanks alot sir....
Adnan khan..
|||Edward,
Can you point us to anywhere that details what the three ProcessingOptions enum values actually mean?!?!
Thanks,
Steve.
|||In following whitepaper you will find a table with processing options for Analysis Services objects
http://msdn2.microsoft.com/en-us/library/ms345142.aspx
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Edward, I appreciate the link and the information contained within. I would still like to see the documentation (BOL) covering items such as the UpdateOptions enumerator (values of Default, AlterDependants and ExpandFull) as well as the UpdateMode. Both of these have a column labeled 'Description' in BOL next to the enum values but these columns aren't populated. It tends to make coding against AMO a little hit and miss as to the intended outcome and actual outcome.
Thanks again,
Steve.
|||well i am here find out how can i add or load pictures to a dll..i mean when i add that dll to a project all those images should me added also....i hope u will help me....
Thanks...
Adnan Khan.
sqlMonday, March 26, 2012
I cant seem to install reporting and business intelligence services, is this disabled for expres
Setup gives me the option, I choose these services, it tells me they are already installed, but they are not?
does it then also give you the option to 'upgrade' them after you hit next?
if not, try going to add/remove programs and hit the change button for sql, it should prompt you for what items to remove, see if you can remove RS.
|||What makes you think it is not installed?
Mike
I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
SpinSQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.|||I do not have such a directory named 'SQLRSEVAL' on my CD.
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>|||Anyone?
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
>|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:
>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.|||Is it a free download?
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.
4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/...displaylang=en,
or order the U.S. and Canadian retail version here
[url]http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx[/
url]
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.
4ax.com...
>
I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
--
SpinSQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.|||I do not have such a directory named 'SQLRSEVAL' on my CD.
--
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>|||Anyone?
--
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
>> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
>> order to set it up, you have to install dot net frame work and also
>> Service pack of SQLServer >=SP3a.You also have to reset IIS
>> configuration.Windows(OS) CD is also required in this process.
>> BYE.
>|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:
>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.|||Is it a free download?
--
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en,
or order the U.S. and Canadian retail version here
http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
>> Reporting Services is a separate download, install for SQL
>> 2000. It's not on the CD.
>> Reporting Services for 2005 on is on CD 1. Why are you
>> looking for where it specifically is on the CD? You just run
>> the setup program and chose the components you want to
>> install. If reporting services did not install, you probably
>> didn't have IIS installed or running when you ran the
>> install.
>
I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
Spin
SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.
|||I do not have such a directory named 'SQLRSEVAL' on my CD.
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegr oups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>
|||Anyone?
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegr oups.com...
>
|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:
>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
|||Is it a free download?
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.
|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/d...isplaylang=en,
or order the U.S. and Canadian retail version here
http://www.microsoft.com/sql/prodinf...lfillment.mspx
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
>
sql
Friday, March 23, 2012
I can't get email notification to work
been no response, and I now see that it doesn't get much use. So here it is
again:
I have been given the job of database administrator. I very good at SQL
programming, but am just learning about things like backups, replication,
etc. and am VERY shaky on anything involving network administration. I am
not the one who installed Sql 2005 database, so I don't know if any steps
were missed.
Email notification does not work, and I don't know if it ever did. I have
to remember to run a CheckJobs script periodically because the system is not
going to tell me if something goes wrong.
I would like to get this working, but I don't know where to start. The
70-431 Training Kit says that Database Mail must be enabled through the SQL
Server Surface Area Configuration tool, but when I open that up, I have no
idea what I'm supposed to do.
I also went through the Database Mail Configuration Wizard; no error
messages but also no messages coming through my email. When I view the
history, I see a lot of failures, but nothing that tells me why.
How do I fix this?
Also, could the failure in email notification be connected to the fact that
I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
fixing one problem will fix both? I was really surprised when I failed in
this simple exercise, since I had no problem setting up a linked server while
working on a client system a couple of years back. I also bombed in my
endpoint exercises, but that's something that's completely new to me.Fire up SQL Server Surface Area Configuration tool and click on Surface Area
Configuration for Features. Find your instance and click on it. Expand
"Database Engine" and go to Database Mail. Enable it and then restart your
SQL Server service using SQL Server Configuration Manager.
Open up SSMS (Management Studio) and connect to your instance. Go to
Management and right click on Database Mail it. Choose Configure Database
Mail.
Set up Database Mail. Create a Profile, and then create an account.
Determine if it's gonna be a public or private profile. Profiles are either
public or private. A private profile is accessible only to specific users or
roles. A public profile allows any user or role with access to the mail host
database (msdb) to send e-mail using that profile.
Right click on Database Mail again and try a test mail.
If it works without any problem, then you can use this notification method
for your jobs or whatever.
P.S.
Ensure the data you enter for account configuration is correct and works
fine.
--
Ekrem Ã?nsoy
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:C00E859A-B110-4FCC-B22A-2F7A69AE732D@.microsoft.com...
>I posted this on the Sql Server Notification Services newsgroup, but
>there's
> been no response, and I now see that it doesn't get much use. So here it
> is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I
> am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is
> not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the
> SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact
> that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like
> maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server
> while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Hi Bev
I assume that you are alerting an operator when the job has completed/failed
etc?
Ekrem has described setting up database, but you description implies that it
has already been configured? Do you get any information in the database mail
log ( right click the database mail node and view the log) ?
It could be that your firewall is not configured correctly, can you ping and
telnet to the smtp relay (I assume that you are not using SQL Mail!).
If database mail is working, you may want to try and create a new operator
and see if they can be emailed notifications.
John
"Bev Kaufman" wrote:
> I posted this on the Sql Server Notification Services newsgroup, but there's
> been no response, and I now see that it doesn't get much use. So here it is
> again:
> I have been given the job of database administrator. I very good at SQL
> programming, but am just learning about things like backups, replication,
> etc. and am VERY shaky on anything involving network administration. I am
> not the one who installed Sql 2005 database, so I don't know if any steps
> were missed.
> Email notification does not work, and I don't know if it ever did. I have
> to remember to run a CheckJobs script periodically because the system is not
> going to tell me if something goes wrong.
> I would like to get this working, but I don't know where to start. The
> 70-431 Training Kit says that Database Mail must be enabled through the SQL
> Server Surface Area Configuration tool, but when I open that up, I have no
> idea what I'm supposed to do.
> I also went through the Database Mail Configuration Wizard; no error
> messages but also no messages coming through my email. When I view the
> history, I see a lot of failures, but nothing that tells me why.
> How do I fix this?
> Also, could the failure in email notification be connected to the fact that
> I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> fixing one problem will fix both? I was really surprised when I failed in
> this simple exercise, since I had no problem setting up a linked server while
> working on a client system a couple of years back. I also bombed in my
> endpoint exercises, but that's something that's completely new to me.|||Since I'm not allowed to make changes during normal working hours, and I
can't stay late tonight, I will tackle these suggestions tomorrow night.
I do not know if the database mail has already been configured. I also
don't know if the problem lies in our firewall, but we've had problems with
it before in terms of it being way too restrictive. There was a time when it
blocked us from accessing even our own website, which put a real crimp in my
job as website administrator.
So, how do I "ping and telnet to the smtp relay?"
"John Bell" wrote:
> Hi Bev
> I assume that you are alerting an operator when the job has completed/failed
> etc?
> Ekrem has described setting up database, but you description implies that it
> has already been configured? Do you get any information in the database mail
> log ( right click the database mail node and view the log) ?
> It could be that your firewall is not configured correctly, can you ping and
> telnet to the smtp relay (I assume that you are not using SQL Mail!).
> If database mail is working, you may want to try and create a new operator
> and see if they can be emailed notifications.
> John
>
> "Bev Kaufman" wrote:
> > I posted this on the Sql Server Notification Services newsgroup, but there's
> > been no response, and I now see that it doesn't get much use. So here it is
> > again:
> >
> > I have been given the job of database administrator. I very good at SQL
> > programming, but am just learning about things like backups, replication,
> > etc. and am VERY shaky on anything involving network administration. I am
> > not the one who installed Sql 2005 database, so I don't know if any steps
> > were missed.
> > Email notification does not work, and I don't know if it ever did. I have
> > to remember to run a CheckJobs script periodically because the system is not
> > going to tell me if something goes wrong.
> > I would like to get this working, but I don't know where to start. The
> > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > Server Surface Area Configuration tool, but when I open that up, I have no
> > idea what I'm supposed to do.
> > I also went through the Database Mail Configuration Wizard; no error
> > messages but also no messages coming through my email. When I view the
> > history, I see a lot of failures, but nothing that tells me why.
> > How do I fix this?
> > Also, could the failure in email notification be connected to the fact that
> > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > fixing one problem will fix both? I was really surprised when I failed in
> > this simple exercise, since I had no problem setting up a linked server while
> > working on a client system a couple of years back. I also bombed in my
> > endpoint exercises, but that's something that's completely new to me.|||Hi Bev
ping and telnet are command line utilities, you can find information about
them in the windows help. Commands such as netstat and nslookup may also be
useful. You may want to get the network and firewall guys to check the logs
whilst you attempt to send mail. You may have to get through more than one
firewall.
As far as database mail configuration goes I suggest you find a test machine
that has not got it configured or a machine you can set up SQL Server on and
go through the actions of configuring it so that you are familiar.
John
"Bev Kaufman" wrote:
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems with
> it before in terms of it being way too restrictive. There was a time when it
> blocked us from accessing even our own website, which put a real crimp in my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
> > Hi Bev
> >
> > I assume that you are alerting an operator when the job has completed/failed
> > etc?
> >
> > Ekrem has described setting up database, but you description implies that it
> > has already been configured? Do you get any information in the database mail
> > log ( right click the database mail node and view the log) ?
> >
> > It could be that your firewall is not configured correctly, can you ping and
> > telnet to the smtp relay (I assume that you are not using SQL Mail!).
> >
> > If database mail is working, you may want to try and create a new operator
> > and see if they can be emailed notifications.
> >
> > John
> >
> >
> > "Bev Kaufman" wrote:
> >
> > > I posted this on the Sql Server Notification Services newsgroup, but there's
> > > been no response, and I now see that it doesn't get much use. So here it is
> > > again:
> > >
> > > I have been given the job of database administrator. I very good at SQL
> > > programming, but am just learning about things like backups, replication,
> > > etc. and am VERY shaky on anything involving network administration. I am
> > > not the one who installed Sql 2005 database, so I don't know if any steps
> > > were missed.
> > > Email notification does not work, and I don't know if it ever did. I have
> > > to remember to run a CheckJobs script periodically because the system is not
> > > going to tell me if something goes wrong.
> > > I would like to get this working, but I don't know where to start. The
> > > 70-431 Training Kit says that Database Mail must be enabled through the SQL
> > > Server Surface Area Configuration tool, but when I open that up, I have no
> > > idea what I'm supposed to do.
> > > I also went through the Database Mail Configuration Wizard; no error
> > > messages but also no messages coming through my email. When I view the
> > > history, I see a lot of failures, but nothing that tells me why.
> > > How do I fix this?
> > > Also, could the failure in email notification be connected to the fact that
> > > I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe
> > > fixing one problem will fix both? I was really surprised when I failed in
> > > this simple exercise, since I had no problem setting up a linked server while
> > > working on a client system a couple of years back. I also bombed in my
> > > endpoint exercises, but that's something that's completely new to me.|||Click Start-Run and enter 'cmd' to get a DOS prompt from the computer you
are trying to send email from.
C: \> ping your.mailserver.com
Did it get through, or did you lose the packets. Did it resolve the IP
address correctly?
Assuming that you're sending email via SMTP and that the mail server is
using the default mail port of 25 ...
C:\> telnet your.mailserver.com 25
A fail looks like:
Connecting To your.mailserver.com...Could not open connection to
the host, on port 25: Connect failed
On success, you will get a message and the cursor will be on the left side
of the creen (no prompt). Enter (I think) HELO and see if you get a
response. If so, you are connected to the mail server.
Jay
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:9C1D3DB5-AB2E-4C81-BAD0-3B9A95739CF9@.microsoft.com...
> Since I'm not allowed to make changes during normal working hours, and I
> can't stay late tonight, I will tackle these suggestions tomorrow night.
> I do not know if the database mail has already been configured. I also
> don't know if the problem lies in our firewall, but we've had problems
> with
> it before in terms of it being way too restrictive. There was a time when
> it
> blocked us from accessing even our own website, which put a real crimp in
> my
> job as website administrator.
> So, how do I "ping and telnet to the smtp relay?"
> "John Bell" wrote:
>> Hi Bev
>> I assume that you are alerting an operator when the job has
>> completed/failed
>> etc?
>> Ekrem has described setting up database, but you description implies that
>> it
>> has already been configured? Do you get any information in the database
>> log ( right click the database mail node and view the log) ?
>> It could be that your firewall is not configured correctly, can you ping
>> and
>> telnet to the smtp relay (I assume that you are not using SQL Mail!).
>> If database mail is working, you may want to try and create a new
>> operator
>> and see if they can be emailed notifications.
>> John
>>
>> "Bev Kaufman" wrote:
>> > I posted this on the Sql Server Notification Services newsgroup, but
>> > there's
>> > been no response, and I now see that it doesn't get much use. So here
>> > it is
>> > again:
>> >
>> > I have been given the job of database administrator. I very good at
>> > SQL
>> > programming, but am just learning about things like backups,
>> > replication,
>> > etc. and am VERY shaky on anything involving network administration.
>> > I am
>> > not the one who installed Sql 2005 database, so I don't know if any
>> > steps
>> > were missed.
>> > Email notification does not work, and I don't know if it ever did. I
>> > have
>> > to remember to run a CheckJobs script periodically because the system
>> > is not
>> > going to tell me if something goes wrong.
>> > I would like to get this working, but I don't know where to start. The
>> > 70-431 Training Kit says that Database Mail must be enabled through the
>> > SQL
>> > Server Surface Area Configuration tool, but when I open that up, I have
>> > no
>> > idea what I'm supposed to do.
>> > I also went through the Database Mail Configuration Wizard; no error
>> > messages but also no messages coming through my email. When I view the
>> > history, I see a lot of failures, but nothing that tells me why.
>> > How do I fix this?
>> > Also, could the failure in email notification be connected to the fact
>> > that
>> > I can't set up a linked server to the Sql 2000 Server on my PC? Like
>> > maybe
>> > fixing one problem will fix both? I was really surprised when I failed
>> > in
>> > this simple exercise, since I had no problem setting up a linked server
>> > while
>> > working on a client system a couple of years back. I also bombed in my
>> > endpoint exercises, but that's something that's completely new to me.
Wednesday, March 21, 2012
I can't add a new Reporting Services server registration of a remote server.
I need a help.
This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.
Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.
From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.
On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!
Is this a systemistic, configuration issue? Some advice to solve it?
Thank you in advance.
Marina B.
So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||
Hi,
thank you for the answer.
Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...
At the end I was able to solve the problem enabling the SQL server Agent and Browser!!
Thank you
Marina B.
sqli cant activate the report
I set up a enviroment of report services:
windows 2000+mssql 2000+vs.net 2003+report service.
after finished installing the report ,it told me cant activate
automatically,
i should activate the report service by hand,
so i fount the command in help file: rsacivate command
so
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer>reac
tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report
Server\rsreportserver.config" -t
and it shows:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548)
0x80004002 -->
System.Exception: 0x80004002
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
any1 can help me out.
thank youHi Asher!
Did you find a solution?
I have the same problem too and i noticed other users with this problem,
nobody has found a solution til now...
I'd appreciate help from microsoft staff on this topic.
I'm on Windows 2000
MDAC 2.8 SP1
SQL Server 2000 SP4, with all the Service Packs for Reporting Services
installed.
--
ErrorMessage when executing rsactivate -c"C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
--
Error Message when executing rskeymgmt -d -t:
System.Exception: Unexpected database error (-2147159548) 0x80040154
-->
System.Exception: 0x80040154
-- End of inner exception stack trace --
at Microsoft.ReportingServices.RSKeyMgmt.RSKeyMgmt.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)
Thx for any help
yara
"Asher Wu" wrote:
> Hi all
> I set up a enviroment of report services:
> windows 2000+mssql 2000+vs.net 2003+report service.
> after finished installing the report ,it told me cant activate
> automatically,
> i should activate the report service by hand,
> so i fount the command in help file: rsacivate command
> so
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer>reac
> tivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Report
> Server\rsreportserver.config" -t
> and it shows:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548)
> 0x80004002 -->
> System.Exception: 0x80004002
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
>
> any1 can help me out.
> thank you
>
>
I can't access a report by URL
I'm new at using Report Services and I don't understand what I am
supposed to do to access a report by URL.
For the moment, I'm still working on report samples and I try to
create an URL access to Employee Sales Summary. I've made a small web
page with this link:
<a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
Reports/Employee Sales
Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
direct</a>
It accesses the page but asks me for the parameters as if they were
not in the url.
The real goal behind this is to access to the report using a
multiple-values parameter for the Employee ID. As it doesn't seem to
be possible from the basic interface of Report Sevices, I thought I
could make a form and then pass the list in the parameters and making
the "where" clause like this in the report:
where SalesPersonID IN (@.EmpID)You should use the report server URL not the Report Manager URL.
So try this:
http://localhost/reportsever?/Sample&rs:Command=Render
The full documentation on how to do this is available in Books online (also
on MSDN). Search for URL Access.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407190102.cb43a71@.posting.google.com...
> Hi every body,
> I'm new at using Report Services and I don't understand what I am
> supposed to do to access a report by URL.
> For the moment, I'm still working on report samples and I try to
> create an URL access to Employee Sales Summary. I've made a small web
> page with this link:
> <a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
> Reports/Employee Sales
> Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
> direct</a>
> It accesses the page but asks me for the parameters as if they were
> not in the url.
> The real goal behind this is to access to the report using a
> multiple-values parameter for the Employee ID. As it doesn't seem to
> be possible from the basic interface of Report Sevices, I thought I
> could make a form and then pass the list in the parameters and making
> the "where" clause like this in the report:
> where SalesPersonID IN (@.EmpID)|||Thanks a lot!
It did work :) .
But actually, it was only the first step of my tests and I have now a
new issue.
As I have explained earlier (I think I did...), I need a multi-value
field parameter. This is the only reason why I'm making this html
page.
For the moment, the single value field works but I can't make it with
a multi-value field. It seems that my query is simply not good.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (@.EmpId))
I also tried to test the syntax of the list in the parameter, using
this query:
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (20,21))
and then I tried
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN ('20','21'))
The report appears empty (the value 20 and 21 are good and the report
parameter is an integer).
Any Idea of how I should do?|||Jocelyn,
You can't use a variable in an IN clause. You need to use a Function like
the one below and either JOIN to it or use a nested SELECT.
e.g.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
INNER JOIN dbo.fnIntList(@.EmpId) ON EmployeeID=Value
brian
---
CREATE FUNCTION dbo.fnIntList ( @.InputString varchar(2000) )
RETURNS @.IntList TABLE (Value int)
AS
BEGIN
DECLARE @.Temp int
DECLARE @.Delimiter varchar(1)
SET @.Delimiter = ','
-- remove any surrounding spaces
SET @.InputString = RTRIM(LTRIM(@.InputString ))
WHILE (CHARINDEX(@.Delimiter, @.InputString)) > 0
BEGIN
SET @.Temp = RTRIM(LTRIM(LEFT(@.InputString, CHARINDEX(@.Delimiter,
@.InputString)-1)))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
SET @.InputString = RIGHT(@.InputString, LEN(@.InputString) -
CHARINDEX(@.Delimiter,@.InputString))
END
SET @.Temp = RTRIM(LTRIM(@.InputString))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
RETURN
END
GO
----
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407202353.225402c4@.posting.google.com...
> Thanks a lot!
> It did work :) .
> But actually, it was only the first step of my tests and I have now a
> new issue.
> As I have explained earlier (I think I did...), I need a multi-value
> field parameter. This is the only reason why I'm making this html
> page.
> For the moment, the single value field works but I can't make it with
> a multi-value field. It seems that my query is simply not good.
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (@.EmpId))
> I also tried to test the syntax of the list in the parameter, using
> this query:
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (20,21))
> and then I tried
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN ('20','21'))
> The report appears empty (the value 20 and 21 are good and the report
> parameter is an integer).
> Any Idea of how I should do?
Monday, March 19, 2012
I cannot logon to Http://localhost/reports$sqlexpress
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.
I can't connect to my local database.mdf file
I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2.
Now I can't connect to my local database.mdf file.
When trying to open or doubleclick or expand my .mdf file the following message pops up:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.
What is the solution for this problem?
hi,
by default, User Instances feature is disabled when you install a SQLExpress instance.. the Install Wizard provides an option to enable it at install time, but you can enable it via sp_configure execution as
EXEC sp_configure 'show advanced option', '1'; GO EXEC sp_configure 'user instances enabled','1'; GO RECONFIGURE GO EXEC sp_configure 'show advanced option', '0'; GO(restart the SQLExpress service)
that can be executed both in SqlCmd.exe (command line tool) or in a SQL Server Management Studio Express query window (or even via an ADO/Ado.Net connection)..
you can have a look at all "configurable" options at http://msdn2.microsoft.com/en-us/library/ms189631.aspx
regards
|||Hi Andrea.
I have entered your code in the query editor and saved it as SQLQuery5.sql.
SQL server is restarted.
I right clicked in the query editor and hit Execute and get the folloving error:
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
The problem is still there?...
|||Hi again :)
I right clicked in the query editor and hit Execute again after a while. It works now.
Thanks :)
I can't connect to my local database.mdf file
I have just upgraded to Microsoft SQL Server 2005 Express Edition with Advanced Services SP2.
Now I can't connect to my local database.mdf file.
When trying to open or doubleclick or expand my .mdf file the following message pops up:
Generating user instances in SQL Server is disabled. Use sp_configure 'user instance enabled' to generate user instances.
What is the solution for this problem?
hi,
by default, User Instances feature is disabled when you install a SQLExpress instance.. the Install Wizard provides an option to enable it at install time, but you can enable it via sp_configure execution as
EXEC sp_configure 'show advanced option', '1'; GO EXEC sp_configure 'user instances enabled','1'; GO RECONFIGURE GO EXEC sp_configure 'show advanced option', '0'; GO(restart the SQLExpress service)
that can be executed both in SqlCmd.exe (command line tool) or in a SQL Server Management Studio Express query window (or even via an ADO/Ado.Net connection)..
you can have a look at all "configurable" options at http://msdn2.microsoft.com/en-us/library/ms189631.aspx
regards
|||Hi Andrea.
I have entered your code in the query editor and saved it as SQLQuery5.sql.
SQL server is restarted.
I right clicked in the query editor and hit Execute and get the folloving error:
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
The problem is still there?...
|||Hi again :)
I right clicked in the query editor and hit Execute again after a while. It works now.
Thanks :)
I can not start (initialise) report server status from reporting services configuration ma
I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.
Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)
at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.
Accessing report manager from the browser also throws this exception.
Server Error in '/ReportServer$SQLExpress' Application.
Configuration Error
Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.
Source Error:
[No relevant source lines]
Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
I'm having the same problem and I was just wondering if you managed to get your report server working
|||Okay so I got it working.
I got this solution fromAaron Stebner's blog.
Create a batch file with the following commands:
cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q
Run the batch file
Then run a repair install of SQL reporting services.
And it should come back.
|||
On my side, i got it working by just un-installing and then re-installing reporting services.
Monday, March 12, 2012
I can be connected to services analysis 8.00.194 through HTTP?
Hi
Analysis Services is not a HTTP endpoint, so in SQL 2000, you can not
connect to it using HTTP.
Maybe SQL Server Reporting Services is an option for you.
Regards
Mike
"Maricela" wrote:
> I can be connected to services analysis 8.00.194 through HTTP?
|||My understanding is you ought to be able to connect to analysis service via
HTTP if you're using Enterprise Edition. Just make sure that you have the
msolap.asp file in your web server directory before trying to connect
Nestor
"Maricela" <Maricela@.discussions.microsoft.com> wrote in message
news:ED09850B-71F8-4039-8D7F-8101F4383677@.microsoft.com...
>I can be connected to services analysis 8.00.194 through HTTP?
I broke reporting services (SQL Svr 2005)
Win 2003 test system. Now I can't get reporting services to work. Any
ideas for a fix?I would assume you need to re-install RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dgk" <dgk@.somewhere.com> wrote in message
news:1khqi2hsnaihstjmu9all81vjpc1q60obs@.4ax.com...
> We had to uninstall and reinstall IIS and the dotnet framework on our
> Win 2003 test system. Now I can't get reporting services to work. Any
> ideas for a fix?
I am unable to install updates for SQL Server 2005 Express Edition
2 (KB 921896)
Hi Brent
What error message say and what does the installation log say?
John
"Brent Wilson" wrote:
> Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
> 2 (KB 921896)
I am unable to install updates for SQL Server 2005 Express Edition
2 (KB 921896)Hi Brent
What error message say and what does the installation log say?
John
"Brent Wilson" wrote:
> Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack
> 2 (KB 921896)
I am unable to install SQL Server 2005 on Win XP SP2 box
I get to the point of starting the services and receive the following message after about 4 minutes of trying to start. I tried in Mixed Mode and Windows Authentication Mode. Message:
TITLE: Microsoft SQL Server 2005 Setup
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aWaitForServiceState%40x41d
BUTTONS:
&Retry
Cancel
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||I can find nothing useful in the Windows event log and I guess I do not understand where the sql server log files are.|||For me its located in here:
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG
Could be something different for you depending on your installation.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
here is the log contents of the last attempted installation and of course it timed out while trying to start the service:
2006-05-28 07:37:06.92 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-05-28 07:37:06.92 Server (c) 2005 Microsoft Corporation.
2006-05-28 07:37:06.92 Server All rights reserved.
2006-05-28 07:37:06.92 Server Server process ID is 4776.
2006-05-28 07:37:06.92 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-05-28 07:37:06.94 Server Registry startup parameters:
2006-05-28 07:37:06.94 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-05-28 07:37:06.94 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-05-28 07:37:06.94 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-05-28 07:37:06.94 Server Command Line Startup Parameters:
2006-05-28 07:37:06.95 Server -m SqlSetup
2006-05-28 07:37:06.95 Server SqlSetup
2006-05-28 07:37:06.95 Server -Q
2006-05-28 07:37:06.95 Server -q SQL_Latin1_General_CP1_CI_AS
2006-05-28 07:37:06.95 Server -T 4022
2006-05-28 07:37:06.95 Server -T 3659
2006-05-28 07:37:06.95 Server -T 3610
2006-05-28 07:37:06.95 Server -T 4010
2006-05-28 07:37:06.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-05-28 07:37:06.98 Server Detected 1 CPUs. This is an informational message; no user action is required.
2006-05-28 07:40:49.72 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-05-28 07:40:50.88 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-05-28 07:59:24.50 Server Service control: stop before startup
|||Thanks.....
Property(S): DatabaseReplRes.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\
Property(S): DatabaseReplRes1033.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\
Property(S): SqlVerComBin.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.8B75390F_DF2F_4C2C_92F5_9B83F3B36340 = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBin.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.889BED4C_E3F4_4943_956C_6FFD882F721F = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBin.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\
Property(S): Ver.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\
Property(S): SqlVerComBinRes.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\
Property(S): SqlVerComBinRes1033.CC4DBEA7_CD8B_4AAE_A10F_657CBA390BD6 = C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): SqlStateManaged = 2
Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
Property(S): SOURCEDIR = d:\69a81902561ca8c7a8df\Setup\
Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Property(S): InstallNgenTicks = 110000
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITY\NetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITY\NetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {84AFA01D-0112-4F29-990C-7A3EECC00498}
Property(S): ProductToBeRegistered = 1
MSI (s) (EC:1C) [08:37:27:207]: Note: 1: 1708
MSI (s) (EC:1C) [08:37:27:207]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (EC:1C) [08:37:27:227]: Cleaning up uninstalled install packages, if any exist
MSI (s) (EC:1C) [08:37:27:227]: MainEngineThread is returning 1603
MSI (s) (EC:5C) [08:37:27:337]: Destroying RemoteAPI object.
MSI (s) (EC:D8) [08:37:27:337]: Custom Action Manager thread ending.
=== Logging stopped: 5/28/2006 8:37:27 ===
MSI (c) (78:AC) [08:37:27:377]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (78:AC) [08:37:27:377]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/28/2006 8:37:27 ===
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Friday, March 9, 2012
I am new to this SQL Server Reporting Services. HELP
Hi Friends,
I am working on .Net tech with SQL Server 2000.
I want to update my technical skills to DW.
I mean, i planning to learn SQL Server Reporting Services and i am new this topic.
Please help me........
thanks
babu
my dear friend ,
i am also new to ssrs ... check this link
http://www.crystalreportsbook.com/SSRSandCR_Overview.asp
http://safari.oreilly.com/0596529414
atleast this will give little bit idea abt ssrs... if u get any resources...plz update here.......so that every one will know
u can also use microsoft virtual lab ...But as a beginneer still i am finding a resource for good foundation in ssrs......