Connection to SQL Server.

  • 336Views
  • Last Post 28 August 2017
  • Topic Is Solved
0
votes
Ivan Ivan posted this 28 August 2017

I get an error when I want to connect to SQL Server. The connection data is provided by the hosting.

 

Where should I write the connection port?

Should the server be written with name or IP?

 

I need help to create a SQL Server connection.

I attached image of the error.

 

Thanks in advance.

A greeting.

 

Attached Files

Order By: Standard | Newest | Votes
1
votes
Mariia Zaharova posted this 28 August 2017

When working with SQL Server connections, the main requirement is that your SQL Server database must be available through the Internet. If connecting to database on the local computer, it is required to allow such connections in your firewall. 
If connecting to a computer in the local network, it is necessary to use port forwarding.
Please refer to: 
https://skyvia.com/resources/docs/index.html?sqlserver_connections.htm
https://skyvia.com/resources/docs/index.html?how_to_configure_sql_server_to.htm

 

Also, you can try using the following value for the Server connection parameter:

tcp:IP\named instance,1433

where
IP - is an external IP address of your SQL Server
named instance - your named instance. Please contact to you SQL Server administrator to get this value
1433 - port, on which SQL Server is listening. 1433 is a default port. If SQL Server is listening another port, you should change it for corresponding one.


Please tell us if this information helps.

  • Supported by
  • Ivan Ivan
0
votes
Ivan Ivan posted this 28 August 2017

Thanks for your quick response.

Your help has helped me and the SQL Server connection is now correct. The error was in the port, did not know where to write it. But now it is informed and working.

 

Very thanks for your help.

A greeting.

 

Close