Categories
How-To Software Technical

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 […]

Categories
How-To Software Technical

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 […]

Categories
How-To Software Technical

Set SharePoint Content Database in Read-Only Mode

This weekend I am working on a SharePoint 2010 to 2013 upgrade. One of the steps; the beginning steps I will do is set the databases I am upgrading into read only mode to prevent users or automated process from upgrading the database during the upgrade window. Now I could have taken the system offline […]

Categories
How-To Software Technical

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 […]

Categories
How-To Software Technical

restore sql server database from mdf file

First Open SQL Server Management Studio (SSMS). You may need to run as Administrator Right click the Databases folder and select attach from the menu. Click Add and select the mdf file. Click Ok, and then Click Ok again. You will get an error at this time because SSMS could not find the corresponding ldf […]

Categories
Software Technical

SQL Server Database Error: 661

One of my customers had an issue where they failed to open a connection to a particular database they had been testing. The error read: ‘the database e:somepathsomefolderjermsmit.mdf’ cannot be opened because it is version 611. The server supports version 655 and earlier. A downgrade path is not supported. This issue is caused because you […]