Skip to main content

    vlan for guest wifi on zyxel usg router with engenius access points

    fonte: vlan-for-guest-wifi-on-zyxel-usg-router-with-engenius-access-points

    The goal here is to add a second SSID from the Engenius access point for guest internet access that does not have access to the network resources on the private wifi network. First of all I am using the Zyxel USG20 and an Engenius ECB600. Other similar hardware will be… similar. Here’s how to make this work.

    Log into your access point. Add another SSID. Make sure you check the box for Station Separation. After adding it, go to the Management category and click on Management VLAN. Set your VID (VLAN ID) for your second SSID. I’d leave it as “2” and check the Isolation and Enable box. Click Accept at the bottom then click the Save/Reload link under status in the top left. This is all you’ll have to do on the access point.

    Log into your router. Click Interface then click the VLAN tab. Click Add. Then set it up this way:
    Interface Type: general
    Interface Name: vlan2
    Zone: LAN1 (This needs to match the zone that your access point is connected to.)
    Base Port: lan1
    VLAN ID: 2 (This needs to match the ID that you set in your access point)
    Description: Make it descriptive!
    IP Assignment: Use Fixed IP Address
    IP Address: Choose something outside of your main subnet. I want my VLAN to use 192.168.10.x so I’ll set this to (Make sure you select a range that is not in use by your router. Keep in mind that LAN2 may be assigned 192.168.2.x, and DMZ may be 192.168.3.x)
    Subnet Mask:
    Gateway: (IP address of router. This may not be necessary.)
    Under DHCP Setting:
    DHCP: DHCP Server
    IP Pool Start Address: pool size 100 (or whatever you need it to be)
    Set your DNS servers to something outside your network. Google DNS will work
    Set default router to vlan2 IP
    Save the settings

    Next go to Object->Address and Add a new address. Call it something like VLAN_Subnet. Address type is INTERFACE SUBNET and Interface is vlan2.

    Next, click on Network -> Routing. Add a Policy Route.
    Description: VLAN
    Incoming: Interface
    Please select one member: vlan2
    Type: Trunk
    Click OK.

    At this point your Guest SSID should be working. You will get IP addresses in the range specified in your VLAN interface. The only problem is that your guest network can see your main network. Block this using your Firewall.

    Click Network -> Firewall
    Click Add
    From: Any
    To: Any (Excluding Zywall)
    Source: VLAN_Subnet
    Destination: LAN1_SUBNET
    ACCESS: deny

    Add one more rule that blocks router administration:

    Click Network -> Firewall
    Click Add
    From: Any
    To: Zywall
    Source: VLAN_Subnet
    Destination: any
    ACCESS: deny

    If you have more than one subnet, you’ll need to create other rules that block access to that subnet too.

    That’s it!

    Come risolvere l’errore L’app è stata bloccata a scopo di protezione in Windows 10


    Microsoft ha deciso di migliorare la sicurezza impedendo ai programmi non sicuri e verificati di essere installati in Windows 10. Può capitare, però, che vengano riconosciuti dei falsi positivi e che l’utente non possa installare l’applicazione; in tal caso viene restituito l’errore L’app è stata bloccata a scopo di protezione. Vediamo come risolvere questo problema.


    Una prima soluzione temporanea al blocco delle app a scopo di protezione può essere quella di ricorrere al Prompt dei comandi:

    1. Digitate nel box di ricerca cmd (o in alternativa Prompt dei comandi), cliccate con il tasto destro del mouse e selezionateEsegui come amministratore.
    2. Alla richiesta di Controllo dell’account utente cliccate .
    3. Digitate il percorso dove è disponibile il setup dell’applicazione (nel nostro caso abbiamo sul Desktop il setup WBI.exe; nel Prompt dei comandi digiteremo C:\Users\biagi\Desktop\WBI.exe) e premete Invio.
    4. Et voilà: l’app verrà eseguita correttamente.


    Per risolvere questo problema delle app dovete ricorrere all’account Administrator, che ha dei privilegi maggiori rispetto al classico account da amministratore:

    1. Digitate nel box di ricerca cmd (o in alternativa Prompt dei comandi), cliccate con il tasto destro del mouse e selezionateEsegui come amministratore.
    2. Alla richiesta di Controllo dell’account utente cliccate .
    3. Digitate la seguente stringa e premete Invio: net user administrator /active:yes
      Se l’operazione andrà a buon fine, comparirà la scritta Esecuzione comando riuscita.
    4. Disconnettetevi dall’account.
    5. Accedete al nuovo account Administrator.
    6.  Grazie all’Esplora file, individuate l’eseguibile (nel nostro caso sarà presente in C:\Users\biagi\Desktop\WBI.exe) ed installate il programma.
    7. Disconnettetevi dall’account Administrator e rientrate nel vostro account.
    8. Disattivate l’account Administrator digitando in un Prompt dei comandi con privilegi di amministratore la seguente stringa: net user administrator /active:no

    Il problema delle app bloccate è stato risolto. Vi è mai capitato di incorrere in questa situazione? Avete risolto il problema? Fatecelo sapere nei commenti.

    Articolo di Windows Blog Italia
    Fonte | WinAero

    How to run 32-bit UDL file on a 64-bit Operating System


    We’ll need to  execute the command below from a command line or Start/Run :


    C:\Windows\syswow64\rundll32.exe “C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll”,OpenDSLFile C:\test.udl


    Check the paths of rundll32.exe and oledb32.dll while running this command!


    Here you have your 32 bit OLE DB Providers.

    Rimuove spazi in eccesso da stringa SQL


    SELECT REPLACE(REPLACE(REPLACE('some   string    with         many     spaces'
      , '  ', ' ' + CHAR(7) + CHAR(7)), CHAR(7) + CHAR(7) + ' ', ''), ' ' + CHAR(7) + CHAR(7), ' ') AS NewStr
    --but it remove CHAR(7) + CHAR(7) from string

    How it works: enter image description here

    Char/string used to replace spaces shouldn’t exist on begin or end of string and stand alone.

    Esportazione dati da SQL a file posizione fissa


    Exporting data from SQL Server to Fixed Position Flat file

    Just as usual, this post is kind of “Bi-product” of my attempt to create a demo for another post in which I need to use fixed position file. At first I tried to create a fixed position file using BCP. BCP has query out option to export query results into a file, but I was unable to produce the fileformat which uses fixed position. I actually even tried to use format file to generate required format but I ran into many issues so finally I thought that it is more important to get results than means to achieve it (at least it is true in this case Open-mouthed smile) and I fired up Visual Studio to use SSDT.

    Actually it is very easy to generate a fixed position file using SSIS. All you have to create is a simple Data Flow task and then add a SQL Server as source and a flat file as destination into that task. Only thing to be sure is configuring Flat File destination settings.

    FlatFileConnection Details Preview

    In Flat File Connection Manager settings, goto General tab and make sure that FORMAT is “Ragged Right” not “Fixed Width”. What’s confusing is if you want to add row delimiter in the end then you have to use Ragged Right not Fixed Width. And that’s it !!

    Simply run the package and you have fixed width flat file for your all Devil experiments  …

    I have attached sample SSIS project created with SSDT to give an idea. Of course you will need to modify this project to meet your requirements.

    That’s it for now…

    It’s Just A Thought … Peace

    Gaurang Sign



    I actually just did this last week. I wrote a function that does this then for each field I call the function.

    Here is the function

    /* USE [Newton-Dev] GO /****** Object: UserDefinedFunction [dbo].[CharPad] Script Date: 1/10/2015 11:38:27 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /* Script : Character Padding Function; Assist with fixed width file creation Version : 1.0 (01/08/2015) Author : Jeffery Williams */ ALTER FUNCTION [dbo].[CharPad] ( @Input VARCHAR(255) ,@OutputWidth INT ,@OutputAlign VARCHAR(5) ,@PadCharacter CHAR(1) ) RETURNS VARCHAR(255) AS BEGIN DECLARE @Output VARCHAR(255) DECLARE @InputWidth INT SET @InputWidth = LEN(@Input) IF @InputWidth > @OutputWidth BEGIN IF @OutputAlign = 'LEFT' BEGIN SET @Output = LEFT(@Input,@OutputWidth) END IF @OutputAlign = 'RIGHT' BEGIN SET @Output = RIGHT(@Input,@OutputWidth) END END IF @InputWidth < @OutputWidth BEGIN IF @OutputAlign = 'RIGHT' BEGIN SET @Output = REPLICATE(@PadCharacter, @OutputWidth - @InputWidth ) + @Input END IF @OutputAlign = 'LEFT' BEGIN SET @Output =@Input+ REPLICATE(@PadCharacter, @OutputWidth - @InputWidth ) END END IF @InputWidth = @OutputWidth SET @Output = @Input RETURN (@Output) END

    Here is the query that calls the function and provides the fixed width output:

    SELECT --dbo.CharPad (DeltaLineId,8,'LEFT',' '), dbo.CharPad (DeltaElgId,8,'LEFT',' ') dbo.CharPad (CARRIER_ID,6,'LEFT',' ') ,dbo.CharPad (GROUP_NUM,7,'RIGHT','0') ,dbo.CharPad (LEFT('0000' + SUB_GROUP_ID, 4),9,'LEFT',' ') ,dbo.CharPad (SVC_TYPE,1,'LEFT',' ') ,dbo.CharPad (FILLER_1,1,'LEFT',' ') ,dbo.CharPad (FILLER_2,5,'LEFT',' ') ,dbo.CharPad (RATE_CODE,2,'LEFT',' ') ,dbo.CharPad (FILLER_3,1,'LEFT',' ') ,dbo.CharPad (ELIG_CODE,1,'LEFT',' ') ,dbo.CharPad (EFF_DATE,8,'LEFT',' ') ,dbo.CharPad (TERM_DATE,8,'LEFT',' ') ,dbo.CharPad (SUBSC_SSN,9,'LEFT',' ') ,dbo.CharPad (INDIV_SSN,9,'LEFT',' ') ,dbo.CharPad (CHNG_SSN,9,'LEFT',' ') ,dbo.CharPad (REL_CODE,2,'LEFT',' ') ,dbo.CharPad (HIRE_DATE,8,'LEFT',' ') ,dbo.CharPad (DOB,8,'LEFT',' ') ,dbo.CharPad (REL_TYPE,1,'LEFT',' ') ,dbo.CharPad (FIRST_NAME,24,'LEFT',' ') ,dbo.CharPad (MID_NAME,24,'LEFT',' ') ,dbo.CharPad (LAST_NAME,24,'LEFT',' ') ,dbo.CharPad (GENDER,1,'LEFT',' ') ,dbo.CharPad (POP_DESC,5,'LEFT',' ') ,dbo.CharPad (ADR_LINE_1,30,'LEFT',' ') ,dbo.CharPad (ADR_LINE_2,30,'LEFT',' ') ,dbo.CharPad (CITY,30,'LEFT',' ') ,dbo.CharPad ([STATE],2,'LEFT',' ') ,dbo.CharPad (COUNTY_CODE,3,'LEFT',' ') ,dbo.CharPad (COUNTRY_CODE,3,'LEFT',' ') ,dbo.CharPad (ZIP,5,'LEFT',' ') ,dbo.CharPad (ZIP_EXT,4,'LEFT',' ') ,dbo.CharPad (FILLER_4,21,'LEFT',' ') ,dbo.CharPad (USER_DEFINED,30,'LEFT',' ') ,dbo.CharPad (WAIT_PERIOD,1,'LEFT',' ') ,dbo.CharPad (CAID,9,'RIGHT','0') ,dbo.CharPad (FILLER_5,9,'LEFT',' ') FROM export.DeltaLine */

    Spazio su disco insufficiente per creare la copia shadow del volume nel percorso di archiviazione

    Verificare lo spazio libero dei dischi sorgente, prima della destinazione; la causa è data molto probabilmente dalla partizione di avvio del sistema operativo (quella di 100MB o 350MB)


    • If the volume is less than 500 MB in size, the shadow copy storage location must have at least 50 MB of free space.
    • If the volume is between 500 MB and 1 GB in size, the shadow copy storage location must have at least 320 MB of free space.
    • If the volume is greater than 1 GB in size, the shadow copy storage location must have at least 1 GB of free space.




    Small Business Server 2011 Slow to Boot and Several Services Fail to Start


    1. Uncheck Internet Protocol Version 6 (TCP/IPv6) on your Network Card.
    2. In Registry Editor, locate and then click the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip6\Parameters\
    3. Double-click DisabledComponents to modify the DisabledComponents entry.
      Note If the DisabledComponents entry is unavailable, you must create it. To do this, follow these steps.

      1. In the Edit menu, point to New, and then click DWORD (32-bit) Value.
      2. Type DisabledComponents, and then press ENTER.
      3. Double-click DisabledComponents.
    4. Enter “ffffffff” (eight f’s), and then click OK:clip_image002
    5. Reboot the SBS 2011 server.

    RRAS (VPN) Note: If you plan to enable VPN on your SBS 2011 server, you MUST also Export and then Delete the following registry key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\RemoteAccess\RouterManagers\Ipv6

    If you do not delete this key you will get an 20103 Event when trying to start RRAS with IPv6 disabled.  You must reboot after removing this key.


    disable IPv6