Red Gate forums

RE: Issues with Monitored Server connections v3.4.1.4

JoeGT — Tue, 18 Jun 2013 23:06:25 GMT

Hi Eddie

I have followed the instructions in your link to check WMI. (minus the screenshots)

Testing WMI

At the command prompt, run:
wbemtest

In the Windows Management Instrumentation Tester dialog box, click Connect.

In the Namespace box, type \\myserver.example.com\root\cimv2 where myserver.example.com is the name of the
Windows server you are attempting to monitor.

Under Credentials, enter the Windows account you are using to monitor the server and the password. This is the account listed under Credentials on the Monitored serverspage in SQL Monitor (Configuration > Monitored servers).

Click Connect.
Click Query and enter the following query:
SELECT Name FROM Win32_Service
Click Apply. You should see a list of results similar to those shown below:

If connection fails and an "Access Denied" error message is displayed, see WMI Troubleshooting and WMI Isn't Working!.

I get exactly the same issue when I try these tests with the error:

"User credentials cannot be used for local connections"

So back to my question - is the issue that I cant have the Base Monitor running on a host server that belongs to an SQL cluster and use domain account credentials ie. the base monitor is running on the instance that I am monitoring and that instance is the member of a cluster.

Cheers

Joe

SQL Error 17

cpetrich — Tue, 18 Jun 2013 21:14:59 GMT

I registered a named instance <servername>\LOCALDEV. I used the wizard.

Backup failed, complaining it couldn't find the server. Note that the server name is NOT LOCALDEV\LOCALDEV

See below

I have no idea why it is trying to connect to a server named <instancename>\<instancename>

Thank you

SQL Backup log file 7.1.0.72

-SQL "BACKUP DATABASE [License_Apps] TO DISK = 'T:\FileTransfer\SGN2SGN\_License_Apps.sqb' WITH ERASEFILES = 1b , CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, INIT, THREADCOUNT = 3, COPY_ONLY "

----------------------------- ERRORS AND WARNINGS -----------------------------

6/18/2013 1:27:48 PM: Backing up License_Apps (full database) on LOCALDEV instance to:
6/18/2013 1:27:48 PM: T:\FileTransfer\SGN2SGN\_License_Apps.sqb

SQL error 17: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Server : LOCALDEV\LOCALDEV
Windows authentication
6/18/2013 1:28:06 PM: Failed to connect to SQL Server instance: LOCALDEV\LOCALDEV

RE: Generic Question: Redgate vs Visual Studio

Evan Moss — Tue, 18 Jun 2013 16:42:45 GMT

Hi Rogue,

You might want to check out this document: https://www.dropbox.com/s/n0t6xctln3agy8a/Agile%20vs%20SSDT.pdf

There's a two week free trial of SQL Connect available here: https://www.red-gate.com/dynamic/products/sql-development/sql-connect/download

Thanks,
Evan

RE: 3.4.1.4 Installer error 0x800b0110

PDinCA — Tue, 18 Jun 2013 16:34:17 GMT

That's true, Priyasinha, James is handling this.

The 3.3.0.270 installer was downloaded without incident. There's definitely something in the 3.4.1.4 exe that Sophos doesn't like the look of. Microsoft Security Essentials OK'd it, though.

Reverting to 3.3 was the only solution.

Note to self (and others), "When verification of an installer download gives this error, DO NOT continue - you will have to uninstall the product to get a working version".

RE: SQL Prompt causing VS 2012 crash on exit

adam0101 — Tue, 18 Jun 2013 15:24:16 GMT

I think this same problem is causing SSMS 2012 to crash on exit as well. This is the error I see in the event viewer:

Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0020001, exception address 76CD4B32
Stack:

I think it might be related to this issue: http://connect.microsoft.com/VisualStudio/feedback/details/336844/static-variable-in-native-method-causes-exception-c0020001-during-process-exit

RE: The "Duplicate object name has been found" C# Exception

ghendric — Tue, 18 Jun 2013 14:37:08 GMT

Has this bug been resolved in the latest version of SQL Prompt?

RE: Confusion about UsageCounter vs UsageReporter

Chris.Allen — Tue, 18 Jun 2013 14:05:48 GMT

Sorry for the lack of documentation.

Use:

UsageCounter.ReportUsage

The other one is deprecated.

RE: Control when feature usage data is sent

Chris.Allen — Tue, 18 Jun 2013 14:03:15 GMT

Truly sorry but no- this is not part of the architecture.

RE: 3.4.1.4 Installer error 0x800b0110

priyasinha — Tue, 18 Jun 2013 12:37:08 GMT

Hi Stephen,

I think you already have a open case with Support. We are investigating this and we are suspecting that it may be something to do with antivirus. We have trying to contact the antivirus company. Support will get back to you as soon as we have finished investigating.

Thanks,
Priya

RE: Feature usage reporting with multiple assemblies

DanielRose — Tue, 18 Jun 2013 12:19:40 GMT

williamw wrote:

In your SmartAssembly projects I assume you only turned on usage reporting for that one assembly, and not for the ones that are calling it to do reporting?

Exactly. I have two different SA project files. One has usage and crash reporting on (which I use for only that "core" assembly) and the other one has only crash reporting on (which I use for everything else).