Sunday, January 19, 2014

Get SID using CMD

1. 
>wmic useraccount where name='username' get sid

2. 
>wmic useraccount where name='%username%' get sid

3. 
>whoami /user

4.
>wmic useraccount get name,sid

Wednesday, January 15, 2014

Configure SQL after change computer name

After changing the computer name for a machine that has a SQL installed there is some additional step required:
1- select @@servername 
     > to view the current server name
2- sp_dropserver "Old_Server_Name" 
     > to remove the old server name
3-  sp_addserver "New_Server_Name", local 
      > to add the new server name

Cisco - Access List for internet access only

how to configure ACL on Cisco switch for internet browsing only:

VLAN 60 > Guest VLAN
Network Address: 192.168.60.0
Subnet Mask: 255.255.255.0
Gateway: 192.168.60.1

DHCP configuration:
ip dhcp excluded-address 192.168.60.1 192.168.60.50
ip dhcp pool Guest
   network 192.168.60.0 255.255.255.0
   default-router 192.168.60.1
   dns-server 8.8.8.8
!

Configure ACL:
access-list 102 permit udp 192.168.60.0 0.0.0.255 any eq domain
access-list 102 permit udp 192.168.60.0 0.0.0.255 any eq bootpc
access-list 102 permit udp 192.168.60.0 0.0.0.255 any eq bootps
access-list 102 permit udp host 0.0.0.0 eq bootpc host 255.255.255.255 eq bootps
access-list 102 permit tcp 192.168.60.0 0.0.0.255 any eq www
access-list 102 permit tcp 192.168.60.0 0.0.0.255 any eq 443

Apply ACL on the Vlan interface:
interface Vlan60
 ip address 192.168.60.1 255.255.255.0
 ip access-group 102 in

Tuesday, January 14, 2014

Cisco VPN client minimized

How to solve Cisco VPN client issue when it stayed minimized to taskbar.

Edit vpnclient.ini located in "C:\Program Files (x86)\Cisco Systems\VPN Client" for Windows 7 64 bit
Change WindowX and WindowY to:
WindowX=129
WindowY=60
This should solve this issue.