How to enable RDP to a Server 2008 R2 on another network? VM network

Question

Using Microsoft SQL Server 2014

With the following query:

SELECT DISTINCT  *
INTO #Temp_1
    FROM (
        SELECT *, Row_Number() 
          OVER (PARTITION BY [State]
                ORDER BY [EntryDate] ASC ) AS Row_Number
          FROM [dbo].[OrderAudit] 
            ) AS EntryDates WHERE Row_Number <= 2
          Order by [State] ASC, [EntryDate] Desc

Select * from #temp_1 order by state ASC, entrydate desc

I produce a table like this:

State   EntryDate   Count_1   Count_2   Count_3     ...  Count350

SC      2018-08-05  1000        2000      3000      ...  1000
SC      2018-08-01  1500        2400      3000      ...  1500
TN      2018-04-20  2000        3000      3400      ...  2000
TX      2018-04-20  1500        1000      7000      ...  1500

I'd like to output:

State  Most_Recent     Elapsed    Count_1_diff   Count_1_%_diff   ... 
SC     2018-08-05      04           500            -33.33
TN     2018-04-20      0            0                 0
TX     2018-04-20      0            0                 0 

I was trying to do something like this:

;WITH rows AS
              (SELECT DISTINCT * , Row_Number() 
               OVER (PARTITION BY [State]
                     ORDER BY [state], [EntryDate] )as rn
               FROM   #temp_1)


        SELECT DISTINCT   mc.[State]
                ,mc.[EntryDate]
                ,DATEDIFF(DAY,mp.EntryDate,mc.EntryDate) AS Elapsed
                ,mc.Count_1 - mp.Count_1 AS Count_1_Diff
                ,STR(ISNULL(((mc.Count_1-mp.Count_1)/NULLIF(CAST(mp.Count_1 AS NUMERIC(10,2)),0)),0) * 100 ,5,2) AS Count_1_%_diff

        INTO #Temp_2
        FROM    rows mc
        JOIN    rows mp
        ON      mc.rn = (mp.rn + 1)

It's not giving me what I need and I also don't know how I'll select every column (300 different counts) to do these two calculations without writing them all out.

Solution 1

Did you check the Terminal Licenses in your Windows 2008 R2? They should be enabled.

Solution 2

Please check your VM Host network setting, host firewall/network(public/private/unknown) config may be the issue.

Please test with VM Host firewall turn-off (see PS).

There is a VMware KB related to this issue.

I also solved a very similar issue here. That is for ssh connection to a VM in a Windows host.

PS: Base on comment from Oliver Salzburg, this may not work as intended. I cannot confirm as I am remote from my server now.

Comments

[week]

Are those networks divided by router? Or they are sharing same network with different subnets?

[Joe Schmoe]

Try to telnet from your computer into remote box on port 3389 (or whatever port remote desktop is running on if you changed it). Does this work?

[Saariko]

yes, telnet works (nothing is shown) but it's a connection

[sinni800]

Maybe, make a screenshot of the error message coming from the RDP client... If it's a generic one, tough luck, but it might have one thats usable.

[Joe Schmoe]

Another shot in the dark: can you try to remote desktop to remote server from remote network (if you have physical access to remote network)? Or ask someone with physical access to remote network give it a try?

[John Siu]

Did you turn off firewall on the server or on your rdp client machine or both? Also check server event log for rdp connection related event.

[Oliver Salzburg]

Disabling the firewall on a Windows Server can have quite the opposite effect of what you're after. Enable the firewall and create an exception for Remote Desktop in all profiles.

[Saariko]

This was checked - it's ok

[Saariko]

I don't think this has an effect in my case

[JERiv]

Try it, it won't hurt your existing setup (unless you want .3. and .0. networks traffic seperated)