Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2005 setup related error Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 2:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 25, 2012 2:06 PM
Points: 6, Visits: 16
i uninstalled sql server 2005 while reinstalling getting this error

TITLE: Microsoft SQL Server Setup ------------------------------ None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108 ------------------------------ BUTTONS: OK ------

even after installing sql on other drive(D drive) not able to install properlly(only configuration tools are displaying).

guys give me some right tips to install it.
Post #1347478
Posted Monday, August 20, 2012 6:42 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:59 PM
Points: 106, Visits: 771
This might not be relevant as maybe you've already tried this ... but have you looked in your add/remove programs to see if there were remnants of past SQL Server 2005 installation causing conflicts/problems? You can try removing everything there, then use the SQL 2005 installer agian?


Although I have a different version and experienced different behavior I had installation troubles too.

I used Add/Remove programs... removed everything SQL 2012, and then re-installed as if brand-new and was successful.





--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1347528
Posted Tuesday, August 21, 2012 12:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 25, 2012 2:06 PM
Points: 6, Visits: 16
i uninstalled completlly but after reinstalling getting tools only there

configuration tools is displaying.....
under this these all are displaying:-

>Notification Services Command Prompt
>Sql Server Configuration Manager
>Sql sever error and usages Reporting
>Sql Server Surface Area Configuration

This is the error log file details----

2012-08-21 11:03:14.03 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 6.1 (Build 7600: )

2012-08-21 11:03:14.07 Server (c) 2005 Microsoft Corporation.
2012-08-21 11:03:14.07 Server All rights reserved.
2012-08-21 11:03:14.07 Server Server process ID is 2440.
2012-08-21 11:03:14.07 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2012-08-21 11:03:14.07 Server This instance of SQL Server last reported using a process ID of 4288 at 21-08-2012 11:02:08 (local) 21-08-2012 05:32:08 (UTC). This is an informational message only; no user action is required.
2012-08-21 11:03:14.07 Server Registry startup parameters:
2012-08-21 11:03:14.10 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2012-08-21 11:03:14.10 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2012-08-21 11:03:14.10 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2012-08-21 11:03:14.24 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-08-21 11:03:14.24 Server Detected 1 CPUs. This is an informational message; no user action is required.
2012-08-21 11:03:16.96 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2012-08-21 11:03:19.44 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2012-08-21 11:03:20.97 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2012-08-21 11:03:21.83 Server Database Mirroring Transport is disabled in the endpoint configuration.
2012-08-21 11:03:22.19 spid5s Starting up database 'master'.
2012-08-21 11:03:23.11 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2012-08-21 11:03:24.86 spid5s SQL Trace ID 1 was started by login "sa".
2012-08-21 11:03:25.09 spid5s Starting up database 'mssqlsystemresource'.
2012-08-21 11:03:25.96 spid9s Starting up database 'model'.
2012-08-21 11:03:25.98 spid5s Server name is 'DELL-PC'. This is an informational message only. No user action is required.
2012-08-21 11:03:26.78 spid9s Clearing tempdb database.
2012-08-21 11:03:27.93 Server A self-generated certificate was successfully loaded for encryption.
2012-08-21 11:03:27.95 Server Server is listening on [ 'any' <ipv6> 1433].
2012-08-21 11:03:27.95 Server Server is listening on [ 'any' <ipv4> 1433].
2012-08-21 11:03:27.96 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2012-08-21 11:03:27.96 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2012-08-21 11:03:27.96 Server Server is listening on [ ::1 <ipv6> 1434].
2012-08-21 11:03:27.96 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2012-08-21 11:03:27.96 Server Dedicated admin connection support was established for listening locally on port 1434.
2012-08-21 11:03:27.98 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2012-08-21 11:03:28.13 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2012-08-21 11:03:28.54 spid9s Starting up database 'tempdb'.
2012-08-21 11:03:28.76 spid5s Starting up database 'msdb'.
2012-08-21 11:03:29.38 spid12s The Service Broker protocol transport is disabled or not configured.
2012-08-21 11:03:29.38 spid12s The Database Mirroring protocol transport is disabled or not configured.
2012-08-21 11:03:30.30 spid12s Service Broker manager has started.
2012-08-21 11:03:30.38 spid5s Recovery is complete. This is an informational message only. No user action is required.
Post #1347579
Posted Tuesday, August 21, 2012 1:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 18, 2014 7:59 PM
Points: 106, Visits: 771
Hello I saw your posting, but I wanted to confirm.. you stated you have installed only the client tools successfully?

Are you stating that the SQL Server engine was not installed?

But you posted the log from the sql server.

Is your problem now you are unable to access SQL Server? If you use the surface area configuration manager do you see the SQL Server services "started"?


--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1347596
Posted Tuesday, August 21, 2012 1:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 25, 2012 2:06 PM
Points: 6, Visits: 16
yes, but now i installed successfully sql server 2005 setup.

but while connecting getting error-

TITLE: Connect to Server
------------------------------

Cannot connect to DELL-PC.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Post #1347605
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse