Knowledgebase
Handy Software Lab > Handy Software Lab Help Desk > Knowledgebase
» Category: SQL Server related articles  (Go back)

» Articles in this category:

 
Cannot find DAO on your system! Article rated 3.0/5.0
You must install DAO 3.6. It is already installed if you are running Microsoft Office 2000 or Microsoft Office XP. If this is not the case, check whether DAO 3.6 is installed. To do so, look for the file in the following directory: C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll ...
Installing SQL 2005 Express Edition Article rated 3.0/5.0
SQL Server 2005 - Express Edition is a 'Free' product that Microsoft has provided for use within smaller production environments. It primary limitation in a network is the maximum database size which is limited to 4GB per database. Though the maximum database size is likely sufficient for...
An error has occurred while establishing a connection from the remote computer to the SQL server Article rated 3.0/5.0
Details Product: SQL Server ID: -1 Source: MSSQLServer Version: 10.0 Component: SQLEngine Message: An error has oc...
How to Change Server Authentication Mode Article rated 3.0/5.0
During installation, SQL Server Database Engine is set to either Windows Authentication mode or SQL Server and Windows Authentication mode. This topic describes how to change the security mode after installation. If Windows Authentication mode is selected during installation, the sa login is ...
Authentication Mode Article rated 3.0/5.0
SQL Server Express users: click Authentication Mode (SQL Server Express) for information that is specific to SQL Server Express Setup. Use the Authentication Mode page of the Microsoft SQL Server Installation Wizard to choose the security mode used to authenticate client and server conne...
Recover the master database in SQL Server Article rated 3.0/5.0
As a Microsoft SQL Server administrator, you must know how to recover a corrupt master database. The master database stores your logins and, most importantly, the pointers to all of your databases. Without the master database, you can't successfully start SQL Server. I'm going to walk you...
Error: 9003, Severity: 20, State: 1 in MS-SQL Server 2000 Article rated 4.0/5.0
  Even though the SQL Server is installed on D: the default location of the databases seems to be set to C:, so its looking in 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ folder for model.mdf' and modellog.ldf. You would have to make sure that these are in the righ...
FIX: SECDoClientHandShake Cannot Connect to SQL Server Article rated 3.0/5.0
This article was previously published under Q322144 SYMPTOMS loadTOCNode(1, 'symptoms'); When attempting to connect to Microsoft SQL Server 2000, you may receive one of the following error messages: Unable to connect to server. Server msg 18, level 16, state 1. SSL secur...
Error 4005: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] Article rated 3.0/5.0
The "Error 40421" error message may include the following additional error information: Error 4005: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error. Possible problem: SQL authentication is set to 'Windows only' mode. Please set this to 'SQL Se...
How to enable SQL Server connectivity on Windows XP Service Pack 2 Article rated 3.7/5.0
INTRODUCTION loadTOCNode(1, 'summary'); This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2. By default, Windows Firewall is enabled on computers that are running Microsoft Windows XP Service Pack 2. Windows Firewall closes ports such as ...
TCP Ports Needed for Communication to SQL Server Through a Firewall Article rated 3.4/5.0
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall View products that this article applies to. Article ID : 287932 Last Review : February 8, 2006 Revisio...
Configure a Firewall for SQL Server Access Article rated 3.0/5.0
Firewall systems prevent unauthorized access to computer resources. To access an instance of the Microsoft SQL Server Database Engine through a firewall, you must configure the firewall on the computer running SQL Server to allow access. For general information about how SQL Server works with...
Manual Uninstall of SQL 2005 SQL Server or Express (including Reporting Services) Article rated 4.3/5.0
by  AGILEIT\john  on 3/4/2008 9:28 AM I had issues uninstalling the 32 bit SQL 2005 Express and SQL 2005 Standard from a customers machine running Windows 2003 64bit.   This was due to Systems Center Essentials requirement of having a 64 bit SQL when running on a...
How to Uninstall SQL Server 2005 Express Article rated 3.0/5.0
Click Start, and then click Control Panel. Open Add or Remove Programs. Select Microsoft SQL Server 2005, and then click Remove. The Component Selection page appears. By default, the Remove SQL Server 2005 instance components check box is selecte...
How to uninstall an instance of SQL Server 2005 manually Article rated 3.0/5.0
This article describes how to uninstall a stand-alone instance of Microsoft SQL Server 2005 manually. If you follow the steps in this article, you prepare the system so that you can reinstall SQL Server. For more information about how to uninstall a SQL Server 2005 failover cluster manually,...
Saving changes is not permitted (SQL Server 2008/2008 R2) Article rated 4.2/5.0
While creating and editing a database in SQL server 2008 I soon ran into a brick wall, or a 'by design' feature of the Database Management Studio. When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Databa...
How to fix SQL Error 8942 Article rated 3.0/5.0
The Microsoft SQL Server table can cause corruption the reason is uninvited corruption, hardware bugs, software bugs, comparable faults, and therefore results into DBCC CHECKDB errors or inaccessible database table. For fixing these issues, it is important to bring back from that server backup. H...
 

© 2012 Handy Software Lab. All Rights Reserved.