Hi I installed SQL server 2005 Express and it was successfully set up but I kept on getting error 26 when I try to connect to a database, so I remove all SQL programs from the control panel and reinstall SQL server 2005, but this time the set up stopped halfway saying "cannot start server". How can I successfully reinstall SQL server 2005 express
Hi,
This is what I would try:
First, make sure that you are logged in with an administrator-level login.
Second, reboot the computer and try the install again.
Third, ensure that you do not have any copies of any version of SQL installed (and showing in add/remove programs).
Forth, try installing again.
Finally, check to ensure that you have the correct connection protocols (TCP/IP, Named Pipes, etc.) enabled and that your firewall (either a physical one or Windows Firewall is configured to allow traffic in on port 1433)
With regards to error 26 -- were you getting that from SSMS (management studio) or from an application that is trying to connect to it Was this on your local machine or a remote one
Some information about error 26 in ASP.Net is located here: http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx
Some information about error 26 in the management studio is located here:
http://www.datamasker.com/SSE2005_NetworkCfg.htm
- Jeremy
How to reboot the computer
The setup stop when trying to install SQL services. The message I got is it "cannot start service".
You should elaborate.
Check out your Event Logs and give us more detailed info.
If you want to uninstall your SQL Server instances then go to Add\Remove Programs from Control Panel. If you can not uninstall your instances using that way, then try uninstalling them manually:
How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
Hi,
1.) Download Windows Installer CleanUp utility from the link http://support.microsoft.com/kb/290301 and install in the system
2.) Using this uninstall or cleanup the partially installed sql server express
3.) Reboot the system
4.) Try installing sql server express from the setup.
Regards..Sagar
Hi thanks for trying to help, but as you know I still can't seem to install it. At first I remove all SQL components on the ADD/REMOVE programs windows. I did not remove .net 2.0 framework or IIS from my computer as I need them for other programs. Then I restart the computer and install SQL Server 2005. It installed SQL native client, SQL setup files, SQL VSS writer, and then when it is trying to install SQL services it suddenly stopped and a messagebox appears saying "SQL service won't start please refer to online help". I tried installing like ten times and the same things happen. How can I install SQL server on my computer
As for the error 26, I think I forgot to turn on the "remote access" from the system panel in control panel.
Hello Dolin,
As far as I understand, you uninstalled your old instance and its components except for .Net Framework and when you tried to install a new instance of SQL Server, it set ups some services but when it comes to SQL Server service, it fails sayin "SQL Server service cannot be started" or something like this.
I believe you may have a problem with your SQL Server service account. Can you tell me what account do you use for your SQL Server
Can you check Event Logs for any detailed error message regarding to this issue
Hello Ekrem,
my log file is as below. As for the user account, I do not understand which account. I have not succeded in loggin in to my account due to error 26 in my previous attempt. I used Windows authentication in my first installation. Can you fill me up on SQL service accounts
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Nov 01 17:05:24 2007
Machine : WINXP
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_WINXP_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : WINXP
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_WINXP_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : WINXP
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_WINXP_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : WINXP
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_WINXP_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : WINXP
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : WINXP
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0010_WINXP_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--------------------------------------------------------------------------------
Hello Dorin,
I'm not talking about Authentication. First, you must make SQL Server service running to be able to connect to your SQL Server instance.
In SQL Server Setup, you use an account for SQL Server service. It's in the Service Account window in Setup. Which option do you select there "Use the built-in system account" or "Use a domain user account"
Hello Ekrem, I used the "buit-in system" account. I haven't logged in yet.
The SQL manager is blank. There is nothing in there.
I tried setting up again with "local system" during the installation process. This time the message is different as below.
"The setup has encountered an unexpected error while Installing performance counters. The error is: -1073741790
------------------------------
BUTTONS:
&Abort
&Retry
&Ignore
------------------------------
"
I clicked ignore and the setup finished and the installation is successful. Thanks for all the support.
One more thing , while I open Visual Web and try to connect to Database, I chose SQL server Native Client for the Data source, use "MyComputerName"/SQLEXPRESS for the server name which is playing and chose Windows authentication, but I got error 40. I already enabled all the shared connections and the other tyes in config. How can I connect to the database