Okay, so you try to search and your getting dreaded “Internal Server error exception” message seen below. This is not very helpful at all. However, the chances are, your search databases have somehow became corrupt To resolve this, I carried out the following steps. Note: All of the below assumes that you have called your [...]
Archive for the ‘SQL’ Category
Getting the Imported SharePoint Id’s from the User Profiles in SharePoint 2010
Posted: 24th March 2011 in Sharepoint 2010, SQL, x64Okay, here’s the scenario: You’ve set up the User Profile Synchronisation using the Microsoft Documentation, and your now at the situation where have the Active Directory Accounts imported into SharePoint. Now, you want to do a data load and match up people picker fields to the actual profiles in the SharePoint format of ID;#FirstName LastName. [...]
The changes you have made require the following tables to be dropped and re-created
Posted: 26th January 2011 in SQLTags: SQL 2008 R2
When trying to change a table using design view SQL 2008 R2 I received the error shown in the screen shot below. I can understand the reason for this, but sometimes when you are in development, its just a pain. So, how do you switch it off? Go to tools –> Options and uncheck Prevent [...]
SSRS 2008 R2 – The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
Posted: 7th October 2010 in SharePoint, SQL, SSRSTags: Sharepoint Integration mode, SSRS
Problem: When using SQL Server Reporting Service SSRS in integration mode with MOSS you come across the following error when trying to deploy reports using BIDS to a Document Library: “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel” This problem is cause by the fact that on a [...]
The correct collation for SharePoint in the English speaking world is Latin1_General_CI_AS_KS_WS. However, if your collation is not set to this is can be changed by running the command below. Note: Don’t make the mistake I did! The Instance name is not the name of the server, but the actual instance. This is MSSQLSERVER by [...]
To allow an earlier version of SQL Server to recognise the data from 2008 it is necessary set the database compatibility level to the correct version. Transact-SQL Method ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 } eg. to use in 2005 run ALTER DATABASE my_db SET COMPATIBILITY_LEVEL = 90 The [...]
Problem: When creating a new stored procedure in SQL 2008 Management Studio the following text displayed in the header of the stored procedure: – Use the Specify Values for Template Parameters – command (Ctrl-Shift-M) to fill in the parameter – values below. However, when you try this nothing happens! Solution: In Management Studio Go to [...]
