SQL

FIX for SQL cluster instance install error: “There was an unexpected failure during the setup wizard. The service cannot be started, either because it is disabled, or because it has no enabled devices associated with it”

by File in: SQL

I received the following generic popup message when installing a new instance on SQL 2005 SP3 cluster running on Windows Server 2003 R2:  There was an unexpected failure during the setup wizard.  The service cannot be started, either because it is disabled, or because it has no enabled devices associated with it.   The active […]

SQL query to find BES UserID

by File in: Blackberry

Had a support call today about a user not receiving email on his Blackberry device.  After a phone call to Research in Motion, we determined the user was out of the coverage area.  Very frustrating.  All the information was in the Blackberry Enterprise Server’s MAGT log, I just didn’t know how to find it.  Here’s […]

Fix: SQL Configuration Manager Connection to target machine could not be made in a timely fashion

by File in: SQL

Things didn’t go too smoothly yesterday when I was trying to reconfigure our SQL 2005 cluster and it’s database locations.  At one point I couldn’t even get SQL Configuration Manager to start up.  At various times I received both of the following errors. The request failed or the service did not respond in a timely […]

Fix: SQL agent wont start on Windows 2003 Cluster, Event 53

by File in: SQL

The Problem SQL Agent won’t start on a Windows cluster for a particular instance The Symptoms Seen in Windows Application log   Event: 53 Source: SQLAgent$CF3Common Category: Failover   [sqagtres] OnlineThread: Error 6 bringing resource online. [sqagtres] OnlineThread: ResUtilSetResourceServiceEnvironment failed (status 6)   The Cause   In Cluster Administrator, the SQL Server Agent had lost […]

SQL Query to determine Blackberry MDS Services administration password

by File in: Blackberry

I was troubleshooting a Blackberry Manager problem today that required the BES MDS credentials.  The admin thought he knew what the credentials were, but wasn’t sure.  So I wrote the following SQL query and ran it against the Blackberry Enterprise Server’s BesMgmt database to get the user name and password:   Use BesMgmt select WSAdminUserName, WSAdminPassword from […]

FIX: Event ID: 57860 “An error occurred while attempting to log in to the following server… SQL error number: “0011” is seen when backing up a server with SQL installed

by File in: backup

Exact Error Message Event ID: 57860 Source: Backup Exec Type: Error Description: An error occurred while attempting to log in to the following server: “SERVERNAME”. SQL error number: “0011”. SQL error message: “[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied   Details:   This error will occur when performing any type of backup on […]

How to change the SQL sa password from a command prompt

by File in: howto

To change the SQL sa password from a command prompt: Start a command prompt by typing Start – Run – cmd Enter the following commands, pressing Enter after each line OSQL -S yourservername -E     1> EXEC sp_password NULL, ‘yourpassword’, ‘sa’     2> GO Where yourservername is the name of your server and yourpassword is the new […]

Howto: Determine the SQL 2000 Version

by File in: howto

KB 321185 describes how to determine the version of SQL Server you are running. To determine which version of SQL you are running, enter the following into the SQL Query Analyzer: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The results are: • The product version (for example, 8.00.534). • The product level (for example, “RTM” or […]

Sonicwall Viewpoint 4.1 Installation Error: SQL Server does not exist or access denied

by File in: diagnostics, howto

At one of my client locations we use Sonicwall’s Viewpoint reporting system to gather usage data from the Sonicwall firewall and content filter.  Viewpoint is a pita to upgrade or move to a new machine, and I treat the program with care, since it’s very easy to unintentionally break. I was upgrading from an old version […]