How to Install SQL server 2008 on Windows 7

Any body can help me plz ,While trying to install Sql Server 2008 in my windows 7 64-bit OS, it show Restart computer as failed. I have restarted my computer and still it shows the same error. I also refer the path "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager" but Can't see any "PendingFileRenameOperation" in folder, nothing is present inside it,only default file is present. Please advice on how to shortout this problem to install SqlServer 2008.

when i create database connection. i get this type of error.Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
plz give me suggestion about this.its argent. plz..plz

hi sir
i didn't get the step 11 and 12 while installing....

and i am not able to connect also...the server engine is database engine and the server name which i gave is (local) and authentication is windows authentication sir....can u please help me to connect it to the server.. Sigh | :sigh:

bhuvana

hi sir
i didn't get the step 11 and 12 while installing....

and i am not able to connect also...the server engine is database engine and the server name which i gave is (local) and authentication is windows authentication sir....can u please help me to connect it to the server.. Sigh | :sigh:

bhuvana

I read your post about the installation of SQL server 2008. I just reinstalled the same but the R2 Developer disc.

I am always getting stuck at the point of connecting after installation and presently got the message below. I am new to this and would appreciate any help.

I installed it as per instructions in the Microsoft SQL 2008 book by Mike Hotek.

Could you look at the error message and give some advice on what to do.

I disabled the firewall while installing it and has just turned it back on,

Here is the error message:

============

===================================

Cannot connect to MIBELOVED-PC\SQLEXPRESS.

===================================

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

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

------------------------------
Error Number: -1
Severity: 20
State: 0

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

Open Sql Server Configuration Manager and see weather Sql Server is running or not.
if not running select it and start it.

if it is running then problem is somewhere else.

Did you try to connect to your SQL Server by SQL management studio?

which authentication mode did you select in the time of installation Mixed mode or Windows mode.

Please let me know.

Thanks.

I used mixed mode
problem is that i am new at this, just got on to it after learning a little php

so I am not expert at any of it

I opened the server config manage

and with the SQL Server Services highlighted on the left, everything on the right ( 7 items) all read running.

I do not know if I connected the server to the management studio. I may have but I am not familiar with these processes.

Thanks for your interest
I actually spend days following various suggestions on how to fix this on the internet but nothing seems to work, keep getting that message

This is the summary file after I ran the repair from the original software disc.

I cannot send the detail file because it is a long file but I could send it by another means if you suppy an email address, because this box seems to freeze up when I copied and pasted the detailed file.

Here is the summary file:

CSS

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068119551
  Exit facility code:            1211
  Exit error code:               1
  Exit message:                  Failed: see details below
  Start time:                    2012-06-29 20:50:03
  End time:                      2012-06-29 21:16:18
  Requested action:              Repair
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.50.1600.1%26EvtType%3d0x0AADD6DA%400xDC80C325

Machine Properties:
  Machine name:                  MIBELOVED-PC
  Machine processor count:       2
  OS version:                    Windows 7
  OS service pack:               Service Pack 1
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Developer Edition    10.50.1600.1    No
  Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Developer Edition    10.50.1617.0    No
  Sql Server 2008 R2                                                       Integration Services                     1033                 Developer Edition    10.50.1617.0    No

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         D:\x64\setup\
  Installation edition:          DEVELOPER

User Input Settings:
  ACTION:                        Repair
  AGTDOMAINGROUP:                <empty>
  AGTSVCACCOUNT:                 .\SQL2008SBSSQLAgent
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Automatic
  ASCONFIGDIR:                   Config
  ASDOMAINGROUP:                 <empty>
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 *****
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\ConfigurationFile.ini
  ENU:                           True
  FAILOVERCLUSTERGROUP:          <empty>
  FAILOVERCLUSTERNETWORKNAME:    <empty>
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
  ISSVCPASSWORD:                 *****
  ISSVCSTARTUPTYPE:              Automatic
  PASSPHRASE:                    *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  SQLDOMAINGROUP:                <empty>
  SQLSVCACCOUNT:                 <empty>
  SQLSVCPASSWORD:                *****
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\ConfigurationFile.ini

Detailed results:
  Feature:                       Database Engine Services
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       SQL Client Connectivity
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Writer
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Browser
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Replication
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       Full-Text Search
  Status:                        Failed: see logs for details
  MSI status:                    Passed
  Configuration status:          Failed: see details below
  Configuration error code:      0xDC80C325
  Configuration error description: The name has already been shared
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt
  Configuration status:          Failed: see details below
  Configuration error code:      0x30E00066@1211@1
  Configuration error description: Service 'SQLSERVERAGENT' stop request failed.
  Configuration log:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

  Feature:                       Analysis Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Reporting Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Integration Services
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Tools
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Compact Edition Runtime
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools Connectivity
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Complete
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools SDK
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Client Tools Backwards Compatibility
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Business Intelligence Development Studio
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       SQL Server Books Online
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

  Feature:                       Microsoft Sync Framework
  Status:                        Passed
  MSI status:                    Passed
  Configuration status:          Passed

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\SystemConfigurationCheck_Report.htm

The following warnings were encountered while configuring settings on your SQL Server.  These resources / settings were missing or invalid so default values were used in recreating the missing resources.  Please review to make sure they don’t require further customization for your applications:

Service SID support has been enabled on the service.
Service SID support has been enabled on the service.

your next blog entry should be: "How to connect mouse to USB port"

How to Install SQL server 2008 on Windows 7

License

Comments and Discussions