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 […]
Tag: SQL
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 […]
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 […]
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 […]
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 […]
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 […]