FILESTREAM is a feature of SQL 2008 that supports BLOB file storage on NTFS file shares. This feature is also supported by SharePoint 2010, but first you’ll need to enable the feature in SQL 2008R2 server, default the FILESTREAM feature is disabled during the SQL 2008 installation. To enable FILESTREAM feature on SQL Server 2008: Open … Continued
Featured blog @ Blogsearchengine
Just got my blog reviewed by the Blogsearchengine, read what they have to say about this blog: iDocs is for the IT professional who does not have to ask what SharePoint and SQL mean. This group offers SharePoint consulting services, and they have the distinction of being a registered Microsoft partner. With iDocs, clients can … Continued
SQL Maintenance Plan SharePoint 2010 databases
SQL Maintenance Plan SharePoint 2010 databases To maintain good overall databases performance of the SharePoint 2010 databases I use the following SQL maintenance plan. This plan consist of two main parts: – The configuration of each separate databases and database properties settings – The automated maintenance plan, to perform database maintenance task once a week. … Continued
PowerShell error: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.
When you run SharePoint management powershell on your SharePoint 2010 server you get the following error: The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered. Solution: Make sure the logged in user has the correct rights to the SharePoint_Configuration database SharePoint_Shell_Acces or: DB_reader or DB_writer Use the following Powershell cmdlet to give … Continued
Error starting a scheduled SQL 2008R2 Agent Job
When I tried to run the job that was created from a maintenance plan in SQL server 2008 R2, the job failed and gives the following message: [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user ‘DOMAIN\SYS_USER_NAME’, error code 0×5. [SQLSTATE 42000] (ConnIsLoginSysAdmin) I did use Windows Autheniciaton mode and the Sys … Continued
