At the end of my rope!

Question

At the end of my rope!

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 1

I think that is a good suggestion. Unfortunately the outsourced IT company that hosts the server won't allow us to install anything. They have to do it all. Which has really put a wrench in the project work. Was hoping to get around this without having to go that route. I have appreciated all your help! Thanks

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

MuchLearnSoLittleTime (7/23/2011)
I think that is a good suggestion. Unfortunately the outsourced IT company that hosts the server won't allow us to install anything. They have to do it all. Which has really put a wrench in the project work. Was hoping to get around this without having to go that route. I have appreciated all your help! Thanks

If you are not even allowed to deploy a report, what on earth are you doing spending your time and ours trying to figure out why the installation is broken? Get them to fix it!

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 3

I just remembered that I took a backup of the database 3 days ago! Will try a restore first.

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 4

I restored the ReportServer and now I can bring up the website! The issue must have been that missing row in the Catalog table.

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 5

I can deploy reports. I just can't install SQL Server and Reporting Services. I was responding to your statement:

"I would say that if you have connectivity and the catalog is empty, then it is worth creating a new RS database.

It sounds like someone has messed with the existing one and it's going to be quicker to create a new one.

MM"

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

TeraByteMe SSCarpal Tunnel Points: 4171 More actions · Answer 6

Wasn't trying to waste you time. Obviously there was a communicate problem. If you are so concerned about your time then why are you on this site responding to posts? I would have appreciated your help a lot more if you didn't come across as aggressive and insulting. Have a great day 🙂

A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 7

MuchLearnSoLittleTime (7/23/2011)
Wasn't trying to waste you time. Obviously there was a communicate problem. If you are so concerned about your time then why are you on this site responding to posts? I would have appreciated your help a lot more if you didn't come across as aggressive and insulting. Have a great day 🙂

When you're up to your ears in alligators and you really need to solve a problem, it's quite easy to take an alternate suggestion the wrong way. The phrase "wasting your time and ours" was probably a poor choice of words and could have been a bit more sugar coated but Maggo was just suggesting that working with the 3rd party vendor might be more productive with this problem.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)