How to enable hotspot in your PC without third party software

Note:

You need to have a wifi driver and a hardware installed on your machine to do this.

Solution:

1. Go to start menu, then type cmd
2. Right click it and run it as administrator.
3. Type in netsh wlan set hostednetwork mode=allow ssid=”SSID” key=”password”. Note: SSID will be the name of your network while the key will serve as the password of your network.
4. After setting your network type the next command netsh wlan start hostednetwork to broadcast your network.
5. Once your done you will be able to connect to the wifi using your device.
6. If you want to stop broadcasting your network go again to cmd then type this command netsh wlan stop hostednetwork.

 

 

Advertisements

Error 500.19 in IIS

Problem:

HTTP Error 500.19 – Internal Server Error

The requested page cannot be accessed because the related configuration data for the page is invalid.

Detailed Error Information:

Module
IIS Web Core

Notification
BeginRequest

Handler
Not yet determined

Error Code
0x80070021

Config Error
This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault=”Deny”), or set explicitly by a location tag with overrideMode=”Deny” or the legacy allowOverride=”false”.

Config File
\\?\C:\Inetpub\wwwroot\MSAdmin\web.config

Requested URL
http://localhost:80/MSAdmin

Physical Path
C:\Inetpub\wwwroot\MSAdmin

Logon Method
Not yet determined

Logon User
Not yet determined
Config Source:
101: <system.webServer>
102: <handlers>
103: <add name=”handlers/ResourceHandler.axd_*” path=”handlers/ResourceHandler.axd” verb=”*” type=”System.Web.WebPages.ApplicationParts.ResourceHandler, System.Web.WebPages, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35″/>

Solution:

You need to install the ASP.NET modules that your system website are using.

1. On the Startpage, click the Server Manager tile, and then click OK.
2. In Server Manager, select Dashboard, and click Add roles and features.
3. In the Add Roles and Features Wizard, on the Before you beginpage, click Next.
4. On the Select installation typepage, select Role-based or feature-based installation, and click Next.
5. On the Select destination serverpage, select Select a server from the server pool, select your server, and click Next.
6. On the Select server rolespage, select Web Server (IIS), and click Next.
7. On the Select featurespage, click Next.
8. On the Web Server Role (IIS)page, click Next.
9. On the Select role servicespage, note the preselected role services that are installed by default, expand the Application Developmentnode, and then select NET 4.5. (If you installed .NET 3.5, select ASP.NET 3.5 also.)
10. On the Summary of Features to Installpage, confirm your selections, and then click Install.
11. In the Add features that are required for ASP.NET 4.5?box, click Add Features.
12. The following additional features are added:

• .NET Extensibility 4.5
• ISAPI Extensions
• ISAPI Filters
• .NET Extensibility 3.5(If NET 3.5 was selected)

13. Click Next.
14. On the Confirm installation selectionspage, click Install.
15. On the Installation progresspage, confirm that your installation of the Web Server (IIS) role and required role services completed successfully, and then click Close.
16. To verify that IIS installed successfully, type the following into a web browser:

The default IIS Welcome page is displayed.

Source:

https://technet.microsoft.com/en-us/library/hh831475(v=ws.11).aspx

 

 

 

 

RSAT Tool

Remote Server Administration Tools (RSAT) enables IT administrators to remotely manage roles and features in Windows Server (2012 R2, 2012, 2008, 2008 R2)from a computer that is running in Windows 10, 8.1,  8, 7, and Vista.

Note: You can’t install the tool in home and standard edition of windows

Download link:

Windows 10:

https://www.microsoft.com/en-ph/download/details.aspx?id=45520

Windows 8.1

https://www.microsoft.com/en-us/download/details.aspx?id=39296

Windows 8

https://www.microsoft.com/en-ph/download/details.aspx?id=28972

Windows 7

https://www.microsoft.com/en-us/download/details.aspx?id=7887

Windows Vista

(x86) – https://www.microsoft.com/en-us/download/details.aspx?id=21090

(x64) – https://www.microsoft.com/en-us/download/details.aspx?id=18787

Source:

https://support.microsoft.com/en-ph/kb/2693643

Make visible network backup in MS SQL

Problem:

How to make visible network backup in MS SQL

Solution:

Run this commands:

First one was to identify that network drive in SQL Server, you will use the xp_cmdshell command. Before that, you need to make sure that the xp_cmdshell command is enabled in your SQL instance, as it is disabled by default. Use the sp_configure command to enable it as shown below:

EXEC sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO

EXEC sp_configure ‘xp_cmdshell’,1
GO
RECONFIGURE
GO

Then,

Now define that share drive for SQL with the xp_cmdshell command as follows:

EXEC XP_CMDSHELL ‘net use H: \\RemoteServerName\ShareName’

It should now be mapped. In order to verify the new drive, you can use the below command that will show you all files in that newly mapped drive:

EXEC XP_CMDSHELL ‘Dir H:’

To Delete the network  backup path in MS SQL

Optionally you can delete that path after you finish using the below command:

EXEC XP_CMDSHELL ‘net use H: /delete’ /pre>

Thoughts

It’s my first time to do a blog and I don’t know what kind of first post should I post. I think the blog will mostly contains some of my random thoughts and IT stuffs mostly related to my current work.