Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (15)

Gelöst Error connecting to sql server with not default port

  1. Jhonattan Guillen
    Jhonattan Guillen
  2. Valentina Studio
  3. Montag, Juni 13 2022, 12:13 AM
  4.  Abonnieren via E-Mail
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"
Kommentar
There are no comments made yet.
Antworten (15)
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
Update:

Valentina Studio Free is not connecting to any SQL Server, I tried on my local server.
Anhänge
2022-06-12_18h56_36.png 2022-06-12_18h56_36.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hello,

Could you please show the connection settings dialog? Is the server on 1433 on the localhost, too?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
Hi,

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

Regards,
Anhänge
2022-06-13_09h30_57.png 2022-06-13_09h30_57.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
Hi,

I tried in another PC, in the local server is running the SQL Browser service, this services is required to Valentina Studio work?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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.
Anhänge
sql_browser.png sql_browser.png
tcpip.png tcpip.png
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
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 :(
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
External - so you connect over the internet (no VPN, SSH) by IP address, right?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
Yes, I connect directly over internet, I not use VPN or SSH.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Jhonattan Guillen
Jhonattan Guillen Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Thank you, not sure, but that may explain the difference - these applications use a client library from Microsoft.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Studio
  3. Permalink zu dieser Antwort
  • Seite :
  • 1


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