Tag Archive: Microsoft SQL Server

Oct 23

Resolved: Cannot alter user ‘dbo’

Resolved: Cannot alter user ‘dbo’ I was working on setting up a new Microsoft SQL Server 2016 instance and importing databases from the old server when I ran into this issue. During the import (Attach) process, I assigned the user the application uses to connect as dbo (The application requires dbo rights btw… just saying …

Continue reading »

Apr 11

How to: Configure Remote SQL Server Logging for TMG 2010

How to: Configure Remote SQL Server Logging for Microsoft’s Thread Management Gateway (TMG) 2010 Microsoft’s Thread Management Gateway is a solution that aims at providing advanced firewall and reverse proxy capabilities to the enterprise. Unfortunately Microsoft won’t be releasing new versions in the future so I haven’t been writing much about it lately; However, many …

Continue reading »

Nov 01

Resolve: DPM 2012 R2 Installation error “DPM configuration failed (ID: 4081)”

Resolve: DPM 2012 R2 Installation error “DPM configuration failed (ID: 4081)” When installing Data Protection Management on a remote SQL server you might come across a few issues like the running credentials on a SQL server and configuration error 4081. In the first case you are asked to run SQL Server Services under either computer …

Continue reading »

Aug 20

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard I was provisioning my SQL box when I found I didn´t need an already provisioned Windows Server box I had used for Exchange 2013. Lazy enough I installed SQL Server 2012 on my already installed Windows box. …

Continue reading »

Mar 10

How to: Give SharePoint 2013 crawler sufficient rights/permissions to crawl file shares

How to: Give SharePoint 2013 crawler sufficient rights/permissions to crawl file shares Symptoms Consider the following scenario: You create file shares on a Windows Server 2012 server. You set up a Microsoft SharePoint 2013 crawler on the file shares, and you assign Read permissions to the crawler. You crawl the file shares by using SharePoint Server 2013. …

Continue reading »

Mar 09

How to: Enable Kerberos Authentication on a SharePoint 2013 Server

How to: Enable Kerberos Authentication on a SharePoint 2013 Server So… As I was installing SharePoint 2013 it asked me if I wanted NTLM or Kerberos authentication, and indicated that Kerberos was the way to go. Little caveat: You might need to do some additional configuration. After doing some research it seems their definition of …

Continue reading »

Jul 26

How to: Configure SQL Server for Microsoft Threat Management Gateway (TMG) logging

How to Configure TMG logging to use a central SQL Server store The default log settings for Forefront TMG are set to a local Microsoft SQL Server Express 2008 SP1 database. During the Forefront TMG installation a local Microsoft SQL Server Express database will be installed. If you want to change this local SQL Server …

Continue reading »