The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory.

The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory.

Shortly after configuring a new SQL Server 2012 server as a pull subscriber to a publication on a SQL Server 2008 Publisher/Distributor, we began receiving the following error message from the replication agents/jobs: The root cause, after much searching and testing theories, was permissions on the subscriber COM directory. The fix was to simply grant…

Read More Read More

SQL Server 2012 SP1 CU1 Installation Failure – Resolved

SQL Server 2012 SP1 CU1 Installation Failure – Resolved

So I was recently installing SQL Server 2012 on a couple of new machines and ran into the following error when attempting to apply SQL Server 2012 SP1 CU1: This causes the SQL Server installation not only to be incompletely upgraded (Data Quality Services, Full-Text and Semantic Extractions for Search, SQL Server Replication, Database Engine…

Read More Read More

SSRS: Failure sending mail: The user or group name ‘Domain\UserName’ is not recognized.Mail will not be resent.

SSRS: Failure sending mail: The user or group name ‘Domain\UserName’ is not recognized.Mail will not be resent.

Just ran into this one. If an SSRS report user comes to you indicating that they’ve attempted to created a subscription and, although it allowed the subscription to be created, the report subscription failed to be sent via email with the following Status: When troubleshooting, I found that the subscription owner account name did NOT…

Read More Read More

SQL Server Agent – Proxy/Credential Permissions for SSIS Packages

SQL Server Agent – Proxy/Credential Permissions for SSIS Packages

Just a quick self-help note today……if you ever see the error message below with a SQL Agent Job calling an SSIS Package stored in SQL Server (MSDB database) and leveraging a Proxy built on a specific credential, ensure the credential under the proxy has membership in the db_ssisoperator role in MSDB. Without it (or a…

Read More Read More

SQL PASS Summit 2011 – A First Timers View

SQL PASS Summit 2011 – A First Timers View

So, as promised, I’m lightly documenting my experience as a first timer at the SQL PASS Summit. In the next few posts, I’ll be specifically covering the 2011 Summit, held in Seattle, WA. I’ll break it up by day, beginning with travel and what to expect. Also, there are plenty of other articles out there…

Read More Read More

2011 SQL PASS Summit coming…preparing for the 3-day long blog…ASUS Transformer Tablet purchase

2011 SQL PASS Summit coming…preparing for the 3-day long blog…ASUS Transformer Tablet purchase

Well, the 2011 SQL PASS Summit in Seattle, WA, is fast approaching….2 weeks until the biggest SQL Server based technology community convergence begins and being an official first-timer, I’m not totally sure what to expect, but I’m planning to share every day what it’s like on this blog. To start things off right, I found…

Read More Read More

Procedure to Validate SQL Server Replication Convergence

Procedure to Validate SQL Server Replication Convergence

Today I’m posting a turn-key solution for those of you out there supporting SQL Server replication. The purpose of the stored procedure created by the script provided below is simply to leverage a little-known, but very useful, tool provided by Microsoft for the sake of convergence validation (all your table based articles are identical between the publisher and subscriber(s)).

SQL Agent Jobs owned by individual users – Quick Fix

SQL Agent Jobs owned by individual users – Quick Fix

Today I’m sharing a “quickly whipped script” to change the owner of SQL Agent Jobs to SA (or another of your choosing), so if the individual job owner were to leave the company and their AD account dropped, the job wouldn’t just begin failing. Feel free to use/modify/redistribute for any reason. SET NOCOUNT ON  …

Read More Read More

April 2011 Wichita SQL Server User Group Meeting

April 2011 Wichita SQL Server User Group Meeting

April 2011 WSSUG Meeting Topic: Accelerating your Database and Applications with Fusion-io Technology Date: Thursday, April 21st, 2011, 6-8:30PM Speaker: Brian Terry Location: Glorious Bible Church Overview: Fusion-io is a pioneering purveyor of NAND Flash based ioMemory –a non-volatile technology that physically acts like persistent memory, yet logically acts like disk. Our presentation will describe…

Read More Read More

The target principal name is incorrect….

The target principal name is incorrect….

Documenting another solution for a problem I ran into today. Whilst attempting to connect to a SQL Server 2008 Analysis Services (SSAS) host, I was prompted with the following error: After fumbling around trying to figure out why the “princpal name was incorrect”, I tried the fully qualified domain name for the host and waalaaa,…

Read More Read More

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0×800

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0×800

So today I’m posting about an issue with SQL Server replication. This particular posting is with regards to a SQL Server 2008 Enterprise 64-bit platform and transactional replication. The story goes like this: I was asked to add some new tables in a published DB to the transactional publication on the publisher to get replicated…

Read More Read More

Facebook Page for WSSUG

Facebook Page for WSSUG

The Wichita SQL Server User Group now has an official Facebook page for promoting the group and gaining some social media inroads. Primarily to drum up interest in the group and being to provide a discussion area, I created the page and will try to update more regularly than I am here. I’ll be sending…

Read More Read More

More official than ever….Wichita SQL Server Users Group, Inc.

More official than ever….Wichita SQL Server Users Group, Inc.

The Wichita SQL Server Users Group, Inc. is now an official non-profit organization with the State of Kansas. Filing was made successfully earlier today. A few more hurdles to clear and we’ll be able to have our first informational & planning meeting. Woohoo! Again, I will be welcoming just about any support and volunteerism I…

Read More Read More