Skip to main content

SQLServer Poiting to Public range

In this article explain about how to configure the sql sever pointing to Public IP .

Prerequisities:
SQLServer 2012(any --v).etc
Windows Server 2012 (any --v)
Firewall Inbound Calls


-SQLServer 2012

SQL Binary Packages- DatabaseEngine,Management Tools,SQL Authentication
Instillation Complete :
Change build in Account to LocalService



After installation Complete


IP Enabling 


Update any Port into the TCP port after that Restart the Service


Firewall Allowing the Port 

Open the SqlServer 




Change the Connection String in Any Type you can Text it works.


Results







Comments

Popular posts from this blog

How to execute Python Script in PyCharm-Configuration

Compile a VBScript into an EXE – iExpress

Sometimes you need to compile a vbscript into an EXE. There are a few applications that allow you to do this, however there is one already installed on the windows build called  iExpress . Before using this, you need to make sure your script works and launches what it is supposed to. E.g. if it launches Internet Explorer with a specific URL. Go to start menu > run and type  iExpress  and press enter. Next > until you are on  Package title . Here enter a title for your exe. Next > No prompt.  Next > Do not display a license.  Next > Add –  Here you will browse to your vbscript .  Next > In the install program section, you need to point to cscript.exe as this is what will run your script. So enter  C:\Windows\System32\cscript.exe “enter vbscript here.vbs” .  Next > Hidden.  Next > No message.  Next > Here you will select where you want to save your EXE files. Then ...