Thursday, May 26, 2005

Remote Desktop Connection error: "you do not have access to log on to this session"

Remote Administration of Terminal Services by Non-Administrators Accounts

1. Click Start, point to Programs, point to Administrative Tools, and then click Terminal Services Configuration.
2. in the tree in the left pane, click Connections.
3. Click the RDP-TCP connection in the right pane, and then click Properties on the Action menu.
4. Click the Permissions tab.

NOTE: Only Administrator and System accounts appear.
5. Click Add. Search for the groups or users that are appropriate for your Terminal Services management (such as the Server Operators group). Click Add to place them in the bottom pane. Click OK.

NOTE: The Server Operators group appears in the RDP-TCP properties; the permissions in the bottom pane are not enough to manage the server because only Guest Access is selected by default.
6. Click to select the User Access check box for basic tasks or both the User Access and Full Control check boxes to fully manage the server, and then click Apply.
7. Click OK.
8. Test by logging on the accounts in the Server Operators group.

Friday, May 20, 2005

Apostate Caf� VB format() function - formatting symbols

Apostate Caf� VB format() function: "r"

SQL Server Reporting services Phone Format function

Phone Format: "'Returns formatted Phone Number
Public Function CustomFormat(ByVal Value As String) As String
Dim FormatPhone As String
FormatPhone = Value
Select Case Value.Length
Case 7
FormatPhone = Value.Substring(0, 3) & '-' & Value.Substring(3, 4)
Case 10
FormatPhone = '(' & (Value.Substring(0, 3) & ') ' & Value.Substring(3, 3) & '-' & Value.Substring(6, 4))
Case 12
FormatPhone = ('(' & Value.Substring(0, 3) & ') ' & Value.Substring(4, 3) & '-' & Value.Substring(8, 4))
End Select
Return FormatPhone
End Function"

Custom Numeric Format Strings - Phone number format

Custom Numeric Format Strings: "myDouble.ToString( '(###) ### - ####' )"