SQL Server never login remotely

Question

Hi There,

I have a problem where i installed my SQL Server but wanted to access it remotely using SMO and VB.NET. I did all the necessary steps to have the server available remotely, I added the inbound rules and it is showing to the other devices on the network but, the problem is that, When I come to login with the login and password of the remote server, an error appears saying: "Cannot connect to "Server Name""!

The problem appears when I try to login with both of Windows and SQL Server Authentication!

Can anyone help me on this please?

Thanks in advance,
Hani Mansour

Answer 1

Hi,

Please try the following steps

• Windows Firewall ->Advanced Settings->Inbound Rules

Add a rule to enable TCP port 1433 (default port for SQL Server)

Read this article for details: Configure the Windows Firewall to Allow SQL Server Access

• Run SSMS (SQL Server Management Studio) on SQL Server machine

Server Properties -> Security -> SQL Server and Windows Authentication mode (Enable)

• Enable SQL Service to listen on TCP/IP

Check SQL Server version and run appropriate version of SQL Configuration Manager to enable TCP.

Enable Remote Connections to SQL Server using IP address

Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Answer 2

Hi,

Here is a simple ways to test SQL connectivity.

Create a simple text file, rename the extension from TXT to UDL.

Double-click on the .UDL file and type the hostname or IP of your SQL server, then select a user account with permission to the SQL server and select a database. Then click on “Test Connection”.