SQL Error–Cannot show requested dialog, nColIndex
Posted: 04/10/2010 Filed under: SQL Server | Tags: SQL, SQL Server 3 Comments »
I got this error trying to attach a database in SQL Server 2008 (see image below). After googling binging around with no success, I decided, just by fluke, to try this operation using a different account.
So I logged into SQL Management Studio with another account and tried this again, and voila!, it worked and I got into the database attach dialog with no problems and completed the database attach operation successfully.
I only wish I had more time to commit and look into the cause of this abnormality, but unfortunately I didn’t. An interesting point to note though, is that both the accounts have the same database roles and permissions.
Reporting Services SharePoint Add-In Install Failure
Posted: 09/06/2010 Filed under: Configuration | Tags: SQL, SQL Server 1 Comment »Twice within this month that I’ve come across this problem. Basically, I’ve had Reporting Services (SSRS) install, had SharePoint installed installed and also got SSRS configured to run in SharePoint Integration mode. The final piece of the puzzle is to install the SSRS Add-In for SharePoint.
Clicking on the .msi file begins the installation. Unfortunately, during the “Removing Backups” stage the install seems to just hang there, after a very long time it eventually rolls back and notifies you that the install has failed. Looking into the Event Logs you’ll notice tons of errors relating to SQL and permissions that it lacks, please note, DO NOT waste your time in attempting to update any permissions within your database.
This is a known issue and occurs with both versions of the install (x86 and x64). To get around this follow the steps below:
- Open Command Prompt and navigate to the SSRS Add-In .msi file.
- Type and run the following command msiexec /i SharePointRS.msi SKIPCA=1 (or msiexec /i SharePointRS_x64.msi SKIPCA=1 if installing x64 version)
- After install has completed, navigate to \Users\<Username>\AppData\Local\
- Type and run the following command rscustomaction.exe /i
- Allow the install to complete
If you do encounter any issues during or after running the above then go through the following technical article on TechNet. It’s for SQL 2008 but also applies to SQL 2005.
Truncating SQL Log Files (.ldf)
Posted: 09/06/2010 Filed under: Uncategorized | Tags: SQL, SQL Server 7 Comments »Firstly, I hope you have planned your SharePoint environment capacity and growth rate way before implementation. Now that I’ve said my piece, if you ever come across an environment that is running low on disk space on SQL server then truncating the Log Files (.ldf) will be something to consider. Maybe even create a maintenance plan, that performs this action weekly. To truncate the logs you can execute the script below, which I found on Pinal Dave’s blog, read more about it here.
USE <DatabaseName>
GO
DBCC SHRINKFILE (<LogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE (<LogName>, 1)
GO
If you need to find your <LogName> and it’s size, you can execute the following script prior to truncating the log.
USE <DatabaseName>
exec sp_helpfile
Warning: Please see comments related to this post prior to proceeding with this action. Special thanks to all for their clarification and insight into this.
