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.

SQL Server 2005 SP2 for Window Vista

In order for SQL Server 2005 to run in Window Vista environment, you need to apply SQL Server 2005 Service Pack 2.

You may find the download page here

Overview

Service Pack 2 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2. You can use these packages to upgrade any of the following SQL Server 2005 editions:

• Enterprise
• Enterprise Evaluation
• Developer
• Standard
• Workgroup

SSAS service couldnt be started after applying SQL Server 2005 SP 2

You may find errors when trying to start the Analysis Services service after you have applying SQL Server 2005 Service Pack 2 under Window Vista environment. Usually you will come across it when trying to run the User Provisioning Tool right after the SP2 installation as it requires the services to be started.

To solve the problem,

1.) Go to Control Panel->Regional and Language.

2.) Click on Administrative tab

3.) Change System Locale to English (United States)

4.) Click on Copy to Reserved Accounts, and apply it to appropriate accounts.

5.) Restart your Window and try to start the SSAS service again.

It should work fine now.

Cheers

Write Locked File error during installation of SQL Server 2005 SP 1

During the installation of SQL Server 2005 SP 1 (Service Pack 1), you may encounter the following error:

The following files are currently locked. In order to prevent a necessary reboot at the end of the patch install process, close down all other applications before proceeding.

Write locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftesql.exe (msftesql.exe)
Write locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftepxy.dll (msftesql.exe)
Write locked file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msfte.dll (msftesql.exe)
Write locked file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe (sqlbrowser.exe)
Write locked file: C:\Program Files\Microsoft SQL Server\90\Shared\svenumapi.dll (wmiprvse.exe)

To solve this. go to Control Panel->Administrative Tools->Services and Stop the following services.

1.) SQL Server FullText Search (MSSQLSERVER)
2.) SQL Server Browser

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.