SSRS no longer working. Damn 😦
I got this error a few days ago when trying to connect to my local SQL Server Reporting Services. I only wanted to test some functionality and was annoyed that this prevented me from doing so easily.
I was a little perplexed though, as it has been working fine every other time I have used it, however, I don’t use it very often on the local machine.
So why was it suddenly not working?
The error reported was
A user name and password are being requested by http://:. The site says: “XDB”
The last bit of the error message holds the key and is the only useful part of the message
The site says: “XDB”
What is this? It’s not a Microsoft error message. The answer is…
The problem is because Oracle has hijacked the port number that SSRS was on for its Oracle Database XE 11.2 database manager. Because I run Apache locally on port 80, my SSRS runs from port 8080.
I had installed Oracle 11g a couple of weeks ago but not got round to using it yet. I had pretty much forgotten that I had installed it. In typical Oracle style they have just blatantly used a port without checking if it is in use beforehand. In-fact I would guess that they probably check port 80 and if it is not available they just assume 8080 will be. (Can’t guarantee that’s what they are doing but it wouldn’t surprise me – These oracle people really are a bunch of numpties at times).
Anyway, I have changed my SSRS to run on a more obscure port number now and it works again. I had thought of changing the port for Oracle but doubtless it would happened again at some point (during an update or perhaps another vendor).
How hard can it be to put a check like this in the install / configuration code?
Sorry but unlike my other posts which are generally informative, this one is pretty much just a rant. Hopefully it will help someone else out there with the same issue though.
My advice to anyone thinking of using port 8080 is – don’t be so obvious. other people will do the obvious thing so maybe you should do something a little out of the ordinary. now what might me a good port number?
SSRS working again. 🙂