Unable to install SQL Server 2005 Standard

Unable to install SQL Server 2005 Standard

• RookieBalbo

  Hi Jingwei,

  Many thanks for your response and questions.

  1) I did originally have the MSDE (SQL 2000) installed on my machine. I disinstalled it and then ran the installation for SQL 2005 Standard Server. So I am not trying to upgrade an existing installation, but I don't know whether you would consider this a clean install.

  2) I do want to be able to access this SQL server from other machines in my peer to peer network so I will need to activate network access. When I begin the installation I successfully pass the System Configuration Check phase (no errors and no warnings). I have managed to install the Analysis Services, Reporting Services, Notification Services, Integration Services, Workstation Components, Books Online and Development Tools. The only one I can't install is the SQL Server Database Service which I have tried to install both with the other services and on its own. In all cases I am choosing to load all options on to my local drive and not excluding anything. For the SQL Server Database Service I have tried both installing a default as well as a named instance (same error message in both cases). I have specified to use the built-in system account and specified it as Network Service and have specified mixed-mode authentication (I cannot use Windows Authentication because I do not have a Domain Server and Active Directory). So I think in answer to your question this is not a localized server.

  3) I did not see any questions regarding full-text component on the install, but as mentioned above I specified to load and run everything from my local drive.

  4) I cannot start the SQL Server because the SQL Service did not install. When you get the error message during installation,  the install reverses itself. If I look at my available services on my machine there is no SQL Service. I do however have services from the other SQL components that did get installed.

  I am trying to provide as complete information as possible. I hope I answered your questions, but please ask me for any additional info.

  Regards

  Ted Hoffman

  
  

• weaselcoder

  Hi Ted,

  Based on what you describe, you should not see this error. Here is two things we can try:

  1. Could you send me the setup log By default it is under C:\Program Files\microsoft sql server\90\setup bootstrap\log\files. I only need the latest *_SQL file for now.

  2. Could you try to install SQL without full-text component You will need to explicitly unselect full-text component from SQL server service component. By default it is installed as part of SQL server service.

  thanks,

  Jingwei  

  
  
  

• dafan

  You can run select SERVERPROPERTY ('IsFullTextInstalled') to check if full-text service is installed.

  Can you show me sp_configure output, what is the "default full-text language value"

  If full-text component is not installed, you should be able to check the full-text component and install it.

  thanks,

  Jingwei

  
  
  

• Ubon94

  Ted,
  
  The most likely reason for the mesage is that the default language on your system is something other than US-English or you chose a locale during setup for which there is no full-text support. I will move this thread to Setup forum to see if someone there can assist further.
  
  Log files may have more information about this error as well.
  
  Boris.
  
  

• norsd

  Hi Jingwei,

  I did what you asked. I reinstalled the SQL Database Services and selected everything except for the Full-Text Search. The SQL Database Services installed without error. Next I decided to go back and try to install the Full-Text Search. This time the installation program told me that it can't install because there are no effective changes.

  So the net result is that I now have SQL Server installed on my own machine. I am not sure if the Full-Text Search was installed or not. How can I tell

  Do you still want me to forward the log file

  Thank you very much.

  Ted Hoffman

  
  

• chris_dk

  for select SERVERPROPERTY ('IsFullTextInstalled') the result is 0

  sp_configure shows the following:

  allow updates 0 1 0 0
  clr enabled 0 1 0 0
  cross db ownership chaining 0 1 0 0
  default language 0 9999 0 0
  max text repl size (B) 0 2147483647 65536 65536
  nested triggers 0 1 1 1
  remote access 0 1 1 1
  remote admin connections 0 1 0 0
  remote login timeout (s) 0 2147483647 20 20
  remote proc trans 0 1 0 0
  remote query timeout (s) 0 2147483647 600 600
  server trigger recursion 0 1 1 1
  show advanced options 0 1 0 0
  user options 0 32767 0 0

  What I make out from this is that the Full-Text Search capability is not installed. I am unable to install it per my previous correspondance.

  Regards

  Ted Hoffman

  
  

• adam kromm

  Dan,

  Success at last. I did what you suggested and it worked. I ran "select SERVERPROPERTY ('IsFullTextInstalled')" and it now reports a "1" (that is after stopping and restarting the SQL Engine).

  I am not sure of exactly what conclusions we can draw from all this, but this incident can now be closed and many thanks for yours and Jingwei's assistance.

  Regards

  Ted Hoffman

  
  

• D. Guillermo Avilez

  Hi Ted,

  The error seems coming from running T-SQL "Reconfigure" command during setup. Here is a few things you can help me to identify the problem:

  1. are you doing a clean install of yukon or you are running an upgrade  

  2. are you installing localized SQL server

  3. did you install full-text component By default it will gets installed unless you explicitly uncheck it.

  4. are you able to start sqlserver now If yes, could you run sp_configure  and see what is value for "full-text default langauge" option. It is an advanced option.

  thanks,

  Jingwei

  
  
  

• Azoth

  Thank you Boris,
  
  My locale is set up for United States. The install program does not ask for any information regarding locale.
  
  There seem to be all kinds of logs and the messages are very cryptic to the uninitiated so I don't know where to start.
  
  Ted Hoffman
  

• BatesManty

  Ted,

  Note: I'm not at my main computer so I'm doing this from memory.

  To add Full-text Search (FTS) to an existing installation do the following:

  1) Launch Add or Remove Programs from the Control Pannel

  2) Scroll down the the entry for SQL Server 2005, select it and press the "Change" button

  3) Select the instance you want to add FTS to and click next

  4) On the next dialog select the "relational engine" or "DB Engine" and select next. This will launch the MSI in maintenance mode.

  5) You will eventually get to a dialog that has two options: 1) add/remove components from an existing installation or 2) uninstall... - select add/remove.

  6) Next you'll get to the feature tree. Make sure everything is selected including FTS and follow the rest of the dialogs.

  This will add FTS to the selected instance.

  Cheers,

  Dan

  
  
  
• Unable to install SQL Server 2005 Standard