Blogs

Steve sent me this earlier in December, but I thought it was worth sharing. Here is the photo he took: ttfn David Technorati Tags: David Overton , Overton , Personal , UK Train Stations

This can help diagnose and resolve the issue if like me, it was running fine and then it suddenly stops about 4-5 weeks after it all got started. My initial thought was that some update had changed things as the blog post here documented the initial setup where the same error was seen. The error once again looked like this: However checking all the same firewall and other settings revealed nothing. Finally I discovered that the user I had created had a password setting that meant the password had expired. Simple...

I think everyone knows that an urgent security issue has arisen in IE this week and Microsoft has taken the (wise) decision to publish a fix outside the normal 2nd Tuesday release cycle. Some have said switch browser because of this issue, but not only can that be complex, but most browsers suffer security issues so once again the only real protection is to wrap in cotton wool and hide. Or, use the built in features of Vista and IE7/8 which means protected mode and NOT running as admin. You might ask why a Christmas...

So these are really quick snippets.  I hit an error where my Gateway monitoring software could not connect to the database.  All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client connector software. The fix that worked for me was very simple, to change the “Provider=SQLNCLI …..” to “Provider=SQLNCLI10 …..”.   The second issue was nothing that came about from the SQL 2005 to SQL 2008...

This year, like all others for the last 10 years we’ve decorated our house with Christmas lights.  We have at least 3 different religious views in our house, which is amazing considering there are two adults and two children, aged 8 and 2, however we love the smiles the lights bring to ours and others' faces, so each year it gets a little grander (or kitch or tacky!). The pictures from this year can be found at http://davidoverton.com/media/g/doverton/tags/Christmas/Personal/default.aspx .  Below...

I’ve found myself moving datafiles around or backing up to new locations before enough that I need to change SQL to point to the new locations before it will start for me to do further work.  The process to get it up and running is to find the SQL instance in the registry and change 3 values. The magical location is: “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10. <instance> \MSSQLServer\Parameters” Under here you will file 3 arguments.  Notice the double backslashes “\\...

In my last post on installing Hyper-V for my home setup I said I had a number of issues.  One was that the Hyper-V Manager kept on showing the error "Cannot connect to the RPC service, make sure your RPC service is running".  This turned out to be several issues. To start with my Hyper-V box is in a workgroup, so security is manually configured.  Then there is the connection ID security - by hand and finally there is the client setup too.  I spent a long time with John Howard's...