Sunday, March 30, 2014

Error while opening "SQL Server Configuration Manager" - Error: 0x80041010

Error while opening "SQL Server Configuration Manager"
Error:
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid class [0x80041010]


Solution:
start a command prompt (as administrator):
>cd "C:\ProgramFiles (x86)\Microsoft SQL Server\100\Shared\"
> mofcomp sqlmgmproviderxpsp2up.mof

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.

Wednesday, December 25, 2013

Configure Cisco DHCP for WDS

Configure Cisco DHCP for Windows Deployment Service

ip dhcp pool Vlan10
network Network_ID Subnet_Mask
default-router Gateway_IP
dns-server DNS_IP_Addr._1 DNS_IP_Addr._2
next-server WDS_IP_Addr.
option 67 ascii Boot\x86\wdsnbp.com
lease 0 24

Monday, December 23, 2013

Windows SDK - Installation failed.

Windows SDK Fails to Installation failed.

When installing the Microsoft Windows SDK for Windows 7 and .NET Framework 4 (Windows 7 SDK), you may see the "Installation Failed" dialog:

To resolve this issue, you must uninstall all versions of the Visual C++ 2010 Redistributable before installing the Windows 7 SDK.  You may have one or more of the following products installed:
  • Microsoft Visual C++ 2010 x86 Redistributable
  • Microsoft Visual C++ 2010 x64 Redistributable