Author: Calin OPREA

Strange error in SQL Server 2005… when aplying SP3

Posted on by Calin OPREA

Before going any further, let's get this straight: I'm not sure whether it's a bug or not, whether can be reproduced or not, but I care to have this documented.A machine was re-installed (Win 2003, SQL 2005), having 3 named instances (no default, just named instances). SP3 was applied... and nothing was like before:-). You … Continue reading Strange error in SQL Server 2005… when aplying SP3 →

SQL 2008 DBA now

Posted on by Calin OPREA

I made myself an early Christmas present: since I had a free exam voucher from Microsoft, I said to myself heck, since I'm not paying for the exam, it's kinda time to upgrade my DBA skills from 2005 to 2008. That is, 70-453.OK, I passed, but I want to tell you some impressions:tough examdifficult examnot … Continue reading SQL 2008 DBA now →

talking about customer care:-)

Posted on by Calin OPREA

I just received (as an MCT I get all kinds of goodies) a free licence of PerfectDisk 11. So far, so good... but: "the official release isn't until tomorow, but I wanted to make sure our MCTs had it in their hands a little early".This is what I call "yes, they care about me".best regards,io

Simple lesson learned

Posted on by Calin OPREA

KISS (Keep it stupid simple) :-)"System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation." - that was the wife having an issue.I told her: okay, do you have SQLNCLI? Obviously, she had it installed.Me: well then, check here:http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspxhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspxIt turned out that SQL Browser service was not started. Again, KISS or be KISS-ed.