December 26, 2011 at 10:04 am
Hi,
I was installed SQL Server 2005 in Win7 machine, after installation completed, i am trying to open the management studio, But its not there in application. I opened SQL Server Configuration Manager and go to services and I am trying to start the sql full text search, I got an error below:
"The SQL Server FullText Search (UAT) service depends the following service: NTLMSSP. This service might not be installed."
Please let me know how should i open the management studio ???
Krish....
December 27, 2011 at 2:47 pm
Please check http://support.microsoft.com/kb/955725
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 29, 2011 at 4:32 am
The error above is caused by missing the NTLM Security Support Provider (NTLMSSP) service. The full-text search depends on the NTLMSSP service. However, the NTLMSSP service does not exist in Windows Vista. SQL Server 2005 Service Pack (SP2) has fixed this problem. We recommend you install the last service pack (SP3) for your SQL Server 2005.
Download: Microsoft SQL Server 2005 Service Pack 3
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply