SQL

Question Can Microsoft ODBC Driver for SQL Server be used with an Enterprise system running OnGuard 7.3 Update 1? Answer  Microsoft ODBC Driver for SQL Server uses TLS 1.2, which is not compatible with the Message Broker service.  It canno...

Improving indexes and providing a performance increase when running reports   Procedure Steps   The first 3 SQL commands provide the most improvement. The other 2 are also necessary for overall improvement. If you have any questions, pleas...

Symptom When running Database Setup, an error occurs: Description: Database error: The specified schema name "LENEL" either does not exist or you do not have permission to use it. Details: Database error executing a statement. (CREATE TABLE...

Symptom   The following error may occur when manually creating the AccessControl database:   "Create failed for database AccessControl"   The following is additional information for this error:   "...an exception occured while exe...

How do I configure SQL and SQL native client to accept ODBC connections? Procedure Steps On the Database Server, locate and launch SQL Server Configuration Manager. Expand the following three headers to view the protocols: SQL Native Client...

Symptom The following error might occur during Database Setup: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "UA_USER_FK". The conflict occurred in database 'AccessControl', table'dbo.USERS', column 'USERID'. Details: D...

Symptom Error message: ODBC connection error named pipes provider; Could not open a connection to SQL server. Connection failed. Resolution 1.      Open SQL Server Configuration Manager 2.      Expand SQL Server Network Configurat...

How to determine if you are running SQL Express or SQL Standard Procedure Steps In SQL Server Management Studio, run the following query:   SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition'...

How to perform a clean uninstall of Microsoft SQL Server Procedure Steps Important: Modifying the registry could cause irreversible damage to your Windows operating system; be sure to back up the registry before making any changes. Follow t...

Question In SQL Server Management Studio, why is there a red arrow pointing down in the icon next to a login? This icon can be found in the Object Explorer. Expand Security , then expand Logins , and note that one or more of the login icons c...