Problem with connecting Microsoft azure vm MSSql from remote location

I was getting connection inside the VM using MSSQL Server, but not from outside. After reading some comments, I found that I needed to add a specific port for outgoing traffic and added that port at Azure firewall:

Here are the steps to check is it working for you or not:

  1. Start Sql Server configuration Manager
  2. Click on your Server name
  3. Click SQL Server network config
  4. Click on protocols
  5. Click on TCP/IP
  6. At the end of tcp/IP range set your port, I set 1433.
  7. Please restart SQL Database.

Now open port at Azure management portal. And connect through SQL tools or other services.

And also remember to open windows firewall.

rank checker old

Free google keyword rank checker. Insert your domain name and keyword, you will find your rank if you are at top 10 pages. If you found your rank is 26 , that mean you are at page 2.

Find your google keyword rank

Put only domain name (example.com)
Put keyword (my keyword)

”) {
$_SESSION[‘domain’] = $_POST[‘domain’];
$_SESSION[‘keyword’] = $_POST[‘keyword’];
$_POST[‘domain’]=”;
$_POST[‘keyword’]=”;
main();
}

function main (){
$homepage=0;
$ip=get_the_user_ip();

$domain = $_SESSION[‘domain’];
$key = $_SESSION[‘keyword’];

session_destroy ();

$upload_dir = wp_upload_dir();
$dir = $upload_dir[‘basedir’].”/seo/”;
if (!file_exists($dir)) {
mkdir($dir, 0777, true);
}

$dir = $dir.”$ip”;
// echo $dir;

if (!file_exists(“$dir”)) {
$file = fopen(“$dir”,”w”);
echo fwrite($file,”1″);
fclose($file);
}
else
{
deleteOldFile($dir); // Delete files older then today
$homepage = file_get_contents($dir);
$homepage++;

if ($homepage == 11 ) {
echo ”

Sorry, 10 search per day

“;
}
else
{
$position = position($domain,$key,10);
echo ”
position $position”;
if ($positio > 200) echo ”
Keyword not found in first 10 pages Keyword : $key Domain : $domain
“;
else echo ”
Keyword : $key
Domain : $domain
Rank : $position
“;
echo ”

Search limit 10 , Currently searching $homepage

“;
file_put_contents($dir, $homepage);

}
}

}

function position($site,$search_query,$end){
$search_query = str_replace(‘ ‘, ‘%20’, $search_query );
$end = $end * 10;
$key = “AIzaSyA-dg-22b1jqzkfSPENomEXgQrgSLCe3sE”;
$cx=”013580894861529191629:hix6bvfkjbw&alt”;
$rank=1;

for ($start=1;$start=>$end; $start=$start+10){ $count=$start+10; $amazon_url= “https://www.googleapis.com/customsearch/v1?key=”.$key.”&cx=”.$cx.”=json&start=”.$start.”&count=”.$count.”&q=”.$search_query; $amazon_url = str_replace(‘ ‘, ”, $amazon_url); //echo $amazon_url; $google_search = file_get_contents($amazon_url) ;//or die(print_r(error_get_last())); $jsonstore = json_decode($google_search,true); foreach ($jsonstore[‘items’] as $address){ sleep(.01); if (strpos($address[‘displayLink’], $site) > 0)
{
$search_query = str_replace(‘%20′,’ ‘, $search_query );
//echo ”
“. $search_query .” rank is “. $rank;
$start=$end;
return $rank;

}
//echo “items $rank:” . $address[‘displayLink’] .”
“;

$rank++;
}
}
return 9999;
}

function deleteOldFile($file) {
$mdate = date(“Ymd”, filemtime($file));
$date = date(“Ymd”);
if ($mdate = $date) { unlink($file); } } ?>

Privacy Policy

Your privacy is important to us. Any and all information collected at this site will be kept strictly confidential and will not be sold, reused, rented, loaned, or otherwise disclosed to any third party. To make this notice easy to find, we make it available on our home page and at every page where personally identifiable information may be requested.

Session cookies

GulfStateSoftware.com may use session cookies to personalize or enhance your user experience. A cookie is a small text file that is placed on your hard disk by a web page server. Cookies cannot be used to run programs or deliver viruses to your computer. Session cookies expire when you close your browser.

The information we collect

This GulfStateSoftware.com only collects personal data when site visitors opt to register. The information we collect is provided directly by the site visitor’s form submittal.

  • General information we request is collected to provide business services to you and may include such items as login, email, password, name, company, phone and address information.
  • We use e-mail addresses when exporting information to you, and when replying to any e-mail we receive. If you opt-in, we may use your email address to send you periodic newsletters. Such addresses are not used for any other purpose. GulfStateSoftware.com  does not sell, rent, loan, trade, or lease the addresses we obtain to anyone.
  • If you purchase items from this website, we will collect additional information necessary to process payment and deliver product or services to you. Credit card data, specifically, is NOT collected by this website, but is captured directly by our payment gateway.

Site visitors may access the information we collect

Access is given to all collected information.

Why do we collect site visitor information?

We collect information for the following purposes

  • Completing or supporting an activity.
  • Website and system administration.
  • Tailoring the website for its site visitors.

Who has access to the information we collect?

  • Ourselves and/or our agents which utilize the information only for the purpose given.

How long is information kept?

Information is retained to meet the stated purpose. Information is discarded at the earliest time possible.

If you believe that our website has collected incorrect information or if you would like to dispute any information, please contact us.

Free Website

  • Affordable Web Design
    Affordable Web Design in Houston

Gulf State Software offering free website for non-profit, charity and religious organization.

This is to giving back to community service. You only need to have domain name and gulf state software will give you free website installation and hosting service at WordPress platform. If you are looking for your organization website at free or small price then please send us email info@gulfstatesoftware.com.

History

Gulf State Software was founded on January 14, 2016 by Al Aminour Rashid who studied Management Information System at the American International University Bangladesh.

Cookies

Gulf State Software Cookies

Please read the following to learn more about our cookies policy

  1. What are cookies?
  2. What are cookies used for?
  3. What types of cookies are used?
  4. Do cookies include personal data?
  5. Managing cookies

What are cookies?

A cookie is a text file stored in a user’s web browser on any device they use to access a website that holds information regarding the user’s visit, such as preferences. When the user returns, the browser provides the cookie with the stored information to the site.

What cookies are used for?

Cookies are used for adjusting a website’s content to fit a user’s preferences and optimize the website. They store useful information that improve the user’s experience of a website. They are most commonly used for:

  • Storing login information so that a user does not need to re-login on every visit.
  • Recognizing the type of device a user is browsing with and any preferences applied to optimize the website specifically for the device.
  • Creating statistics that help website owners to understand how their users interact with their website, which allows them to improve their structure and content.

What types of cookies are used?

There are two types of cookies: persistent cookies and session cookies. Persistent cookies remain on your hard drive for a period of time specified in the cookie’s file parameters or until removed manually. When you return to a website and it requires you to login again despite previously storing your login information, it is usually because the persistent cookie expired; this helps to increase security while maintaining accessibility.

Session cookies, on the other hand, are used temporarily and expire once the website or browser is closed. They are used to track user activity on a website during a single visit. When a website requires that you verify your age or location once every visit before allowing you to view content and without requiring additional personal details, that is a session cookie at work.

Do cookies include personal data?

If there is a need for the collection of personal information, such as for creating accounts, then cookies may store personal information. However, it is required by data protection law that users are informed of the collection of personal data. This data will also be encrypted to render it inaccessible for unauthorized users.

Managing cookies

By default, browsers are configured to accept cookies. However, these settings may be changed to block cookies entirely, or to inform the user each time they are used. Detailed information about cookies and the options associated with them are available in each browsers’ settings.