Tuesday, March 19, 2013

How to uninstall Reporting Services on SQL 2008 R2?

From SQL Server Reporting Services(SSRS) 2008, the SSRS is Internet Information Server(IIS) independence. This means there is no directory for Reporting Services under IIS.
In this case, please make sure the SSRS service is running, otherwise, we are not able to configure the Web Service URL and the Report Manager URL(means configuring the virtual directories).
Anyway, in order to uninstall SQL Server Reporting Services without uninstalling other SQL Server components, please follow this guide:
  1. In Add/Remove programs
  2. Click the 'Uninstall/Change' button for "SQL Server 2008 R2"
  3. In the coming dialog, click 'Remove'
  4. Click 'OK'
  5. In the 'Select Instance' dialog,  select the appropriate instance, and then click 'Next'
  6. In the 'Select Features' dialog, please only select 'Reporting Services'
  7. Then click 'Next' and 'Next' till the uninstalling process starting

Thursday, March 14, 2013

DHCP on VLAN

 



Switch>enable
Switch#conf t
Switch(config)#vlan 200
Switch(config-vlan)#name TEST_VLAN
Switch(config-vlan)#exit

Switch(config)#int fa0/1

Switch(config-if)#switchport mode access

Switch(config-if)#switchport access vlan 200

Switch(config-if)#exit

Switch(config)#int fa0/2

Switch(config-if)#switchport mode access

Switch(config-if)#switchport access vlan 200

Switch(config-if)#exit

 

Switch(config)#int vlan 200
Switch(config-if)#ip address 192.168.200.1 255.255.255.0
Switch(config-if)#description DHCP_POOL_4TEST
Switch(config-if)#exit

 

Switch(config)#ip routing
Switch(config)#ip dhcp pool vlan200

Switch(dhcp-config)#network 192.168.200.0 255.255.255.0

Switch(dhcp-config)#default-router 192.168.200.1

Switch(dhcp-config)#exit

Switch(config)#ip dhcp excluded-address 192.168.200.1

Switch(config)#exit

Wednesday, March 6, 2013

Copy files to desktop in SCCM 2012


Copy files to desktop in SCCM 2012

 

1.       Create a parent folder in your source file repository (I created DesktopTools).

2.       Create a sub-folder in the folder just created called Files2Copy and place the files you are going to copy to desktop in this folder.

 
 
if not exist "%1" md "%1"
copy /y "%~dp0Files2Copy\*.*" "%1"
 
 
 
3.       Create a batch file called filecopy.bat (if you’re not sure how to create a batch file here’s a quick instructions - A. open notepad and copy paste those 2 lines in below B. save as then point to the DesktopTools folder, name it filecopy.bat) with the below two lines and place it in the parent directory created in step 1. This batch file will create a folder specified on the command-line (if it doesn’t already exist) and copy the files from the Files2Copy folder into it.

So it should looks like below



4.       Create a package in SCCM 2012 using the parent directory created in step 1 as the source file location
                a) Open SCCM 2012 console=> Software Library => Application management => Right click Packages =>  Create Package =>

5.      

Note: "C:\Users\Public\Desktop " is the Wins 7 All Users Desktop location
6.      

7.      

8.       The rest of screens are default so just Next, Next , & Close.

 

9.       Right click on the “Desktop Tools” package=> Distribute Content => Add the selection point. Then ext.

 

10.   Right click on the “Desktop Tools” package=> Deploy => Collection – just browse to one you would like to advertise to then Next => You can make it available or required, in my case I chose required because the files/shortcut must be copied to newly deployed laptops/desktops.

 

11.    Assignment schedule I made it As soon as possible.

 

12.   The rest of screens are default so just Next, Next Close.


 

13.   Done

Tuesday, March 5, 2013

Deploy SQL Server 2008 R2 Native Client x64 via SCCM 2012

1. Created application in SCCM 2012 with the MSI
2. Right click properties and select "Deployment Types" tab
3. click on highlight the MSI package and click edit
4. In the Program tab
5. Installation program: added the line " IACCEPTSQLNCLILICENSETERMS=YES" so should looks like this
msiexec /i "sqlncli_X64(2008 R2).msi" /q IACCEPTSQLNCLILICENSETERMS=YES