SOLVED! Moving RDS to a new SQL server

We have been trying to figure out what we needed to do to get our RDS server moved to another SQL server during a DR situation.

The message we were getting in the event log was:

The Remote Desktop Management service terminated with the following service-specific error %%4294967295

Now I looked at several articles online and there was a lot of different ideas, but in the end, with the help of my SQL Admin we figured it out! 

On my Windows 2012 R2 RDS Broker server I went into the registry searching for the connection string to the SQL server. It was located in the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tssdis\Parameters key.

The DBConnString value had the whole connection string in there! Here is where we stumbled a little...(yes, I am a little slow on the uptake sometimes) 

DRIVER=SQL Server Native Client 11.0;SERVER=OURSQLSERVER,64229;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=RDBrokers

The number....right after SERVER=OURSQLSERVER? 64229? That is the port that our instance of SQL was originally running on. Turns out when we restored the SQL instance to our new server...the port had changed!

DOH!

So we went into SQL Server Configuration Manager, selected the SQL Server Network Configuration, Protocols for (Instance Name), selected TCP/IP, right clicked and selected properties. Once the TCP/IP properties dialog box comes up, select the IP Addresses tab and in our case we scrolled to the bottom of the page to TCP Dynamic Ports under the IPALL heading and found the new port our SQL instance was running under.

Now, to get RDS up and running we could do one of two things....We can change the port the SQL instance is running under, stop and restart the SQL instance....or we can change the connection string that we referenced earlier. So we chose to do the later. We changed the 64229 port in the connection string to the new port 64225 and WHAM!!! RDS Management service started right up when we started it under services.

So after a quick happy dance. We tried RDS and we were back in business!

Hope this helps someone!

Thanks for reading!

VMWorld 2016!!!

WOOHOOO!!!

I get to go this year! I'm so excited, first time going to Vegas and first time going to VMworld in Vegas! In case you haven't started booking your session....they are booking up FAST! I have already had to Favorite some in hopes that they might open up more sessions or someone might drop.

My plan is to cover as much as I can from the conference. I normally just throw up whatever highlights I see and try not to geek out too much *grin*.

 I really want to do some networking this year...so I will attempt to be a little more social. I normally go with the intentions of meeting up with the photography group or going to the Hang Space and somehow it just never seems to happen....I get plenty of pictures....but that is normally me wandering aimlessly around and finding cool stuff.

Anyway look forward to seeing everyone!

#VMworld2016

New Free eBooks from Microsoft Press

Here is the URL for some new Microsoft books. There is some good stuff out there!

https://mva.microsoft.com/ebooks?CR_CC=200687234&WT.mc_id=16265-DEV-crm_web_w04_dsd_ebookazur-1


Introducing Windows 10 for IT Professionals, Preview Edition
Introducing Microsoft SQL Server 2014
Introducing Microsoft System Center 2012 R2
Introducing Windows Server 2012 R2


and a host of other SCCM and Azure books.

Virtual Center Server Service Constantly Crashing

Ran into a new experience today. Came in from my Christmas holiday after being off for 12 days and low and behold my vCenter is not working.

Everything seems to be starting....but then it crashes out, and restarts itself. I could log into the vCenter just long enough to see all the VMs and boom. It crashed again....%^&*!!? Not the way I want to spend my first day back.....ah well...

So I poke around for a while and finally call VMware, as I had never seen this particular behavior before. We fussed around for a while until the Tech called over his senior resource (I seriously owe this guy a beer), he had us open up the vpxd log. In there we did a search for "minidump". The minidump section of the log pointed out that a VM on one of my hosts was causing the issue....

"2016-01-04T15:54:53.874-06:00 [10036 info 'Default' opID=SWI-335197fd testSet=host-62114,vm-2380] CoreDump: Writing minidump"

The next thing the senior did was to then search the log file from the top and what he found was that Network Adapter 1 on VM-2380 was mentioned in the log. Interesting ......

2016-01-04T15:54:33.484-06:00 [10036 warning 'VmCheck' opID=SWI-335197fd testSet=host-62114,vm-2380] [NetworksAccessible] virtual device "Network adapter 1" (4000) has an empty backing info

Ok the next thing he did was to search for vm-2380 in the log from the top and it gave me the exact name of the VM that was having the issue.....

At this point it was a mad scramble to log into the Hosts via the vSphere Client and find the offending VM (of course it was on the last host in our farm). We did an "edit settings" on the VM and saw the Network Adapter was listed in a "inconsistent state" instead of being in the proper VLAN. So we powered off the VM and as soon as we did it changed back to the proper VLAN. Now we were able to start the Virtual Center Server service and it stayed up and stable with no issues....

Simple enough fix, but I learned something, so I figured I would pass it along.