TestElite - Troubleshooting Troubleshooting
Contents
1. 1 ESOL Server SQLEXPRESS Running Automatic a SQL Server Agent SQLEXPRESS Stopped Other Boot System SQL Server Browser Properties Log On Service Advanced El General Start Mode Automatic Troubleshooting Page 7 Troubleshooting 2 Back to SQL Server Configuration Manager right click on SQL Server Bowser on the right window and select Start to start the service On the left window expand SQL Server Network Configuration gt Protocols for SQLEXPRESS You see that TCP IP protocol status is disabled Right click on TCP IP and select Enable to enable the protocol ja Sql Server Configuration Manager File Action View Help e 098 X SQL Server Configuration Manager Local SQL Server Services 4 SQL Server Network Configuration le Protocols for SQLEXPRESS d 3 SQL Native Client 10 0 Configuration Enable selected protocol Protocol Name Shared Memory Y Named Pipes Yy VIA Status Enabled Disabled Disat Properties Help Troubleshooting Page 8 Troubleshooting 3 Restart the SQL Server 2005 2008 instance and services 1 On the left window select SQL Server Services Select SQL Server SQLEXPRESS on the right window gt click Restart The SQL Server service will be restarted a Sql Server Configuration Manager File Action View Help eo OFB 9956 SQL er Configuration Manager Local HICSQL Server Services J SQL Server Network2. ab DefaultDomainNa REG SZ HP PROBOOK REG SZ ella REG SZ Administrator iu forceunlocklogon REG_DWORD OxOO0O000000 C I amp i HibernationPrevi REG DWORD OxO00000001 1 ab LegalNoticeCaption REG SZ a8 LegalNoticeText REG SZ 52 LogonType REG_DWORD 0x00000001 1 passwordexpiryw REG_DWORD Ox0000000e 1 lab powerdownaAfter REG SZ 0 ab ReportBootOk REG SZ 1 ab scremoveoption REG SZ o 3 DefsultPassword 4 Sy Winlogo a C wow Cy WPAE ve Windows Script Windows Scripti 0x00000000 C le 13 SFCDisable Bi sfeQuota ab Shell REG DWORD REG DWORD REG SZ OxFFFFFFFF 429 Explorer exe e CY Policies Program Groups wW E Schlumberger C Secure amp J windows 3 1 Migrat R ShowLogonOptions REG_DWORD 0x00000000 C a ShutdownWithou REG SZ 0 ab System REG SZ lab UIHost REG_EXPAND_SZ GU Ga SYSTEM ab Userinit REG SZ C WWINDOWS c Cg HKEY_USERS ab vmApplet REG SZ rundil32 shell3z c CJ HKEY CURRENT CONFIG y ab winStationsDisab REG Sz o lt gt MES il My Computer HKEY_LOCAL_MACHINE SOFTWARE Microsoft windows NT CurrentVersion Winlogon logonul exe gt wikitow Troubleshooting Page 14 Troubleshooting Create or Open and fill the String Type value of AutoAdminLogon with the data 1 To set up the the desired DomainName modify the data from value DefaultDomainName DEE Registry Editor File Edit View Favorites Help E Lan
3. SQL Server Management Studio 2 In the SQL Server Management Studio right click on the SQLEXPRESS instance and select Properties and on the upcoming dialog click Connections and after at Remote server connections check Allow remote connections to this server Maximum number of concurrent connections 0 unlimited 10 a Use query govemor to prevent long running queries 10 Default connection options implicit transactions cursor close on commit ansi wamings ansi padding ANSI NULLS arithmetic abort Connection Remote server connections Allow remote connections to this server Remote timeout in seconds 0 no timeout S note query n sa 600 H Server v FLASHMAN2NSQLEXPRESS 349 View connection properties Require distributed transactions for serverto server communication Progress Ready Troubleshooting Page 5 shooting 2 Turn on the SQL Server Browser service SQL Server 2005 1 On the SQL Server 2005 Surface Area Configuration page click Surface Area Configuration for Services and Connections and after click SQL Server Browser click Automatic for Startup type and then click Apply Surface Area Configuration for Services and Connections localhost SQL Server 2005 Surface Area Configuration b Help Protect Your SQL Server Enable only the services and connection types used by your ap
4. Configuration Hle Protocols for SQLEXPRESS d 3 SQL Native Client 10 0 Configuration Restart stop and then start selected service State Running Running Restart Properties Help Troubleshooting Page 9 Troubleshooting 2 Open Microsoft SQL Server Management Studio and right click on the SQL Server Instance and select Restart Ka Microsoft SQL Server Management Studio File Edt View Tools Window Community Help r 10 0 1600 Connect Disconnect Register New Query Activity Monitor Start Stop Pause Policies Facets Start PowerShell Reports Refresh Properties Troubleshooting Page 10 4 Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service 1 To open Windows Firewall click Start click Run type firewall cpl and then click OK 2 To create an exception for SQL Server 2005 2008 in Windows Firewall follow these steps in Windows Firewall click the Exceptions tab and then click Add Program Browse the following programs click Ok C Program Files Microsoft SQL Server MSSQL 1 MSSQL Binn sqlservr exe or C Program Files Microsoft SQL Server MSSQL10_50 SQLEXPRESS MSSQL Binn sqlservr exe C Program Files Microsoft SQL Server 90 Shared sqlbrowser exe More information http support microsoft com kb 914277 http www linglom com 2007 08 31 enable remote connectio
5. TestElite Troubleshooting 1 0 Bal zs Mayer 2014 TestElite All Rights Reserved Troubleshooting This document isa collection of the frequented asked questions FAQ for solving the general but non trivial problems which have already appeared more than once The document is valid for TestElite O software productasitisa part of the documentation Troubleshooting Pagei Revision Sheet Revision History Revision Description 08 21 2014 Template creation initial draft Troubleshooting Page ii TRAMO ta Sere 1 How to enable remoting on Windows machines occoooroomocosnsnssso 1 2 Remote Database Acce e is 3 How to connect to remote SQL database cmoconommmssmmsmsmmmmmssmssms 3 X SABIO LOQIIL AA eee d a di ale tez ate aa ele co ea el 12 How to enable automatic logon in Windows essessseseossososeseoscocoseseoeoscoseseseoscososeseososeosese 12 Page 0 1 Remote Settings How to enable remoting on Windows machines Possible error messages during remote access Access is denied Logon failure unknown user name or bad password For remote access you have to do the following settings on the remote machines The impersonated user who is running TestElite RemotingServer exe needs to have admin rights on the remote computer and the user must be the member of Administrators group Further settings on Vista and Windows 7 1 First of all you need to have File and Pri
6. b DefaultDomainNa passwordexpiryw ae ab Shutdownwithou as Type REG_SZ REG SZ REG SZ REG SZ REG DWORD REG SZ REG SZ REG SZ REG DWORD REG SZ REG SZ REG SZ REG SZ REG SZ REG DwWORD REG DWORD REG SZ REG SZ REG DWORD REG DWORD REG SZ REG SZ REG SZ REG DWORD REG DWORD REG SZ REG DWORD REG SZ REG SZ E Microsoft Windows NT CurrentVersion Winlogon EE Data value not set o o o OxOOOO0001 1 HP PROBOOK HP ProBook o OXxDODODOO1 1 000 10 no HP PROBOOK Administrator A Troubleshooting Page 12 Troubleshooting Create or Open and fill the String Type value of DefaultUsername with the desired username Registry Editor File Edit View Favorites Help 59 LanguagePack LJ LastFontSweep 3 mci C MCI Extensions e mci3z2 C Midimap C ModuleCompatibility amp CL Network e CC NetworkCards a E Perflib C PerHwIdStorsge CG Ports G Prefetcher e C Print e C ProfileList 3 related desc e C secEdit 1 Setup m C SvcHost amp C SystemRes w E Termina e C Tim ce CO EZ pe 1 Installer Userinstallable drive C windows amp CN Winlogon a oj wow C wPAEvents e CC Windows Script Host a C Windows Scripting Host Name ab Default 25 allocatecdroms ab allocatedasd ab allocatefloppies 5 AllowMultipleTSS ab AltDef aultDomain T ab altDefaultUserNa sss ab AutoAdminLogon 8 autoRestartShell ab Background ab cochedlogo
7. guagePack LJ LastFontSweep MCI 9 MCI Extensions ES mMcI32 a C Networkg Prefetcher E ProfileList related desc eu C Secedit amp E Setup amp SJ SvcHost eu E SystemRestore e E Terminal Server a C Time Zones amp ES Tracing amp CJ Type 1 Installer Userinstallable driver C Windows 3 Winlogon 3 Credentials amp GPExtensions e E Notify sw GJ SpecialAccounts ES WOW i a gt My Computer HKEY LOCAL MACHINEYSOFTWAREYMicrosoftiwindows NTYCurrent V Name a AltDef aultDomain as AltDefaultUserNa La AutoAdminLogon Ej AutoRestartShell ab cachedlogonscount ab DebugServercom ab DefaultDomainNa ab Def aultUserName 2 Forceuntocklogon 2 HibernationPrevi ab LegaiNoticeCaption 2B LegalNoticeText amp LogonType 5 passwordexpiryw cee ab Powerdownafter ab ReportBootOk ab scremoveoption opem SfcQuota ab shell 83 ShowLogonOptions ab ShutdownWithou ab System a UIHost ab Userinit ab vmApplet a5 WinStationsDisab ab DefaultPassword lt liil Type REG SZ REG SZ REG SZ REG DWORD REG SZ REG SZ REG SZ REG SZ REG SZ REG DWORD REG DWORD REG SZ REG SZ REG DWORD REG DWORD REG SZ REG SZ REG SZ REG DWORD REG DWORD REG SZ REG DWORD REG SZ REG SZ REG EXPAND SZ REG SZ REG SZ REG SZ REG SZ ersion Winlogon Data HP PROBOOK HP ProB
8. he default settings SQL Server does not allow remote connections provider SQL Network Interfaces error 28 Server doesn t support requested protocol Microsoft SQL Server Error An error has occurred while establishing a connection to the server When connecting to SQL Server this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections provider SQL Network Interfaces error 26 Error Locating Server Instance Specified Microsoft SQL Server Error Login failed for user username Microsoft SQL Server Error 18456 This problem may occur when SQL Server 2005 2008 is not configured to accept remote connections By default SQL Server 2005 2008 Express Edition and SQL Server 2005 2008 Developer Edition do not allow remote connections To configure SQL Server to allow remote connections complete all the following steps Note Changes to Connection Settings will not take effect until you restart the Database Engine service Troubleshooting Page 3 1 Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer SQL Server 2005 1 Click Start point to Programs point to Microsoft SQL Server 2005 point to Configuration Tools and then click SQL Server Surface Area Configuration 2 On the SQL Server 2005 Surface Area Configuration page click Surface Area Configuration for Services and Connections then expand Databa
9. n to sql server 2005 express http www linglom com 2009 03 28 enable remote connection on sql server 2008 express Troubleshooting Page 11 Troubleshooting Auto Login How to enable automatic logon in Windows Using RegEdit navigate to the registry key HK EY LOCAL MACHINENSOFTWARI Registry Editor File Edi View Favorites Help CC LanguagePack CG LastFontSweep Sj mcr GY MCI Extensions a EY McI32 G Midimap EJ ModuleCompatibility e LJ Network m C NetworkCards amp Perflib W C PerHwldStorage 3 Ports E Prefetcher e E Print e C ProfileList E related desc amp Ga SecEdit Setup m GY SvcHost eu J SystemRestore e Terminal Server m C Time Zones e ES Tracing i LJ Type 1 Installer G userinstallable drive Ca windows o ZEN a C wow C WPAEvents w C3 Windows Script Host CL windows Scripting Host a E wzcsvc t lt Name ab Default ab allocatecdroms ab allocatedasd ab allocatefloppies 5 AllowMultipleTSs ab AutoAdminLogon AX AutoRestartShell ab Background ap cachedlogonscount ab DefaultUserName RS forceuntockdogon Bi HibernationPrevi ab LegalNoticeCaption ab LegalNoticeText EX LogonType ab PowerdownAfter ab ReportBootOk ab scremoveoption 8X SFCDisable ES SfcQuota ab Shell 52 ShowLogonOptions ab System ab AltDef aultDomeain ab AltDef aultUserNa aB DebugServerCom AS a
10. nscount ad DebugServercom aD DefaultDomainNa 1 Def aultUserName 2 Forceuntocklogon na HibernationPrevi 3B LegalNoticeCaption ab LegalNoticeText RZ LogonType passwordexpiryw ab Powerdownafter eee ab ReportBootOk ab scremoveoption Bi SFCDisable a3 SfcQuota ab Shell 82 ShowLogonOptions ab Shutdownwithou T Type REG SZ REG SZ REG SZ REG SZ REG DWwORD REG SZ REG SZ REG SZ REG DWORD REG LSZ REG SZ REG SZ REG SZ REG SZ REG DwWORD REG DWORD REG SZ REG SZ REG DwWORD REG DWORD REG SZ REG SZ REG Sz REG DWORD REG DWORD REG SZ REG DWORD REG SZ value not set 0 o o 0x00000001 1 HP PROBOOK HP ProBook o 0x00000001 1 000 10 no HP PROBOOK Administrator 0x00000000 C 0x00000001 1 0xOO0000001 1 Ox0000000e 1 o 1 0 Ox00000000 C OxfFFFFFFE 429 Explorer exe REG SZ lt i m ia My Computer HKEY_LOCAL_MACHINE SOFTWARE Microsoft Windows q ES wzcsvc lat System Troubleshooting Page 13 Troubleshooting Create or Open and fill the String Type value of DefaultPassword with the desired password Registry Editor File Edit View Favorites Help s E Perflib A Name Type amp EY PerHwic AB AltDefaultDomain REG SZ C Ports BD AltDefaultuiserNa REG SZ CI Prefetct ab AutoAdminLogon REG Sz B AutoRestartShell REG_DWORD ab Background REG SZ 000 ab cachedlogonscount REG Sz 10 aB DebugServerCom REG Sz no
11. nter Sharing enabled Control Panel Network and Internet Network and Sharing CenteN Change advanced sharing settings There are two profiles You probably don t want this on when you re on a public network so open Home or Work Under the header File and Printer sharing select the Turn on option 2 And you also need to change the registry Start Run regedit and navigate all the way to HKEY_LOCAL_MACHINE SOFTWARE Microsoft Windows CurrentVersion Policies Sys tem Right click in the pane on the right side and add a new DWORD 32 bit Give the new setting the name LocalAccountTokenFilterPolicy Double click on that setting and give it a value of 1 3 It s probably wise to reboot after doing this although it might not be needed Troubleshooting Page 1 Further settings on Windows XP 1 Turn off simple file sharing MyComputer Tools Folder options View Advanced settings http support microsoft com kb 307874 Remarks This will turn on classical file sharing Explanation By default simple file sharing is enabled on a Microsoft Windows XP based computer if the computer is not a member of a domain With simple file sharing you can share folders with everyone on your workgroup or network and make folders in your user profile private However if simple file sharing is enabled you cannot prevent specific users and groups from accessing your shared folders If you turn off simple file sharing you can permit specific users and g
12. ook o 0xOOO000001 1 000 10 no HP PROBOOK Administrator 0x00000000 C 0x00000001 1 0x00000001 1 0x0000000e 1 o 1 o 0xD0000000 C OxFfffFFFF 429 lt Explorer exe 0x00000000 C o logonui exe C WINDOWS rundll32 shell3z o ella Source http www wikihow com Enable Automatic Logon in Windows XP gt wikio Troubleshooting Page 15
13. plications Disabling unused services and connections heps protect your server by reducing the surface area For default settings see Help Select a component and then configure its services and connections a g SQLEXPRESS This service returns named pipe and TCP port information to client applications Enabling 8 i Database Engine this service is recommended for Analysis Services Service Remote Connections E ld SOL Server Browser Service name EME 1 Display name SOL Server Browser Description Provides SQL Server connection information to client computers Startup type 2 Service status Running 4 View by Instance View by Component 5 Troubleshooting Page 6 Troubleshooting SQL Server 2008 1 Click Start gt Programs gt Microsoft SQL Server 2008 gt Configuration Tools gt SQL Server Configuration Manager On SQL Server Configuration Manager select SQL Server Services on the left window Double click on SQL Server Browser the Properties window will show up Set the account for start SQL Server Browser Service to Local Service account And after move to Service tab and change Start Mode to Automatic Therefore the service will be start automatically when the computer starts Click OK to apply changes m Sql Server Configuration Manager File Action View Help Sa R Start Mode K Tsar Server Browser Stopped Other Boot System
14. roups to access a shared folder Those users must be logged on with the credentials of user accounts that you have granted access to your shared folder 2 Turn off network users identify as guests Control PanellAdministrative Tools Local Security Settings Local Policies Security OptionsV Network Access Sharing and security model for local accounts http davidchuprogramming blogspot com 2009 12 psexecexe access denied html Remarks This will turn on network users identify as themselves Explanation WinXP machines contrary to Win2K machines will map any incoming network user to the Guest account l e even if you logon saying am Administrator by default WinXP will reduce you to Guest status Guests do not have enough privileges to use the ADMINS and or execute any commands For WinXP Home this behaviour cannot be changed At least found no way to do so For WinXP Prof this behaviour is the default unless your machine is member of an Active Directory Domain Troubleshooting Page 2 2 Remote Database Access How to connect to remote SQL database When you try to connect to an instance of Microsoft SQL Server 2005 2008 from a remote computer you may receive the following error messages This problem may occur when you use any program to connect to SQL Server Error An error has occurred while establishing a connection to the server When connecting to SQL Server this failure may be caused by the fact that under t
15. se Engine click Remote Connections click Local and remote connections click the appropriate protocol to enable for your environment and then click Apply A Surface Area Configuration for Services and Connections localhost 2 SQL Server 2005 Surface Area Configuration b Help Protect Your SQL Server Enable only the services and connection types used by your applications Disabling unused services and connections heps protect your server by reducing the surface area For default settings see Help Select a component and then configure its services and connections E j SOLEXPRESS By default SOL Server 2005 Express Evaluation and Developer editions allow local amp ij Database Engine client connections only Enterprise Standard and Workgroup editions also listen for i remote client connections over TCP IP Use the options below to change the protocols Les on which SOL Server listens for incoming client connections TCP IP is preferred over E 1 Remote Connections named pipes because it requires fewer ports to be opened across the firewall ia SQL Server Browser Local connections only 2 Local and remote connections Using TCP IP only Using named pipes only 3 Using both TCP IP and named pipes Pp View by Instance View by Component 4 Troubleshooting Page4 Troubleshooting SQL Server 2008 1 Click Start point to Programs point to Microsoft SQL Server 2008 and then click
Download Pdf Manuals
Related Search