cisco 2960 upgrade

1. Upgrade
https://ippacket.com.au/how-to-upgrade-cisco-2960-switch-ios/


https://www.cisco.com/c/en/us/support/docs/switches/catalyst-2950-series-switches/41542-191.html

2. Delete bin

Use "delete /force /recursive flash:c2960-lanbase-mz.122-25.SEE2" command. This will get rid of everything in that directory.

https://supportforums.cisco.com/t5/lan-switching-and-routing/deleting-old-bin-file/td-p/750072

mbssid guest-mode Cisco AP

Purpose of the "guest-mode" command

This question has been Answered.

Jason Harry Jan 3, 2011 6:37 PM

Hi Guys,

Today I was configuring a 1131AG at a client using the CLI and I removed the "guest-mode" command that was under the SSID config mode. After doing this I noticed that the SSID wasn't being broadcast anymore. Putting back the command resulted in  the SSID being broadcast and me being able to connect to it. I did some research on Cisco's DocCD on the command which pretty much explains it but I'd still like an expert response so that I'm 100% sure. Also, the DocCD said that an access point can only have one SSID in guest-mode. My question here is, if this is true, how do you configure an AP to broadcast multiple SSID? I would have thought that you just create multiple SSID and put the guest-mode command under there which broadcast the beacons, but according to Cisco's documentation, there can only be one SSID in guest-mode per AP.

"The access point can have one guest-mode SSID or none at all."

http://www.cisco.com/en/US/docs/wireless/access_point/12.4_10b_JA/command/reference/cr12410b-chap2.html#wp3659596

Appreciate your responses.

Jason.

Correct Answerby Pete Nugent on Jan 3, 2011 6:50 PM

You are correct guest mode broadcasts the SSID and only one SSID can be in gueat mode.

To broadcast multiple SSIDs use mbssid guest-mode on each SSID,

MikroTik Routers and Wireless - Products: Groove 52

• CPE - Short for "Customer Premises Equipment", this term is used to mean a "wireless station". It connects to a (wireless) network, like your computer would, but doesn't create its own (like an access point).
• Home AP - Simple access point. One SSID, no VLANs, etc.
• PTP Bridge - Used for setting up a "Point to Point" link. Tends to be used to extend a single network to another site that doesn't have a cable running to it.
• WISP AP - "Professional" access point ("WISP" is "Wireless Internet Service Provider", I think). It can serve multiple SSIDs at once, has VLAN support (to have each SSID be its own, isolated network, maybe with firewalling and routing between them), and other advanced things.https://forum.mikrotik.com/viewtopic.php?t=87961

WinBox is much more convenient than using WebFig.

Reset

Buttons and Jumpers

 • RouterOS reset jumper hole (no direct access, board has removed from case) – resets RouterOS software to defaults. Must short circuit the metallic sides of the hole (with a screwdriver, for example) and boot the device. Hold screwdriver in place until RouterOS configuration is cleared.

 • RouterBOOT reset button (access through the plastic door) has two functions: 

1. Power On , Hold Reset Button
2. at 10 sec release hold button
3. at 20 sec , beep sound x 1
4. at 48 sec , beep sound x 2 
5. can ping 192.168.88.1

用呢個 (boot , 5粒 Wifi 閃完 幾下即放手 ) 

o Hold this button during boot time until LED light starts flashing, release the button to reset RouterOS configuration (same result as with reset hole)

唔好去錯呢個 Netinstall Mode

 o Hold this button during boot time longer, until LED turns off, then release it to make the device look for Netinstall servers.

https://forum.mikrotik.com/viewtopic.php?t=110735


HOME AP Basic :

Local Network

• IP address: Mostly can stay at the default 192.168.88.1 unless your router is behind another router. To avoid IP conflict, change to 192.168.89.1 or similar
• Netmask: In most situations can leave 255.255.255.0
• Bridge all LAN ports: Allows your devices to communicate to each other, even if, say, your TV is connected via ethernet LAN cable, but your PC is connected via WiFi.
• DHCP server: Normally, you would want automatic IP address configuration in your home network, so leave the DHCP settings ON and on their defaults.
• NAT: Turn this off ONLY if your ISP has provided a public IP address for both the router and also the local network. If not, leave NAT on.

https://wiki.mikrotik.com/wiki/Manual:Quickset

Configuring WEP with (40bit) static key

Create new WEP security profile named “wep_profile”:

[admin@MikroTik] /interface wireless security-profiles> add name=wep_profile \
mode=static-keys-required static-algo-1=40bit-wep static-key-1=1234123412 static-transmit-key=key-1

Statically configured WEP keys:

Different algorithms require different length of keys:

• 40bit-wep (static-key-1) - 10 hexadecimal digits (40 bits). If key is longer, only first 40 bits are used.
• 104bit-wep (static-key-2) - 26 hexadecimal digits (104 bits). If key is longer, only first 104 bits are used.
• tkip (static-key-3)- At least 64 hexadecimal digits (256 bits).
• aes-ccm (static-key-3)- At least 32 hexadecimal digits (128 bits).

Key must contain even number of hexadecimal digits.

https://wiki.mikrotik.com/wiki/Testwiki/Advanced_MikroTik_Wireless_networks

https://forum.mikrotik.com/viewtopic.php?t=69909

mikrotik couldn't remove security profile not permitted

[Solved] User Group permission mismatch ?! - MikroTik

Question: 

I need set user without rights to policy option like user add or delete etc. 
Why this user cannot change own password. 
Mikrotik show form with password fields and after klick Apply i get info:

Code: Select all

Couldn`t change Change Password - not permitted (9) 

Ans: 
Enable 'password' policy for this user group.

sp_addlinkedserver SQL 2008

Test Server for PWHOT1 VM clone and change computer name and SQL Server name. but DBLink Connect still old.


select name from sys.servers
select * from sys.servers

sp_dropserver 'PWHOTRPT'
GO

-Add DB Link Server
EXEC sp_addlinkedserver
@server = 'PWHOTRPDRATEST', --Server Name
@srvproduct = 'MS SQL',    <------  on other web said 'SQL Server' , but cannot execute
@datasrc = 'PWHOTRPDRATEST' , --Server IP or Hostname
@provider = 'SQLNCLI'

select name from sys.servers
select * from sys.servers

https://dotblogs.com.tw/puma/2009/02/05/7038

http://tsuozoe.pixnet.net/blog/post/22417837-sp_addlinkedserver-%E3%80%81-sp_dropserver-%E4%BD%BF%E7%94%A8%E6%96%B9%E6%B3%95-

https://stackoverflow.com/questions/35799905/could-not-find-server-server-name-in-sys-servers-sql-server-2014