Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Monday, 29 August 2011

I finally found a plow for my Ford 4000 tractor, I'll take pictures once I have it hooked up and working...



Monday, 29 August 2011 13:13:57 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Friday, 26 August 2011

Every few days I have a flock of Turkeys come through the property, usually they are pretty far back, but recently they have been really close, if they come this close to the house after Sept 15th, one or two of them will be in the freezer...

Friday, 26 August 2011 06:57:58 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Tuesday, 16 August 2011

   The boyz are back in town !

  1. EJ 3rd Grade
  2. TJ 2nd Grade
  3. AJ Kindergarten

Strength in Numbers.

Tuesday, 16 August 2011 13:29:21 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Wednesday, 10 August 2011

The sql server error log, starting with sql 2005 +, began giving us some very descriptive reasons for the login failure. This detailed reason was not always returned to the client for security reasons, but the SQL DBA could look in the error log and get more information on the error.

DBA's are never satisfied as the more information is enough to help, but not completely. Recently we started receiving the login state 16 on a TFS (Team Foundation Server) SQL Server. State 16 means that incoming user does not have permission to log into the target database. Damn, it'd be nice if the error message would tell you the target database it was trying to login to !

Out of desperation we promoted the login to a sysadmin. The login state 16 error continued.

This is when we clued in that the target database must just not exist. Sure enough a comparison with our other TFS SQL instances showed a missing database.

Once we restored that missing database, the error went away. Frustruating to troubleshoot this particular login state, when if the error message were more clear (by including the name of the target database) we could have fixed this in 10 minutes. The TFS administrator was clue-less, and was unable to determine that there was even an error happenning, or what service was generating the error. We never did resolve that. So remember state 16 may not just be permissions to a database, it may be a missing database.

Wednesday, 10 August 2011 12:17:06 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Tuesday, 09 August 2011

Found this happy fellow by our window.  A very pretty spider.  Don't kid yourself, it's bite is not going to feel good.

http://mdc.mo.gov/discover-nature/field-guide/black-and-yellow-garden-spider 

Tuesday, 09 August 2011 13:24:25 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Monday, 08 August 2011

changing the port number for a sql server cluster should be a pretty straight forward task.  Most Clustered sql servers will be mission critical, hence the clustering; this also means it will be properly secured behind a firewall.  This means you will need to run the SQL Server instance on a static port.  In some instances you can not choose the port that SQL chooses for you.  In these instances you will need to change the port number for SQL Server.

There are several resources out there on how to do this (why Microsoft didn't make choosing this as part of the install, or an option in cluster manager ), but all of them referenced using a command line program "Cluster Res", unfortunately this errors out on Windows 2008 R2 and SQL 2008 (r2 as well), with a "can not find the file specified".

For Windows 2008 R2 and SQL 2008 you need to run "Cluster . Resource" from the command line.

The basic directions are:

1.  Take the SQL Server instance off line.

2.  cluster . resource "SQL Server (<InstanceName>)" /removecheckpoints:"HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLSERVER"

3.  Open SQL Server Configuration Manager (ensure to "Run as Administrator"), Make the appropriate changes.

4.  cluster . resource "SQL Server (<InstanceName>)" /addcheckpoints:"HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLSERVER"

5.  Bring the SQL Server Instance back on line

6.  Verify in the sql server error log that the instance is using the correct port.

Easy stuff, that Microsoft should have made easier.

How to change SQL Server parameters in a clustered environment when SQL Server is not online (http://support.microsoft.com/kb/953504)

http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-configuration-time-bombs/

Monday, 08 August 2011 06:22:36 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Friday, 05 August 2011

This is the bugger that got into my trash.


Friday, 05 August 2011 13:19:34 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Tuesday, 02 August 2011

   Breaking ground on a horse pasture that hasn't been plowed in 26 years.

>





Tuesday, 02 August 2011 13:13:54 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Search
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
DTA - Failed to initialize MSDB dat...
SQL Server Security, not where it n...
Check the Uptime of a Windows Serve...
Recent Posts
Archive
May, 2017 (2)
April, 2017 (1)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Links
Categories
Admin Login
Sign In
Blogroll