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 Stored as Text message.
Hope this helps!
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 Server up again and the SSRS subscriptions would all fail to send their files.
On Windows Server 2008, Simple Mail Transfer is set to manual by default. We need to change it to automatic by doing the following steps:
- Start -> Administrative Tools->Services
- Change Simple Mail Transfer to be Automatic
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 the domain on their notebook because they’re management.
After wasting almost 1/2 an hour trying to figure out why they couldn’t sign in. I realized that the user’s password had expired and that they needed to change their password.
If a single user can’t sign in, it might be wise to check if the password is expired. 🙂