Today, while changing a report in SQL Server Reporting Services I noticed that my report when exported to excel was showing the dreaded “Number stored as text.” When a value was 0, I was replacing with a blank string. By changing it to return Nothing. I was able to get rid of the dreaded Number…
I have a few applications that use the Windows SMTP Server to send email or to send email from SQL Server Reporting Services and of course database error notification. Each time the server restarted or IIS crashed neither of which happens often, I would forget I needed to go into IIS6 and start the SMTP…
Today, at the office I had a very interesting issue where a user wasn’t able to sign into the SQL Server Reporting Services Manager. All services and programs make use of our domain controller for authentication to encourage the use of single sign on. This user is that couldn’t sign in, doesn’t actually sign into…