Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (15)

Resolved Error connecting to sql server with not default port

  1. Jhonattan Guillen
    Jhonattan Guillen
  2. Valentina Studio
  3. Monday, June 13 2022, 12:13 AM
  4.  Subscribe via email
Hi,

I'm trying to connect to MS SQL Server with not default port, my server is not running for 1433 port, When I try to connect, I always received an error "The server was not found or was not accesibble"
Comment
There are no comments made yet.
Responses (15)
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
Update:

Valentina Studio Free is not connecting to any SQL Server, I tried on my local server.
Attachments (1)
2022-06-12_18h56_36.png 2022-06-12_18h56_36.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello,

Could you please show the connection settings dialog? Is the server on 1433 on the localhost, too?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
Hi,

I attached the screenshot, the local server is running on 1433 port.

Regards,
Attachments (1)
2022-06-13_09h30_57.png 2022-06-13_09h30_57.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
Hi,

I tried in another PC, in the local server is running the SQL Browser service, this services is required to Valentina Studio work?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Sergey Pashkov
Sergey Pashkov Accepted Answer
No, SQL Browser is used when you connect to named instance, not using port.
Also, when browser is enabled you can click "..." button and switch to SQL Browser tab to search for servers on the local network.
Is the TCP/IP protocol enabled and 1433 configured as a static port.
I attached the settings that I used.
Attachments (2)
sql_browser.png sql_browser.png
tcpip.png tcpip.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
Thank you for your answer,

I can't connect to server that is not using default port (1433), in my local server I was to enable the SQL Browser Service after that works, local, but to my remote server I can't connect.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
Sergey Pashkov
Sergey Pashkov Accepted Answer
So, on a remote server, in TCP/IP Protocol settings IPAll->TCP Port is set to non-standard value, right? Or how it is set?
What about Antivirus/Firewall software on a remote system? It often prevents a connection.
Other tools like SSMS are able to connect?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
SSMS are able to connect, I can connect with others softwares like SSMS, but not with Valentina Studio.

remote server, in TCP/IP Protocol settings IPAll->TCP Port is set to non-standard value, right?, you are right,is configured with non standard port.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 8
Sergey Pashkov
Sergey Pashkov Accepted Answer
And in SSMS, the host is specified as e.g. 192.168.1.1,12345 where 12345 is a target port?

The tricky part is that other sofware may use MS-shipped client library, and in some cases it is able to connect, Valentina Studio uses cross-platform open source client.

What about a firewall, maybe it is possible to stop it temporary?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 9
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
You are right, with SSMS I connect this way 192.168.1.1,12345,

For remote server I can't turn off the firewall, is a external server.

So, I couldn't connect to the remote server :(
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 10
Sergey Pashkov
Sergey Pashkov Accepted Answer
External - so you connect over the internet (no VPN, SSH) by IP address, right?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 11
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
Yes, I connect directly over internet, I not use VPN or SSH.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 12
Sergey Pashkov
Sergey Pashkov Accepted Answer
What version of SQL Server is used, do you know?

But it looks like something is preventing connections.
About other tools - can you tell what tools have you used except for SSMS to connect to this HOST,PORT?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 13
Jhonattan Guillen
Jhonattan Guillen Accepted Answer
I'm using SQL Server 2019 Express Edition,

I used SSMS, SQL Server DB Forge Studio (Devart) to connect to the server with IP,PORT
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 14
Sergey Pashkov
Sergey Pashkov Accepted Answer
Thank you, not sure, but that may explain the difference - these applications use a client library from Microsoft.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 15
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories