asked
Cannot Connect to any Db's, with MS SSMS
I am running Windowa XP, and I am trying to connect to any dataabase with ms sql server express, I know this is probably a newbee question, but I am a newbee kinda guy. When I try to connect I get the msg. ------------------------------Microsoft SQL Server Management Studio Error connecting to 'ABCD-6051A2AB71\SQLEXPRESS'. ------------------------------ 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) At other times when I try to connect, it say's that possibly the server is not running, and indeed it is not. However I cannot get it to start, The Browser is running , both are NT AUTHORITY\LOCAL SERVICE. I could use some help here, I am trying to learn this, but at this rate I am getting nowhere fast. In advance, Thanks
2011-01-21 11:54:24.18 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 3) 2011-01-21 11:54:24.20 Server (c) Microsoft Corporation. 2011-01-21 11:54:24.20 Server All rights reserved. 2011-01-21 11:54:24.20 Server Server process ID is 2160. 2011-01-21 11:54:24.20 Server Authentication mode is WINDOWS-ONLY. 2011-01-21 11:54:24.20 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG'. 2011-01-21 11:54:24.21 Server This instance of SQL Server last reported using a process ID of 2008 at 1/21/2011 9:18:32 AM (local) 1/21/2011 5:18:32 PM (UTC). This is an informational message only; no user action is required. 2011-01-21 11:54:24.21 Server Registry startup parameters: -d c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf -e c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG -l c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ldf 2011-01-21 11:54:24.21 Server Command Line Startup Parameters: -m SqlSetup -T 4022 -T 4010 -T 1905 2011-01-21 11:54:24.44 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2011-01-21 11:54:24.45 Server Detected 1 CPUs. This is an informational message; no user action is required. 2011-01-21 11:54:24.47 Server Perfmon counters for resource governor pools and groups failed to initialize and are disabled. 2011-01-21 11:54:24.48 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. 2011-01-21 11:54:24.72 Server Node configuration: node 0: CPU mask: 0x00000001:0 Active CPU mask: 0x00000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2011-01-21 11:54:24.82 Server Database Mirroring Transport is disabled in the endpoint configuration. 2011-01-21 11:54:24.87 spid7s Warning ****************** 2011-01-21 11:54:24.89 spid7s SQL Server started in single-user mode. This an informational message only. No user action is required. 2011-01-21 11:54:24.89 spid7s Starting up database 'master'. 2011-01-21 11:54:25.47 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'SQLEXPRESS'. 2011-01-21 11:54:25.64 spid7s SQL Trace ID 1 was started by login "sa". 2011-01-21 11:54:25.67 spid7s Starting up database 'mssqlsystemresource'. 2011-01-21 11:54:25.70 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required. 2011-01-21 11:54:26.13 spid7s Server name is 'ABCD-6051A2AB71\SQLEXPRESS'. This is an informational message only. No user action is required. 2011-01-21 11:54:26.13 spid9s Starting up database 'model'. 2011-01-21 11:54:26.15 spid7s Informational: No full-text supported languages found. 2011-01-21 11:54:26.16 spid7s Starting up database 'msdb'. 2011-01-21 11:54:26.63 Server Error: 17190, Severity: 16, State: 1. 2011-01-21 11:54:26.63 Server Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802. 2011-01-21 11:54:26.63 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate. 2011-01-21 11:54:26.63 Server Error: 17182, Severity: 16, State: 1. 2011-01-21 11:54:26.63 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 2011-01-21 11:54:26.63 Server Error: 17182, Severity: 16, State: 1. 2011-01-21 11:54:26.63 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 2011-01-21 11:54:26.64 Server Error: 17826, Severity: 18, State: 3. 2011-01-21 11:54:26.64 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. 2011-01-21 11:54:26.64 Server Error: 17120, Severity: 16, State: 1. 2011-01-21 11:54:26.64 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I have checked the exceptions and Sql Servers Management Studio is on the list. I think I am going to try to Un-install SQL Server 2008 R2, and then re-install it. I don't believe I can screw things up much worse than they already are. Thanks for your help tho. One thing I am seeing in the logs is that it seems to think this is SQL Server with Advanced Services, amd it should be SQL Server with tools. Maybe I installed the wrong program. I am pretty new at alot of this stuff.
That sounds like an excellent plan. If that works just post an answer and accept it as your answer. It if blows up again let us know and the community will continue to help you get started. It is always great to hear about another person getting started with SQL Server. Most of us here are accidental DBA's too. We all have to get our start somewhere.
Well the first issue you have to overcome is getting SQL Server to start. Have you reviewed your event logs for any type of errors? Many people have discovered after installing SQL server that their firewalls are blocking port 1433 and have to open the port. Also in Configuration Manager you have to allow remote connections and in some causes also enable TCP/IP. Post any errors you have in event viewer related to SQL Server so we can assist.
Yes I do, unfortunately it will also be a lot of text. Sorry And by the way, Thanks alot for trying to figure this out. 2011-02-10 19:43:53.79 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 3) 2011-02-10 19:43:53.79 Server (c) Microsoft Corporation. 2011-02-10 19:43:53.79 Server All rights reserved. 2011-02-10 19:43:53.79 Server Server process ID is 2880. 2011-02-10 19:43:53.80 Server Authentication mode is WINDOWS-ONLY. 2011-02-10 19:43:53.80 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2011-02-10 19:43:53.80 Server This instance of SQL Server last reported using a process ID of 3572 at 2/10/2011 7:17:53 PM (local) 2/11/2011 3:17:53 AM (UTC). This is an informational message only; no user action is required. 2011-02-10 19:43:53.80 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2011-02-10 19:43:53.84 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2011-02-10 19:43:53.84 Server Detected 1 CPUs. This is an informational message; no user action is required. 2011-02-10 19:43:53.89 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. 2011-02-10 19:43:54.30 Server Node configuration: node 0: CPU mask: 0x00000001:0 Active CPU mask: 0x00000001:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2011-02-10 19:43:54.56 spid7s Starting up database 'master'. 2011-02-10 19:43:54.86 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2011-02-10 19:43:54.97 spid7s SQL Trace ID 1 was started by login "sa". 2011-02-10 19:43:55.01 spid7s Starting up database 'mssqlsystemresource'. 2011-02-10 19:43:55.04 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required. 2011-02-10 19:43:55.78 spid7s Server name is 'ABCD-6051A2AB71'. This is an informational message only. No user action is required. 2011-02-10 19:43:55.79 spid7s Informational: No full-text supported languages found. 2011-02-10 19:43:55.79 spid10s Starting up database 'model'. 2011-02-10 19:43:55.79 spid7s Starting up database 'msdb'. 2011-02-10 19:43:56.10 Server Error: 17190, Severity: 16, State: 1. 2011-02-10 19:43:56.10 Server Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802. 2011-02-10 19:43:56.10 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate. 2011-02-10 19:43:56.10 Server Error: 17182, Severity: 16, State: 1. 2011-02-10 19:43:56.10 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property. 2011-02-10 19:43:56.11 Server Error: 17182, Severity: 16, State: 1. 2011-02-10 19:43:56.11 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. 2011-02-10 19:43:56.11 Server Error: 17826, Severity: 18, State: 3. 2011-02-10 19:43:56.11 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. 2011-02-10 19:43:56.11 Server Error: 17120, Severity: 16, State: 1. 2011-02-10 19:43:56.11 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs
I'm not to good at this (if you can't tell), but I haven't figured out how to " POST ", the Event Viewer logs yet. If it helps they are all with todays date 2/10/2011 and 7:43:56 pm with error code 17190, 17182, 17182, 17826, 17180, all MSSQLSERVER, all ABCD-6051A2AB71.
Eldon, you may want to take a look at this article [Troubleshooting Protocol Errors During Database Engine Startup][1] EDIT: This [thread from msdn forums][2] looks like similar problem based on your error log [1]:
http://msdn.microsoft.com/en-us/library/ms365392.aspx [2]:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/eb839d89-7e6e-4d52-8934-218f0ff4e3f2/
The latest log you posted appears to be failing because SQL can't initialise SSL. I can't remember where the option for protocol encryption is but you should try turning it off. If that works but you require the encryption then just add a comment and we'll try and help with setting it up. There is an MSDN thread talking about similar here
http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/3a8be3b7-66cd-44d8-9f01-f5f8739594c2/
This is a closed connect item, your issue was experience in one of the CTP for SQL Server 2008. You might try the troubleshooting steps he mentions. Look at the "Troubleshoot Steps taken", near the end of his post.:
http://connect.microsoft.com/SQLServer/feedback/details/330687/sql-services-start-fallback-certificate-initialization-failed-with-error-code-5
Thanks Tim, I don't for a second think that I will ever be a DBA, or a Developer. I am 60 years old and trying to learn this stuff, I am also retired (and getting more tired every second). However I will continue to try.. Thanks to you folks I may be successful. Eldon
Ok here is where I am at: I un-installed MS SQL SERVER 2008 R2, Then re-installed it. I did this several times, each time I would get errors, so finally I just tried to take everything that refered to MS SQL SERVER off (uninstall) off the ccomputer. The last time I could not get MS SQL SREVER 2008 R2 to totally un-install (it is still on the list in Add/Remove Programs Dialog Box), Also I could not get MS SQL SERVER Set-up (English) to uninstall. It is saying: MS SQL SERVER R2 Common Files, and MS SQL SERVER R2 Database Engine Shared, are still installed (in a Dialog), altho they are not on the list in Add/Remove.
I am currently trying to re-install MS SQL SERVER 2008 R2 With tools, I believe that the correct file is : SQLEXPRWT_x86_ENU.exe, and that is what I am installing, but on the Feature Selection page it has options for Advanced services. Am I trying to install the correct program ? Once Again thanks for your help. Eldon
Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068052706 Exit facility code: 1212 Exit error code: 1310 Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Start time: 2011-02-12 10:40:06 End time: 2011-02-12 11:29:43 Requested action: Install Log with failure: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110212_103616\Detail.txt Exception help link: http%3a%2f%
2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26Pr odVer%3d10.50.1600.1%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024 Machine Properties: Machine name: ABCD-6051A2AB71 Machine processor count: 1 OS version: Windows XP OS service pack: Service Pack 3 OS region: United States OS language: English (United States) OS architecture: x86 Process architecture: 32 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: f:\ddf17445735f47ed2522aaafd296\x86\setup\ Installation edition: EXPRESS_ADVANCED User Input Settings: ACTION: Install ADDCURRENTUSERASSQLADMIN: True AGTSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Disabled ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASDOMAINGROUP: ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSVCACCOUNT: ASSVCPASSWORD: ***** ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CONFIGURATIONFILE: CUSOURCE: ENABLERANU: True ENU: True ERRORREPORTING: False FARMACCOUNT: FARMADMINPORT: 0 FARMPASSWORD: ***** FEATURES: SQLENGINE,REPLICATION,SSMS,SNAC_SDK FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: FTSVCACCOUNT: FTSVCPASSWORD: ***** HELP: False IACCEPTSQLSERVERLICENSETERMS: False INDICATEPROGRESS: False INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSQLDATADIR: INSTANCEDIR: C:\Program Files\Microsoft SQL Server\ INSTANCEID: MSSQLSERVER INSTANCENAME: MSSQLSERVER ISSVCACCOUNT: NT AUTHORITY\NetworkService ISSVCPASSWORD: ***** ISSVCSTARTUPTYPE: Automatic NPENABLED: 0 PASSPHRASE: ***** PCUSOURCE: PID: ***** QUIET: False QUIETSIMPLE: False ROLE: AllFeatures_WithDefaults RSINSTALLMODE: FilesOnlyMode RSSVCACCOUNT: RSSVCPASSWORD: ***** RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQLBACKUPDIR: SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS SQLSVCACCOUNT: NT AUTHORITY\LOCAL SERVICE SQLSVCPASSWORD: ***** SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: ABCD-6051A2AB71\abcd SQLTEMPDBDIR: SQLTEMPDBLOGDIR: SQLUSERDBDIR: SQLUSERDBLOGDIR: SQMREPORTING: False TCPENABLED: 0 UIMODE: AutoAdvance X86: False Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110212_103616\ConfigurationFile.ini Detailed results: Feature: Database Engine Services Status: Failed: see logs for details MSI status: Passed Configuration status: Passed Feature: SQL Client Connectivity SDK Status: Passed MSI status: Passed Configuration status: Passed Feature: SQL Server Replication Status: Failed: see logs for details MSI status: Passed Configuration status: Passed Feature: Management Tools - Basic Status: Failed: see logs for details 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\20110212_103616\
SystemConfigurationCheck_Report.htm This is the current summary log. enter code here
