does not connect to server on SQL2008 R2

Answered does not connect to server on SQL2008 R2

  • Saturday, June 30, 2012 1:33 AM
     
     

    Thanks in advance:

    Could you please look over this file and give advice. This is the summary file and I can also provide the detailed file.

    I just installed and uninstalled several times and did some of the routines recommended on these forums for solving the problem of not connecting to a server.

    This was after running the repair facility on the disc:

    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.


    MiBeloved

All Replies

  • Saturday, June 30, 2012 3:37 AM
    Moderator
     
     

    Hello,

    Thank you for sharing the log with us.

    Please share with us the following log also:

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120629_204646\Detail.txt

    Thank you in advance.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Saturday, June 30, 2012 3:06 PM
     
     

    Alberto,

    Thanks for your prompt response.

    I am getting a 60,000 limit of characters for this reply box. It won't process anything over that.

    The detail file have over 2 million characters.

    Is there a way where I could send the whole file

    Or should I spit it up in many replies of 60,000 or less characters.

    I am really stuck with SQL2008 and can't afford to pay for Microsoft Tech help fees.

    Would appreciate your assistance with this.


    MiBeloved

  • Sunday, July 01, 2012 1:18 AM
    Moderator
     
     
     

    Hello,

    Please put it on the public folder of your Skydrive (Hotmail) or share with us only parts of the log when you see error messages.

    Thank you in advance.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Sunday, July 01, 2012 12:31 PM
     
     

    Alberto,

    I never used skydrive in that way before

    took a while to figure it all out

    anyway i have put the detail file there for public viewing

    thanks

    dont know if this is of any use but this is the page URL

    https://skydrive.live.com/?cid=AF67D2D191D5EB3C&sc=documents


    MiBeloved

  • Sunday, July 01, 2012 8:38 PM
    Moderator
     
     

    Hello,

    I have seen  the error below on new installations when a previous installation of SQL Server was not uninstalled successfully.

    “Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Service 'SQLSERVERAGENT' stop request failed.”

    Please perform steps 1-7 and 10 described by Yoyo Yu on the following thread:

    http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/4d6158a1-b601-428c-aad4-a1716e76de1a

    Enable .NET Framework 3.5 using Control Panel -> Programs and Features. Re-run SQL Server setup again.

    You may have to install SP1 for SQL Server 2008 when SQL Server finishes.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Monday, July 02, 2012 2:17 PM
     
     

    Alberto,

    I painstakingly did everything as you suggested including the Yoyo Yu instructions.

    I reinstalled but got the same error 26 message again

    I then put back in the disc and ran the repair sequence.

    That gave  new summary and detail files which I put at my skydive account as before.

    Would you be willing to look at those:

    https://skydrive.live.com/?cid=AF67D2D191D5EB3C

    Thanks!


    MiBeloved

  • Monday, July 02, 2012 2:20 PM
     
     

    One additional detail

    the Net 3.5, I installed or thought I did. Then when I checked for it at turn windows features on or off, I did not find it.

    I then installed it again.

    Should I uninstall SQL2008 again and then reinstall it to see if that makes a difference

    net 3.5 is listed in the windows features and is turned on now

    This is the most difficult time consuming software, I ever installed.


    MiBeloved

  • Monday, July 02, 2012 3:03 PM
    Moderator
     
     

    Hello,

    The remnants of previous installations originated the installation issues.

    Once again perform YoYo Yu steps, and reinstall SQL Server 2008.

    If it fails again, do not repair  the instance, and share with us the Summary.txt log file.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Monday, July 02, 2012 3:11 PM
     
     

    I will do it again but I did go through all those steps and delete the remaining files

    I will do it over and inform you accordingly

    I won't run the repair


    MiBeloved

  • Monday, July 02, 2012 3:45 PM
     
     
    I am getting a cannot delete notice when I try to delete this folder: 


    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\.NET Data Provider for SqlServer

    MiBeloved

  • Monday, July 02, 2012 5:53 PM
     
     

    I just got done reinstalling.

    Here is the summary file:

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

    Overall summary:
      Final result:                  Passed
      Exit code (Decimal):           0
      Exit message:                  Passed
      Start time:                    2012-07-02 12:49:14
      End time:                      2012-07-02 13:41:15
      Requested action:              Install

    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

    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:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 SQL2008SBSSQLAgent
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config
      ASDATADIR:                     C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  SQL2008SBSAS
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            MiBeloved-PC\MiBeloved
      ASTEMPDIR:                     C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20120702_124421\ConfigurationFile.ini
      CUSOURCE:                     
      ENABLERANU:                    False
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  NT AUTHORITY\LOCAL SERVICE
      FTSVCPASSWORD:                 *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NETWORK SERVICE
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                    
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          <empty>
      RSINSTALLMODE:                 DefaultNativeMode
      RSSVCACCOUNT:                  MiBeloved-PC\SQL2008SBSRS
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  SQL
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 SQL2008SBSDE
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           MiBeloved-PC\MiBeloved
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      UIMODE:                        Normal
      X86:                           False

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

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

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

      Feature:                       SQL Server Replication
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Full-Text Search
      Status:                        Passed
      MSI status:                    Passed
      Configuration status:          Passed

      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:                       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:

    Scenario specific rules:

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


    MiBeloved

  • Monday, July 02, 2012 5:54 PM
     
     

    this is the error notice when i try to connect the data engine:

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


    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.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

     


    MiBeloved

  • Monday, July 02, 2012 6:20 PM
    Moderator
     
     Proposed Answer

    Hello,

    No errors on installation … Great!

    Please enable TCP/IP and Named Pipes protocols.

    http://msdn.microsoft.com/en-us/library/ms191294(v=sql.105).aspx

    Enable SQL Server Browser using SQL Server Configuration Manager.

    Configure or disable Windows Firewall.

    http://msdn.microsoft.com/en-us/library/cc646023(v=sql.105).aspx  

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Tuesday, July 03, 2012 12:16 PM
     
     

    I did as instructed about the firewall and the TCP/IP..Named Pipes

     Please check my account for a Word file which has some images in it of what i am seeing when i try to connect.

    Name of the file is

    Connect



    MiBeloved

  • Tuesday, July 03, 2012 1:53 PM
    Moderator
     
     Answered

    Hello,

    Please change the name of the server to your computer name only, (the name is MIBELOVED-PC). Do not use MIBELOVED-PC\SQLEXPRESS. On authentication use Windows Authentication, unless you have created a SQL login before or unless you know the password for the “sa” login.

    On the “Server type” keep using “Database Engine”.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked As Answer by MiBeloved Tuesday, July 03, 2012 2:09 PM
    •  
  • Tuesday, July 03, 2012 2:11 PM
     
     

    Alberto,

    Thanks a million.

    I would never have figured that out.

    Using just the computer name and using Windows Authentication did it.

    Can't thank you enough for this assistance!


    MiBeloved

  • Tuesday, July 03, 2012 2:29 PM
    Moderator
     
     

    Hello,

    Enjoy SQL Server!

    Thank you visiting MSDN forums!

    Regards,

    Alberto Morillo
    SQLCoffee.com

  • Wednesday, July 04, 2012 11:14 PM
     
     

    Alberto,

    Do you know of any workbooks for beginners, complete beginners.

    The Microsoft SQL Server 2008 Step by Step book is really not for beginners and many of the exercises just do not work as they should. They are many complains about it on the internet, which I recently found.

    Thanks

    Michael Beloved


    MiBeloved

  • Thursday, July 05, 2012 11:40 AM
    Moderator
     
     
  • Thursday, July 05, 2012 2:36 PM
     
     
    • Thanks again, Alberto!

    MiBeloved