Error

SQL Report Server ERROR: The number of requests for domain\jermsmit has exceeded the maximum number allowed for a single user

It’s always simple when you see a error message you know.  This time its with SQL Server Report Server.  Error Message: The number of requests for domain\jermsmit  has exceeded the maximum number allowed for a single user

What does that mean?

Well to keep it simple.  The user is running a report which requires far more request that the report server is configured to handle.

So what do you do about this?

One thing would be to isolate the issue and find out why so many requests are being made and perhaps re/wright the report.  Hahaa! Joke!  That doesn’t happen often now does it.

So what will happen is this:

On the report server navigate to the following path:  C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer  *your install path may be different*

Locate the XML configuration file rsreportserver.config

Open the configuration file with notepad.

Press Crtl F and search for MaxActiveReqForOneUser you may get a result such as ‘<Add Key=”MaxActiveReqForOneUser” Value=”20″/>

Change the value to the number of request being made to remove this issue.  Then again if you didn’t correct the above throw some crazy value to it like 256 and call it a day.

What the trade off?

You just use more system resources:  cpu, memory.

More details

Being that these type of request should happen quickly; this may be a sign that something is hogging CPU and SQL time running reports. You should evaluate this rather than just tossing resources at the issue.

Ref:  RSReportServer Configuration File

– Jermal

 

Remove database from read only mode, error 5120

I posted about setting a Microsoft SQL Database into ‘read only’ mode as part of an upgrade. Today I need to go back and make some changes on the now legacy system.

To handle this request I needed to change back to its normal state, this is when I encountered the error 5120.

In the additional information of this error it tells me that an exception occurred while executing a Transact-SQL statement or batch.

Later indicating that it was unable to open the physical file to the database in question due to an “Operating system error 5”

Have fun searching for that *hint* you will not find any of the top 3 links taking you to any Microsoft Site; that’s for sure.  {{annoyed}}

Other errors indicated where insufficient memory or disk space; thanks again {{annoyed}} for sending me  down the wrong path.  I have plenty of memory, and disk space.

The last one was that I did not have permissions to the files. Seriously, I do have permissions. In most cases someone who’s doing this work does in the first place

So I found out what the issue was in my case. Here is a screenshot:

Yup! The files were set to read-only. Once this attribute was removed I was able to change my database status from read-only to read-write.

I hope this post helps you if in similar situation.

– Jermal

Custom Certificate Request Errors with 0x80094801

In my attempt to submit a CSR for an internally generated Subject Alternative Name Certificate. I encountered the follow issue when attempting to submit it to my domain’s CA

I am using the ‘certreq’ method to enroll the new request.  Info on how to do this, found here: http://technet.microsoft.com/en-us/library/ff625722(v=ws.10).aspx#BKMK_CertEnroll

Each attempt I got the following message:

Certificate not issued (Denied) Denied by Policy Module 0x80094801, The request does not contain a certificate template extension or the CertificateTemplate request attribute.

The request contains no certificate template information. 0x80094801 (-214687591)

Certificate Request Processor: The request contains no certificate template information. 0x80094801 (-2146875391)

Denied by Policy Module 0x80094801, The request does not contain a certificate template extension or the CertificateTemplate request attribute.

It seems that this custom template was not listed in my certificate authority; but I knew its purpose was for a web server. So by opening the command prompt into the directory of my request file, ran the following command:

certreq -submit -attrib “CertificateTemplate:WebServer” <request.req> 

I was prompt for the CA Server name and after selecting it my request was processes and I was issued my certificate.

 

Uninstall of SQL fails with error about RsFx Driver

I was working on uninstalling installations of SQL 2012 and SQL 2008 R2 to later do a clean install of SQL 2012. All seems to be going relatively smooth until I encountered the following message:

Warning 26003. Microsoft SQL Server 2008 R2 Setup
Support Files cannot be uninstalled because the
following products are installed:
Microsoft SQL Server 2008 R2 RsFx Driver

Understandable; So I will uninstall using Control Panel\Programs\Programs and Features (Add/Remove for the old school). However the item wasn’t listed. After searching on how to do this using the registry I found a simpler way, I am now calling it a clean and #jermsmit supported way to doing this.

Steps to correct this issue:

We need to obtain the product GUID from WMI using WMIC so that we can use the MSIEXEC /X {GUID} command to remove the software.

Open a command prompt as administrator and type: WMIC PRODUCT LIST to get a list of products and the GUID associated with them. I found using the following command works best: WMIC PRODUCT GET Caption, IdentifyingNumber > c:\info.txt 

Once you have the GUID of the software you want to uninstall you simply type: MSIEXEC /X {GUID}

Software is now uninstalled and you can proceed.

*note* the steps provided can be used for any software you are looking to uninstall that is not listed under Add/Remove programs. Just follow the steps as such:

  1. Get the product GUID from WMI (Win32_Product class)
  2. Find the GUID related to the product or products that the SQL error mentions
  3. Run MSIEXEC /X {GUID} for each of the products to uninstall them manually.

 

I hope you enjoyed this post
Please visit me on Facebook @ http://www.facebook.com/jermsmitcom & via twitter: #jermsmit

YouTube Down – 500 Internal Server Error

It seems like YouTube is down for the last 30 min’s for me. In all the years I have used it; never once have I experienced this. When I navigate to the site I get the following:

500 Internal Server Error

Sorry, something went wrong.

A team of highly trained monkeys has been dispatched to deal with this situation.

If you see them, show them this information:
eSZUMKtL1ZFrtJ_feB_DWuGgdvkLGYqq1fo3SQOzrHxJqRaRb36NdTuH5Sb9
gGFT6ck4vv4PURpfNPGGTw9uJ3r8TUYdqrPoRPmyIw5tF0sfXxxMS580plfz
OnBOnCgLGuGopGxO2eBofn-uY_uG4Gpryo4IBJhC263rbGIn5NIaV_CUU29J
TX0JRwPd3gkBHNBeWZ66W5N5Hi2xeRAZz2-8l2vBwEaqi8XFxmCeHbps6m1q
ncX8Woqj6zRXBsk0OszxhkDZsBjS4lmPGMHGE2VhSZ4qaR0R

Here are the tail end of my network trace:

6 he-0-12-0-0-pe03.111eighthave.ny.ibone.comcast.net (68.86.83.106) 21.775 ms 16.708 ms 21.645 ms
7 23-30-206-126-static.hfc.comcastbusiness.net (23.30.206.126) 14.415 ms 22.714 ms 22.677 ms
8 209.85.248.178 (209.85.248.178) 24.166 ms 23.137 ms 24.786 ms
9 72.14.237.252 (72.14.237.252) 23.129 ms 23.138 ms 23.075 ms
10 lga15s34-in-f6.1e100.net (173.194.43.6) 22.389 ms 22.850 ms 22.569 ms

I had reached out to the public community and it seems like many others also are experiencing the same.
After checking this issue, it seems like the mobile app of YouTube is also down.