Showing posts with label playing. Show all posts
Showing posts with label playing. Show all posts

Wednesday, March 21, 2012

Reinstall problem with Report Services

I have been playing with my Standard version of SQL Server with no problems. Now I wanted to start exploring Reporting Services, however whenever I tried to connect to the instance through the Management Studio, it would fail. I did notice that the folder in IIS was not present so I am thinking it was something I failed to do in the initial setup.

I have uninstalled everything, but when it gets to Reporting Services, I get an error message "The setup failed to read IISMiniMap table. Error Code -2147024893." I did a search on various newsgroups and forums and found a message about installing and running some Microsoft Cleanup utility. I did this, but I am still getting the error message and then the uninstall rolls everything back.

What do I need to do here, short of doing a total reformat of the harddrive and just reinstall everything?

Thanks for the information.

To add to this problem, I uninstalled all that I could with my original instance of SQL Server (minus Reporting Services). Now I have reinstalled a new instance that also created a new instance of Reporting Services. However when I go to IIS, it says that the Report Server is stopped and I cannot restart it. I get the error "The request is not supported".

What is up with this?

Monday, February 20, 2012

Registering a server...

In the past I registered my server with EM no problem, until this morning I
was playing around with it,
*why fix something when it's not broke... Beats head against wall!
This machine is called OFFICE and in the past the server worked fine but
somehow I change the access of it from windows login to another option and
now I cannot get it registered again, I keep getting this:
Connection failure etc...
SQL Server does not exist or access denied.
ConnectionOpen (Connect())
In cmd in have pinged OFFICE and it comes back no problem, I'm thinking
therefore it must be something to do with the login? But I'm using windows
protocol... surelly that's ok?
Please help I'm going out of my mind!
Did you try changing the connection type to "Use Windows Authentication" and
retry?
Steve
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:4AFC1535-8D72-4055-8346-DA6C212B41E5@.microsoft.com...
> In the past I registered my server with EM no problem, until this morning
I
> was playing around with it,
> *why fix something when it's not broke... Beats head against wall!
> This machine is called OFFICE and in the past the server worked fine but
> somehow I change the access of it from windows login to another option and
> now I cannot get it registered again, I keep getting this:
> Connection failure etc...
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> In cmd in have pinged OFFICE and it comes back no problem, I'm thinking
> therefore it must be something to do with the login? But I'm using windows
> protocol... surelly that's ok?
> Please help I'm going out of my mind!