Skip to content

Windows 2012 – RDP password change even when NLA is enabled

If NLA is enabled on 2012 and your password expires you will be unable to login

To be able to reset your password add the following to default.rdp in your user profile\documents folder

Sometimes you try to open a remote desktop connection to a machine only to get an error message that “the password has expired”.

rdperror

Add the following setting to your .rdp file (“C:\Users\<User>\Documents\Default.rdp” if you aren’t using a specific one).

enablecredsspsupport:i:0

Then run mstsc and connect you’ll be able to change the password

SSRS Subscription Auth Error

I recently moved some SSRS subscriptions between domains, there is a oneway trust between them, however when publishing a report to the desination domain using a user in the source domain the subscription errors with the following.

library!WindowsService_0!182c!12/23/2015-10:34:13:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: AuthzInitializeContextFromSid: Win32 error: 5; possible reason – service account doesn’t have rights to check domain user SIDs., Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;

This is happens because SSRS needs to verify the subscription owner’s access to the report prior to generating and sending it. This error occurrs when you choose Windows  File Share or Send e-Mail option. As the source domain didn’t trust the destination domain that it why this failed.

However a fix bit of SQL to fix up the Subscription owner was all that was needed.

The SQL below will set the owner to be “NT Authority\System” to all subscriptions

Use ReportServer
Go
Declare @System as varchar (200)
Select @System=(Select UserId from Users where UserName= ‘NT AUTHORITY\SYSTEM’)
–Select * from dbo.Subscriptions where OwnerID <> @System
Update dbo.Subscriptions set OwnerID=@System where OwnerID <> @System

I hope this can help others 🙂

 

HSMM Mesh on Raspberry Pi

VA3PAW

Broadband-Hamnet™ (formerly called HSMM-Mesh™)  is a high speed, self discovering, self configuring, fault tolerant, wireless computer network that can run for days from a fully charged car battery, or indefinitely with the addition of a modest solar array or other supplemental power source. The focus is on emergency communications.

In its current form it is built using the Linksys WRT54G/GL/GS wireless routers and operates on channels 1-6 of the 2.4GHz ISM band, which overlaps with the upper portion of the 13cm amateur radio band. Other platforms and bands are in development at this time. Next will be Ubiquiti equipment with others supported as development resources permit.

It’s fairly easy to flash an old Linksys WRT54G router with HSMM-Mesh (now called BroadbandHamnet-v1) firmware. The downside is that the routers are fairly old and not that easy to find anymore. Plus, they are fairly limited in functionality. It would be more interesting…

View original post 737 more words

SQL 2012 HA Groups fully unattended

Jerome's Blog

Hi all. As part of a XenDesktop 7.5 automated deployment, I have to deploy SQL 2012 silently. For redundancy needs, we use High Availability Groups. We also use the Managed Service Accounts brought by Windows 2008 R2. Here is the how-to.

View original post 1,494 more words

NetApp Snapdrive for SQL

Here’s a quick post about an Issue I’ve just had. Suddenly Snapdrive for SQL stopped working and was reporting this in the logs.

[11:35:05.303] [SQLSERVER] *** SnapManager for SQL Server Report

[11:35:05.303] [SQLSERVER] Getting SQL Server Database Information, please wait…
[11:35:05.303] [SQLSERVER] Creating thread for enumerating all databases from all nodes…
[11:35:05.303] [SQLSERVER] Waiting for the threads to finish enum all databases…
[11:35:05.304] [SQLSERVER] Get database and LUN information…
[11:35:05.304] [SQLSERVER] Getting virtual disks information…

[11:35:05.304] [SQLSERVER] Starting SDAPI storage enumeration…
[11:35:08.331] [SQLSERVER] Querying SQL Server instances installed…
[11:35:08.334] [SQLSERVER] Creating threads for enumerating databases of different SQL Server instances.
[11:35:08.334] [SQLSERVER] Waiting for the threads to finish enumerating databases.
[11:35:09.251] [SQLSERVER] [SMO] Connecting to SQL Server instance – SQLSERVER…
[11:35:09.252] [SQLSERVER] [SMO] Querying database information…
[11:35:10.386] [SQLSERVER] All threads finished enumerating databases.
[11:35:10.387] [SQLSERVER] Validating database configuration…
[11:35:10.387] [SQLSERVER] Setting database disk configuration…
[11:35:10.387] [SQLSERVER] Setting database locating on SQLRoot path…
[11:35:10.388] [SQLSERVER] Querying database disk volume configuration…
[11:35:10.388] [SQLSERVER] Getting SnapInfo directories configuration…

[11:35:10.390] [SQLSERVER] Checking dataset availability, connecting to SnapDrive…
[11:35:10.831] [SQLSERVER] Dataset feature is currently unavailable.
[11:35:10.831] [SQLSERVER] Getting SnapManager dataset info from…
[11:35:10.831] [SQLSERVER] Dataset info file has not yet created.
[11:35:10.833] [SQLSERVER] Database requested has not been configured for backup.
This database is marked as:Database file is on unsupported volume, possibly local disk..
Server:SQLSERVER Database:DATABASE.
This Database will be skipped.
[11:35:10.833] [SQLSERVER] Error Code: 0xc0040900
Unable to find any valid databases to be backed up.

[11:35:10.834] [SQLSERVER] Preparing for sending filer AutoSupport…
[11:35:10.834] [SQLSERVER]
[11:35:10.834] [SQLSERVER]
[11:35:10.834] [SQLSERVER]

After lots of digging I noticed in the filer audit.log there was no entries for the login. This go me thinking… Can the SQL server see the filer? Answer was no, I attempted to resolve the filer’s name from the SQL server and it wouldn’t resolve.

I checked DNS and it had lost the filer’s dns record.

I put it back in and it’s all working now.

Please note that the above error also happens if the credentials are incorrect.

**Snapdrive password for filer must be =< 14 Character otherwise SnapDrive truncates it to 14 Chars.

The Performance Overview tab fails to display with the error

To Change webservices to port 8445

Open C:\Program Files\VMware\Infrastructure\tomcat\conf\catalina.properties

Edit the line that looks like the one below ( The 8445 is a custom port that I’ve used)

bio-vmssl.https.port=8445

Then follow Vmware KB 2001986 or 1010725 to repoint the client

Then open cmd box on the vc server and run

 

“C:\Program Files\Common Files\VMware\VMware vCenter Server – tc Server\bin\winx86_64\wrapper.exe” “C:Program Files\VMware\Infrastructure\tomcat\conf\wrapper.conf”

This will run tomcat in non-service mode   (this will show any errors in the command window)

To exit press Ctrl+C

Once done start the service as normal

Cluster network name resource failed to create its associated computer object in domain

The Windows Server HA Blog

A lot of cluster errors starts here just because the cluster account has no access in the Active directory.

A sample of a DHCP server that is just created is failing.

Cluster network name resource ‘MVPDHCP79’ failed to create its associated computer object in domain ‘mvp.local’ during: Resource online.

The text for the associated error code is: A constraint violation occurred.

Please work with your domain administrator to ensure that:

– The cluster identity ‘CLUSTER12$’ has Create Computer Objects permissions. By default all computer objects are created in the same container as the cluster identity ‘CLUSTER12$’.

clip_image015_thumbclip_image017_thumb

In the cluster manager you can see the just created resources and as you can see the DHCP resource is not online. Why ? well in the error screen you can see

clip_image019_thumb

Cluster network name resource ‘MVPDHCP79’ failed to create its associated computer object in domain ‘mvp.local’ during: Resource online.

The text for the…

View original post 262 more words