SQL Server FullText Search service could not be started

After you have installed SQL Server 2005 on Window Vista, you might find your the service above could not be started, and it returns you error like "the dependency service is missing or marked for future deletion".

The problem is that one of the service named "NTLMSSP" does not exist in Window Vista environment. If you want to know better about NTLMSSP, Live-Search it.

The solution is simple, install SQL Server SP2 for Vista. Then you will find the dependency service removed.

If the problem persisted, DIY method at below:

1. type in "regedit" in Search to open Registry Editor.
2. Go to HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Services
3. Select msftesql. Check that the display name is SQL Server FullText Search.
4. Find the item named "DependOnService". Right Click -> Modify
5. remove the NTLMSSP from the list and Click Ok
6. Reboot and you can try starting the service again.

Hope it helps.

SQL Server Management Studio missing after installing SQL Server 2005 on Window Vista

Sometimes this could happen when you install or reinstall SQL Server on Window Vista. I am not very sure what is the cause of it but it took away 1-3 days to figure out what was wrong with all these. It will be even worst when you find your Business Intelligence Development Studio missing as well.

Ok, do not worry about it.

What you need to do is

1. Do not uninstall it.
2. Go to your Microsoft SQL Server folder -> 90 -> Tools. And rename the Tools folder name to Tools-Bak
3. Insert your SQL Server DVD and Browse it.
4. Find a folder named Tools and execute the installer in the folder. It will basically install the missing tools (Management Studio, etc) and Sample Database.
5. if you have problem with the SQL Server instance attaching the sample databases, do not install it else it will bring more headaches to you.
6. Once you have finished installing the tools.. you will find a new Tools folder appear in your Microsoft SQL Server -> 90 folder.
7. Now it should solve your headaches. Do not think it is finished, Apply Service Pack 2.

Hope It helps.

Installation of SQL Server 2005 on Vista - Warning Message "IIS Feature Requirement" during System Configuration Check

Installation of SQL Server 2005 on Vista - Warning Message "IIS Feature Requirement" during System Configuration Check

- If you click on the message, you will see:-

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

- If you proceed with the installation, you will find the Checkbox for "Reporting Services" is disabled.

Reason

1.) IIS not installed or IIS is disabled.

2.) Some of the required features in IIS are not installed.

Solution

1.) Log on to Window with Administrative privilege.

2.) Go to Start->Control Panel

3.) If Classic View, Go to Programs and Features; Else Go to Programs -> Programs and Features

4.) Click "Turn Windows Features On or Off

5.) Locate the IIS (Internet Information Services).

6.) If it is NOT Checked, it means IIS not installed. Then you check it.

7.) If it is filled, it means partially installed. Then you may need to check the following items:-

+ Web Management Tools

+ IIS 6 Management Compatibility

+IIS 6 WMI Compatibility

+IIS Metabase and IIS 6 Configurations Compatibility

+ World Wide Web Services

+ Application Development Features

+ ASP .Net

+ ISAPI Extensions (Automatically checked if you check ASP .Net)

+ ISAPI Filters (Automatically checked if you check ASP .Net)

+ Common Http Features

+ Default Document

+ Directory Browsing

+ Http Redirection

+ Static Content

+ Security

+ Windows Authentication

If you find some of the other options are needed then you may want to check it as well.

8.) Click Ok.

9.) It will take awhile to install the components, and all these steps does not require a Window CD.

After that, you may proceed to install SQL Server 2005. If you find the warning persisted, then you may want to try restarting the IIS or the Window.