Connect to Another Sql Data Engine Through Internet
I had installed an SQL Data Engine and a Microsoft SQL Server Management Studio on my other computer, the catch was that I wanted to able to connect to the data engine installed on the other computer. I followed the tutorial listed here and also watched several YouTube Videos to help me connect to an SQL Data engine on another computer through the internet. All the hours I spent, no luck at all.
After trying to connect several times and then failure after failure, I watched one YouTube Video Here and then realized that, after port forwarding on SQL Configuration Manager and Firewall configuration I had to put the computer IP Address (Remember: Computer IP address changes when you connect to the Internet with Ethernet or through wireless. Make sure you check what IP address the laptop is using at the moment: The idea is to use the right IP address so the Router directs the traffic to the right computer on a specified port) in format like this; 197.164.1.46,portNumber (e.g. if port number you specified is 4356 then 197.164.1.46,4356 in SSMS Logging Server Name Field, then put your user and password) you specified in SQL Configuration Manager if you follow the tutorial. Done!!
Wrote By: Ernest Mushinge
03/25/18
GitKraken Error Applying Stash could not open directory Access is denied
TECHNOLOGY
Views: 785 0
Read More
HTTP Dot Net Core 2.2 Error 500.30 - ANCM In-Process Start Failure
TECHNOLOGY
Views: 724 1
Read More
We're unable to complete your request invalid_request: The provided value for the input parameter 'redirect_uri' is not valid. The expected value is a URI which matches a redirect URI registered for this client application.
TECHNOLOGY
Views: 546 4
Read More
SQL Server Import and Export Wizard Error: Data conversion failed. The data conversion for column "Column 0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page
TECHNOLOGY
Views: 258 1
Read More
Ruby on Rails Bundle Install Error: Could not find concurrent-ruby-1.1.5.gem for installation
TECHNOLOGY
Views: 235 1
Read More
GitKraken Checkout Failed: could not rmdir. The process cannot access the file because it is being used by another process.
TECHNOLOGY
Views: 233 0
Read More