ingvarorn

The issue was solved with new version will try it on other PC's I know have the error, will report back if not solved there also.

Client caching was set to simple on the client with the error.

Will update to newest on my test client and see if that solves it.

Hi,

Some of our clients are having issue with "ghost" entry's of type RDP session in the root folder.

I have managed to get this same error on one of my test clients and if I delete the entry nothing happens and if I open it in edit mode (properties) the session is empty.

I have tried to delete offline cache and refresh the connection, the only solution seems to delete the data source and add it again. Which not a good solution.

This looks like this for the users with the fail, for my pc the list ends with the three pricks.

Do you have any better work around or a solution to this for me?

Small info on the system:

RDM 10.1.4.0 and 10.1.5.0

RDMS 2.2.21.0 on db version 93 (SQL 2012)

Hi guys,

We have few credentials we have disabled for various reasons but what is frustrating my is that these creds will be showed in the credential prompt when we ask the user to select which creds he is going to use to connect and he has no way to see it there the user is disabled.

The best solution would be is the creds are Locked, Disabled or Expired then the user would not see them in the list of creds but if it has a warning it would be showed beside the creds in the list.

Other solution would be to show them but also show the status like we see it in the tree.

Ps... can you also in the forum do the string size of post little longer 10 char extra would be great ;)

No the client hangs (Program Not Responding).

I have not noticed this with other programs.

Hi,

We have several customers who uses AnyConnect VPN from Cisco and we have one problem with this connections.

When the VPN client fails or hangs for some reason then RDM hangs also even after we have ended the VPN client window.

If we wait long enough the RDM returns back to live but who has the time to wait these day's :)

Have you any ideas on fix around for this?

This is a default behavior of MS SQL it only accepts the logged on user of the computer to be the integrated security so this like you see below would not work right off the shell because it only accepts a SQL user into the User field or using the Integrated security (AD).

But you might try a small trick as a workaround that used to work with SQL 2005 have not tried with 2008 and newer.

If you map a drive to the server as the user you want to use, before doing anything then when you connect with integrated security the credentials that you have already established on that server will be used. I used to do this when I was working from a workstation that was not trusted by the domain that the servers were in (SQL 2005). You still only get one set of credentials, this trick won't work for two different sets of credentials.

Hi,

I was wondering if there was somewhere a list of all property´s I can set through powershell cmdlet?

If not it would be something that would be nice to build up in the help files.

As I understand this you already have the solution who I could offer you since this is a build in behavior of MS VPN. But you have two options to fix this.

A:

As you mentioned above use netsh to delete all DNS server on the interface.

B:

Re add the original DNS as the first one (if you want to keep the DNS for the VPN)

netsh interface ipv4 add dnsservers name="<Interface Name>" address=<Non-VPN DNS server> index=1 validate=no

Eg: netsh interface ipv4 add dnsservers name="My VPN" address=192.168.0.1 index=1 validate=no

Since a lot of our support engineers work on this 2012 R2 RDS Server, we face also the problem that when someone connects to the RDS Server, all currently active VPN's on the server get disconnected (by design since Vista).

This did I not get, are you running multiple user based VPN's from the RDS server?

If Yes than I would say that is no good solution to that since that is a general really bad idea.

But adding a search function to the note would be a mistake I think, that would result in to many results that are of no use. At least that would need to be a extra option to the search not a part of default search.

My recommendation is to use good naming so the filter is more useful.

For example I use this naming rule for all server sessions in RDM

Role of server (name of server)

And in the description I use keywords like.

SQL 2012, Exchange 2013, Sharepoint 2010 and so on, that way I can easily find all server running Sharepoint 2013 by just typing Sharepoint 2013 in the filter :D

Also for servers I prefer naming rules who helps identify the server, so a server running Sharepoint who is a part of a production system could be called PROD_SP13_04 or a server who is a part of cluster named CLSP13 could be called PROD_CLSP13_02 that is server 2 in the cluster CLSP13 who is a SharePoint 2013 cluster belonging to the prod system.

And one more.

This is a script i run manually so if you are going to set it up as a job then you would need to remove the PRINT command but you could also replace it with xp_logevent to write a entry to the event logger on the server.

The format of xp_logevent is:

xp_logevent { error_number , 'message' } [ , 'severity' ]

Where the severity is the same as you see in event viewer, Information, Warning, Error and Critical.

The error_number needs to be above 50000 since under that is reserved for Microsoft (it will work but..)

Example how I would do this for the script above.

xp_logevent { 990016 , 'SQL job notactive sessions is KILLing '+CONVERT(VARCHAR,@v_spid)+'...' } [ , 'Information' ]

You see the script now David?

Hi,

This is a SQL issue but what you can use is to create a maintenance job on the SQL server who runs every x minute and kills not active sessions.

Then you would need to use a script like this one

[color=#0000ff]

Code Snippet

[color=#0000ff] [/color][color=#0000ff]DECLARE[/color] @v_spid [color=#0000ff]INT[/color]

[color=#0000ff] [/color][color=#0000ff]DECLARE[/color] Users [color=#0000ff]CURSOR[/color]

FAST_FORWARD [color=#0000ff]FOR[/color]

[color=#0000ff]SELECT[/color] SPID

[color=#0000ff]FROM[/color] master.dbo[color=#808080].[/color]sysprocesses [color=#808080]([/color]NOLOCK[color=#808080])[/color]

[color=#0000ff]WHERE[/color] spid[color=#808080]>[/color]50

[color=#808080]AND[/color] status[color=#808080]=[/color][color=#ff0000]'sleeping'[/color]

[color=#808080]AND[/color] [color=#ff00ff]DATEDIFF[/color][color=#808080]([/color]mi[color=#808080],[/color]last_batch[color=#808080],[/color][color=#ff00ff]GETDATE[/color][color=#808080]())>=[/color]60 [color=#008000]--Check sleeping connections that exists before 60 min..[/color]

[color=#808080]AND[/color] spid[color=#808080]<>[/color][color=#ff00ff]@@spid[/color]

[color=#0000ff] [/color][color=#0000ff]OPEN[/color] Users

[color=#0000ff] [/color][color=#0000ff]FETCH[/color] NEXT [color=#0000ff]FROM[/color] Users [color=#0000ff]INTO[/color] @v_spid

[color=#0000ff] [/color][color=#0000ff]WHILE[/color] [color=#808080]([/color][color=#ff00ff]@@FETCH_STATUS[/color][color=#808080]=[/color]0[color=#808080])[/color]

[color=#0000ff] BEGIN

[/color] [color=#0000ff]PRINT[/color] [color=#ff0000]'KILLing '[/color][color=#808080]+[/color][color=#ff00ff]CONVERT[/color][color=#808080]([/color][color=#0000ff]VARCHAR[/color][color=#808080],[/color]@v_spid[color=#808080])+[/color][color=#ff0000]'...'[/color]

[color=#0000ff]EXEC[/color][color=#808080]([/color][color=#ff0000]'KILL '[/color][color=#808080]+[/color]@v_spid[color=#808080])[/color]

[color=#0000ff]FETCH[/color] NEXT [color=#0000ff]FROM[/color] Users [color=#0000ff]INTO[/color] @v_spid

[color=#0000ff] END

[/color][color=#0000ff]CLOSE[/color] Users

[color=#0000ff] [/color][color=#0000ff]DEALLOCATE[/color] Users

[/color]

You need to only check spid above 50 users will not have a spid under 50.

Hope this help.

edited by ingvarorn on 11/27/2014

Embedded uses a viewer not a Excel so therefore you will not be able to edit the data there.

If you use external in the Display settings it will open in Excel and you could edit the file, then it is a question if it is stored where you can save it directly or you would need to upload it to the server again.

That would be a great standard report.

So if I buy a jump license for all my users can I then install as many jump hosts as I want?

We have a service team of 50 people and of course it is up and down how many people are connecting to each customer site but if I have a jump license for all users then I have covered that.

And one Q on the same matter, will you be offering jump host as bundle in the future with the RDM and RDMS?

edited by ingvarorn on 11/21/2014

Ok the code came out totally useless so I try again the query.

SELECT [GroupName] as CustomerGroup

,[ConnectionName] as Connection

,[ClosePrompt] as CloseComment

,[StartDateTime] as StartTime

,[EndDateTime] as EndTime

,convert(varchar(5),DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)/3600)+':'+convert(varchar(5),DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)%3600/60)+':'+convert(varchar(5),(DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)%60)) as Duration

FROM [RDMS].[dbo].[ConnectionLog]

Where

[LoggedUsername] = @Param1 and

[StartDateTimeUTC] > GETDATE()-7 and

[Message] = 'Open session'

ORDER BY

[GroupName] ASC

Hi,

I and my company are in the business of selling our time as a service and need to bill our work and since we use RDMS the hole day for our connection we have a pretty good way to track the time spend per customer through the logging options.

So I created a Data Report entry who prompts the user for account used and returns that in a query and the outcome will be a report showing all activity with CustomerGroup (the folder) Connection (session) CloseComment (we have it as default to prompt for comment on each session close), StartTime, EndTime and duration shown in hh:mm:ss (calculated field).

This is the Query I use:

SELECT [GroupName] as CustomerGroup ,[ConnectionName] as Connection ,[ClosePrompt] as CloseComment ,[StartDateTime] as StartTime ,[EndDateTime] as EndTime ,convert(varchar(5),DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)/3600)+':'+convert(varchar(5),DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)%3600/60)+':'+convert(varchar(5),(DateDiff(s, StartDateTimeUTC, EndDateTimeUTC)%60)) as Duration FROM [RDMS].[dbo].[ConnectionLog] Where [LoggedUsername] = @Param1 and [StartDateTimeUTC] > GETDATE()-7 and [Message] = 'Open session' ORDER BY [GroupName] ASC On the parameters tap I define Parameter #1 as Text whit domain\ as a default value so the user will only need to add there user name (I tried to use Variable but it did not work for me).

Ofcourse you need to setup your Data Report connection to your SQL server and edit in my script the FROM sentence to fetch from right table and database.

Hope this comes to use for someone out there.

Hi,

Was wondering about the pricing of jump host.

I have corporate license including RDMS and was wondering how would it be licensed if I would like to get 4 jump hosts (have for client I have identified this as better solution that I have today).

Yes I use RDMS.

I think you have misunderstood little bit.

The problem is that the RDMS server never goes offline and RDM is connected to the RDMS server but the SQL server who is running on another server is down so there is no data available for RDMS.

I have tried this now in my test environment and same issue every time, if I take down the SQL without taking down the RDMS server then my RDM client simple hangs up till it crashes.

I have offline mode enabled in the client and data source settings and that works like a charm if I take down the RDMS server itself but not if I only take the SQL server who has the RDMS database.

Also one Q related the same, could a setup two RDMS server and use NLB or round robin to let them work as a cluster, then running database sync on the two SQL databases on the backside who will then run database mirroring between the databases. That way I would have a totally duplicated system so my users would not be affected by downtime if something goes wrong. This is something we have in place for other systems so the servers are already there so I will be trying this soon but would be nice to get some input on this.

See the picture for better understanding of the design.

Hi,

I was trying to set Default Templates directory in Data Source settings and every time I set it and click OK it is empty when I go back into the settings.

I have tried this on 10.0.15 and 10.0.4 both with same issue.

Since André updated the new VPN addon for me to use VPN groups than I have not had any issues with the addon my only issue is that the RDM says often it could not connect to VPN but if I then click Yes on continue I get in.

That issue came with the newest update of Cisco Anyconnect.

*not bugging me at all I created Macro that clicks this Yes for me without I will notice that.

Hi,

Had a downtime on my SQL yesterday evening who broke totally my RDM client also so I needed to take up a normal RDP client to the RDMS server and take him offline till the SQL was up again.

That way my clients went offline an was able to keep on working in cached mode.

So the bug is that the RDMS does not go offline so the client hangs trying to update the data entry's.

Possible solutions would be to make a automatic process in RDMS so it will go offline if the SQL is offline or other solution could be running a cached database on the RDMS server that would be synced up when the SQL is up again.

Hi,

On OpenVPN we do not have today no wait time after the VPN is ready. I see this we need for at least one customer since it's taking so long time to get all the routes up after the VPN is up and running.

I think you can copy this function from the Cisco Anyconnect plugin.