Email ListConnect 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
Technology
published
Buy Me Coffee
MSBUILD : error MSB1009: Project file does not exist. Switch: ProjectName.csproj
TECHNOLOGY
13
Read More
ASP.Net Core 2.2 MVC Error g.cshtml.cs: The type or namespace name ErrorViewModel could not be found (are you missing a using directive or an assembly reference). File Error.g.cshtml.cs
TECHNOLOGY
16
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
23
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
20
Read More
A local or parameter named cannot be declared in this scope because that name is used in an enclosing local scope to define a local or parameter
TECHNOLOGY
16
Read More
Solved: docker-compose build asp.net core 3.0 error rzc discover exited with code 150
TECHNOLOGY
17
Read More
[Resolved] Dot Net Core Error "Project file is incomplete. Expected imports are missing"
TECHNOLOGY
17
Read More
Microsoft.EntityFrameworkCore.Database.Transaction[20205] An error occurred using a transaction.
TECHNOLOGY
18
Read More
InvalidOperationException: The model item passed into the ViewDataDictionary is of type 'System.Collections.Generic.List`1', but this ViewDataDictionary instance requires a model item of type 'Another Model'.
TECHNOLOGY
12
Read More
