6/13/2008 12:13:57 AM
I tried to setup a database with full-text indexing today as part of an application I'm working on. I followed instructions to a T and I received the following error:
Awesome. The only difference I can think of is that the machine that this was successfully created on happened to be running Windows XP SP2. I am running Vista Ultimate.
Naturally I started Googling the error only to find nothing really helpful. It's all speculation. I just downloaded a 284MB .msi for SQL Server 2005 SP2 since "you have to install SP2 if you are running Vista and you want SQL Server 2005 to work properly."
At this point I'll try anything. If you have any suggestions, by all means...
UPDATE
I'm awesome. Not really (yes) but through extensive Google-searching, next-level blogging and waving a dead chicken over my laptop I have finally resolved this.
The culprit was a NTLMSSP (NT LAN Manager Security Support Provider aka NAMBLA)service dependency. TBQH, I don't really give a shit what it does, all I needed to know is that:
This service has been removed from Windows Vista and Windows Server 2008 in favor of the newer Kerberos authentication protocol.
So, a service is removed entirely from Windows Vista and Server 2008 and a dev team thought it would be a good idea to either a) take it out of the OS entirely or b) make SQL Server 2005 depend on it. That makes perfect sense.
All kidding aside, get to your registry settings by way of regedit.exe or Start -> Run -> regedit and look for:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql
Remove NTLMSSP and reboot. Easy. Thanks Tanzim and some dba-type from a Google Groups thread!
SQL
