July 2006 Archives

Powered by www.itgroove.net

Ok, this one took a while to sort out and I believe people will have different results...

In my case (but I don't think it was even specific to MS SQL, just the result of it, an MSDE database (MSSQLSERVER) service failed to start. After much troubleshooting and only "Error 193: 0xc1" to work with (no event logs, nothing!), I managed to figure out that it was because there was a file called 'program' at the root of the D: (whatever drive impacts you). Not sure at this writing how it got there (no it wasn't a virus, probably just bad code by somebody or a pipe) but that file wasn't needed but the SQL Service was following that path instead of honouring the path it should have (as identified in the service path).

So, I renamed the file called 'program' to something else and voila, I was back in business.

I hope this helps someone, somewhere faster than I was able to help myself :) Let me know about if it helped you - heck buy me a beer - www.itgroove.net/beers

Cheers,
Sean

Powered by www.itgroove.net

Sponsored by Major Change (.com), the Online Change Register

Fine tuned the business descriptions and thought it was worthy of a relaunch. As well, check out our sexy new Flash Intro - http://www.itgroove.net/go

Flash ? Animator vs. Animation

This is Excellent!

RFC 1149 (rfc1149) - Standard for the transmission of IP datagrams on avian carriers

Carrier Pigeon Protocol - Gotta love it. :)

I've had a few ISA servers do this to me now... :(

SQL Server logging seems to leak (even beyond what gets set it seems) so here's what you do to fix it...

To Know:

1. Your physical memory

2. Find out what task (PID) SQL Server uses by issueing the following command: Tasklist /svc

3. Take note of PID of sqlsrvr.exe and open Task Mananger, change the view and add PID Columm. Then look for the sqlsrvr.exe service associate with PID you wrote down.

4. Verify if this instance of sql is consuming all your avaiable RAM. If it is, go to the following website to set a limit for sql.

http://support.microsoft.com/?id=909636 (if you don't like that M$ long winded approach, use this guys tool - http://www.isascripts.org/ - look for the zip file and in it, find the ISA_MSDE_Max_Memory script)

WinSCP :: Freeware SFTP and SCP client for Windows

This was good enough for me :)

How to Configure the RPC Proxy Server to Use Specified Ports for RPC over HTTP

You'll need more than TCP443 (SSL/HTTPS) available from your DMZ to your Back-end Server. You'll need (by default) the RPC ports open too (6001-6004)

Ugh, especially if you use Word as the default editor (and no choice so far in Outlook 2007 not to). Here's how you unregister that crappy, slow, annoying little component.

Follow these steps to get rid of the unwanted ADOBE add-in:
1. Open a command box. (windows start - execute: cmd)
2. Go to c:\program files\adobe\adobe acrobat 6.0\pdfmaker\mail\oulook.
3. type: "regsvr32 -u pdfmoutlook.dll"
This will unregister the DLL that is responsible for the add-in.
You can later always get it back by leaving out the -u option.

4. Restart Windows.