June 14th, 2009
I wrote a step-by-step walkthrough a couple years back on how to configure transactional replication. This walkthrough assumes we will be using the publisher as the distributor.
Pre Setup Steps
Create, or request from a domain administrator, three domain accounts are to be used to run the various replication services. These are needed to run the snapshot agent, log reader agent, and the distribution agent.
The same snapshot agent account is used for all publications on the publisher, therefore, if you are just adding a publication to a server that is already configured for replication, you just need to get two accounts, one for the log reader agent and one for distribution agent.
Configure Distribution
The first step is to configure a server to be a distributor.
Snapshot Share
Create a folder on disk to be used as the location where the initial snapshot files will be placed. Then, create a share for this folder. On a cluster, make sure to place the folder on a shared disk, and use the cluster administrator to create the file share. I recommend using the simple name, snapshot$, for the share name. Read the rest of this entry »
Tags: distributer, publisher, replication, sqlserver, subscriber
Posted in Professional, SQL Server | No Comments »
June 5th, 2009
A while back I wrote a couple documents about replication in SQL Server 2005. I am publishing what I wrote with some minor modifications to make it better for public consumption. Most of the text in this document was copied from Books Online. I didn’t keep track where exactly everything came from. It was intended for my personal use only. I wrote it mostly to familiarize myself with SQL Server replication and somewhat aggregate all the information from the BOL into one document. I have a different document that walks through all the steps to configure transactional replication, and one that discusses recovery issues with replicated databases. Those will be posted separately.
About Replication
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet. Read the rest of this entry »
Tags: distributer, publisher, replication, sqlserver, subscriber
Posted in Professional, SQL Server | No Comments »
May 30th, 2009
Sometimes when connecting to a SQL Server instance using windows authentication, you may get an error with the message, “Cannot generate SSPI context.” Microsoft has a KB article explaining why this issue happens and how you should properly configure things to allow Kerberos over TCP/IP. However, I feel it falls a bit short when trying to explain exactly how to fix an existing problem.
Workaround
As mentioned in the KB article, to temporarily get around this issue, you can use a SQL Login or the Windows Authentication over the Named Pipes protocol to connect. This is usually easy to do and provides a little bit of comfort to know that your SQL Server instance isn’t hosed. However, it does not fix the problem.
Solution
As mentioned in the KB article, one the first thing to look at when trying to fix this issue is to verify your DNS entries are correct. Read the rest of this entry »
Tags: kerberos, ldifde, ntlm, setspn, spn, sqlserver, sspi
Posted in Professional, SQL Server | No Comments »
May 27th, 2009
Welcome to my new blog. I am going to try to write some stuff here. I find it somewhat relaxing. But like every blog I have started, I just can’t keep it going. We will see. I want to make this more of a professional blog, talking about work stuff, contributing to the general IT world I participate in. I will try to keep personal stuff to a minimum (that is what I use Twitter for).
The new version of WordPress is impressive. They have made a lot of progress in the 2 years since I have used it. I am glad things are moving forward. I also really like the ability to customize. I am not sure how much customization I will do, but you can expect a bit here and there. I already had to tweek the Twitter sidebar CSS.
Also, I am thinking about reposting some of my old blog posts. But I want to do it in an elegant way. If anyone has any suggestions, drop me an email.
Tags: blogging, wordpress
Posted in Personal | Comments Off
