This is so going to bite yer ass if you don't pay attention… As usual, a very quick post: I tried to create (ok, restore) a certificate from the production server to our DR server, so that the automated restores would work. When I ran the script (yes, CREATE CERTIFICATE … FROM FILE […]), I … Continue reading Create certificate from backup fails on SQL Server 2008
Category: installation tips
quick installation and configuration tips for the SQL Server box
Move cluster group from one node to another
First off, apologies to the 3 readers I have (I don't read my blog post, I just write), since all of them are far better than I am when it comes to clustering. To cut it short: how can you move ANY resource from one node to another? Namely, the disk witness in the quorum … Continue reading Move cluster group from one node to another
Create SQL Server aliases using registry editor
Another quick one today: how do I create an alias using the registry editor? If you want to want to ask me why would you do such a thing, it means you're reading the wrong blogJ. To cut it short, here are the entries in the registry: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo] – this is for x64 machines who … Continue reading Create SQL Server aliases using registry editor
“A MOF syntax error occurred” when installing SQL Server
OK, in my case it was a clustered environment, but I bet this applies to single instances as well. I ran the setup (it's not quite my first SQL Server install, you know) and after configuring all the steps, I hit Install and waited. The good news is that I didn't have to wait too … Continue reading “A MOF syntax error occurred” when installing SQL Server
master database restore failed in SQL Server 2008 R2 SP1 CU1
We just woke up having 30+ instances of SQL Server 2008 R2 Enterprise edition in development and testing. Which is bad for obvious reasons. So basically I have to uninstall the Enterprise and re-install Developer Edition on all the machines. Steps to take: Create a maintenance plan to back up all the databases (simplest way; … Continue reading master database restore failed in SQL Server 2008 R2 SP1 CU1
SQL Server 2008 cluster installation – IP address already in use
A quick one today, but I intend to make a series out of it, especially that we're having loads of "fun" with clustering: we encountered something in the line: IP Address 192.168.1.100 is already in use. To continue, specify a different IP address". Okay, I think this one filled the glass of my colleague, but … Continue reading SQL Server 2008 cluster installation – IP address already in use
Side-by-side installation of SQL 2008 R2 and SQL Server 2005
My wife asked me to install a named instance of SQL Server 2005 Enterprise Edition x64 on top our existing SQL Server 2008 R2 Enterprise x64. HA! As a SQL Server MCT (besides the fact that I did quite a few installs in my time) I should have known better how to do it. So … Continue reading Side-by-side installation of SQL 2008 R2 and SQL Server 2005
How to Disable NetBIOS on the SQL Server Box
Today I'll post a quick one, since a simple Google search (yeah, Bing, sorry) did not yield too many useful results. Just as a quick note, make sure you have a chat with your sys admins; they can tell you whether the protocols are needed or not anymore. Okay, on with the tip: Go to … Continue reading How to Disable NetBIOS on the SQL Server Box