How to install phpMyAdmin 2.11 on Windows

Here are steps that will help you installed PHPMyAdmin on a Windows server.

REQUIREMENT:

– PHP 4.3/4.4/5.1
– MySQL 4.0/4.1/5.0

DOWNLOAD:

This installation was tested on phpMyAdmin-2.11.1
You can select the file from PHPMyAdmin Downloads

CONFIGURATION:

Configuration that needs to be noted, the one below are the one we have chozen. They might be different on your server:

Installation path: C:\www\phpMyAdmin (If you have Apache on your server then place out side of webroot of Apache)
Apache’s webroot : C:\www\webroot
MySQL path : C:\www\mysql\bin
Access phpMyAdmin as : http://192.168.1.52/phpMyAdmin/

INSTALLING PHPMyAdmin:

more…

close Port 445:

• Click Start >> Run, to open the Run dialog box
• Here, type regedit to open the registry.
• Navigate to the following registry key - HKEY_LOCAL_MACHINE >> System >> CurrentControlSet >> Services >> NetBT >> Parameters
• On the right-hand pane find the option TransportBindName.
• Double
  click on TransportBindName and delete the existing default value.
• 
  click Ok

From the above, it is clear, that you have closed Port 445 by giving a blank value to TransportBindName for NetBT services.

close Port 135:

• Click Start >> Run, to open the Run dialog box
• Here, type regedit to open the registry
• Navigate to the following registry key - HKEY_LOCAL_MACHINE >> software >> microsoft >> Ole
• On thee right hand window pane find an option called EnableDCOM
• Double-click EnableDCOM and change the value from Y to N
• click Ok
• Close the Registry Editor and restart your computer

Ways to secure your MS SQL connection string in ASP .NET.

We have seen allot of people looking to have the best option to secure the connection string in their ASP .NET code to connect the MS SQL database since it contains the username and password of their database. It is very important to use a secure method for corporate clients and those who save Credit Card details in their MS SQL database. Or they will easily get hacked and all the important data will be exploited by the hacker.

Here are the list of methods that can be used to secure your MS SQL connection string in your ASP .NET application.

METHODS:

1. Using a DSN connection string:

If you have the administrator user access to your Windows Server or use a control panel like Plesk then you can create a DSN with ODBC connector that stores the password of your database along with its name.

You will have to go to Start >> Administrative Tools >> Data Sources (ODBC) on your Windows Server with an account that has administrative privileges.

Or if you use a hosting control panel like Plesk that you can create the DSN from the control panel itself.

Once you have created the DNS you will have to mention it in your code as:

oConn.Open "DSN=mySystemDSN"

more…

What is ASP .NET?

ASP .NET, a higher version of ASP, is a programming framework used to create enterprise-class Web Applications. These applications are available to the entire world providing efficient information to their end users. ASP .NET has far more advantages than just a next version of ASP.

Why ASP.NET?

Microsoft has worked well to shift their focus on Internet world from a Windows based platform since 1995 and finally Microsoft introduced Active Server Pages (ASP) in 1996 that was much easy to understand than the orthodox languages like Java, C++ and Perl as it offered the efficiency of ISAPI applications. However ASP scripts were difficult to debug and main since it consisted unstructured code and interpreted script. ASP also made it difficult for developer to ingrate the web development software as it required to understand many different technologies. If the web application grew more complex and bigger it became hard to maintain as the number of lines in source code increases dramatically. Therefore, a need of an architecture was required that would allow development of Web application in a consistent way.

more…

The architecture of Microsoft MSSQL Server is mainly divided into three components:

1. SQLOS: which implements the basic services required by MSSQL Server, including thread scheduling, I/O stat management and memory management.

2. Relational Engine: which implements the relational database components including support for databases, tables, queries and stored procedures as well as implementing the type system.

3. Protocol Layer: which exposes the MSSQL Server functionality.

SQLOS

SQLOS is the base component in the SQL Server architecture. It implements functions normally associated with the Operating System, thread scheduling, memory management, I/O management, buffer pool management, resource management, synchronization primitives and locking, and deadlock detection. Because the requirements of SQL Server are highly specialized, it implements its own memory and thread management system, rather than using the generic one implemented in the OS. SQLOS also includes synchronization primitives for locking as well as monitoring for the worker threads to detect and recover from deadlocks.

more…

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition

You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

1.    Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click MS SQL Server Surface Area Configuration.
2.    On the MS SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.    On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
4.    On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Enable the SQL Server Browser service

If you are running MS SQL Server 2005 by using an instance name and you are not using a specific TCP/IP port number in your connection string, you must enable the SQL Server Browser service to allow for remote connections. For example, MS SQL Server 2005 Express is installed with a default instance name of Computer Name\SQLEXPRESS. You are only required to enable the SQL Server Browser service one time, regardless of how many instances of SQL Server 2005 you are running. To enable the MS SQL Server Browser service, follow these steps.

more…

One of the ways by which Computers get affected by viruses is through USB Pen drives. Anti viruses are unable to detect them and even if they do, in most cases they are unable to delete the virus. Following are the precautions you can take when plugging USB Drive on your Computer.

Whenever you plug a USB drive in your system (which you think is infected by virus), do not open it -  Do not click ‘OK’ !
click on ‘Cancel’. Now open Command Prompt by typing ‘cmd‘ in run box.
Type dir /w/a and press enter.
Above command will display list of files in pen drive. Check in the list if the files are not

* Heap41a
* New Folder.exe
* Autorun.inf
* svchost.exe
* Ravmon.exe
* or any other exe file which may be suspicious.

If any of the above files are present in the list, then your USB drive is infected. To remove these files, type the following command in command prompt
attrib -r -a -s -h *.* and press enter.
This will remove from files  Read Only, Archive, System and Hidden attributes .

The files which you will now be looking on are the junk files (viruses) and can be deleted using  del command. Delete all those files which you find suspicious. To be on a safer side, just scan again your  USB Pen drive using a anti virus to check whether it is free of virus or not.

What is Hot linking ?

The process of direct linking to websites files such as images, videos etc. It is like using an image (tag/image link) which you have found on someone else web page, and would be using on your blog. Every time the blog is browsed image will be shown because it is Hot linked from it’s original source.

This becomes a point of concern when your website is Hot linked by someone else.

Let me explain
Every website has a fixed bandwidth (bandwidth - Amount of data transferred from website to a users computer). When a user browses a web page , the website’s
bandwidth is used in transferring the requested data.
??? => You are paying for the bandwidth which is used by others.

To overcome Hot linking(Bandwidth Theft) Hotlink Protection is used. It prevents other websites from directly linking to files (as specified above) to your website.
Hotlink Protection can be set from Plesk Control Panel.