SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


sql server 2005 setup related error


sql server 2005 setup related error

Author
Message
badalsngh2
badalsngh2
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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.
sqlsurfing
sqlsurfing
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1030 Visits: 1190
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 :-D
badalsngh2
badalsngh2
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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.
sqlsurfing
sqlsurfing
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1030 Visits: 1190
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 :-D
badalsngh2
badalsngh2
Valued Member
Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)Valued Member (56 reputation)

Group: General Forum Members
Points: 56 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
------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search