1. Jhonattan Guillen
  2. Valentina Studio
  3. 月, 6月 13 2022, 12:13 AM
  4.  メールで購読
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"
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
Update:

Valentina Studio Free is not connecting to any SQL Server, I tried on my local server.
添付ファイル
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello,

Could you please show the connection settings dialog? Is the server on 1433 on the localhost, too?
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
Hi,

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

Regards,
添付ファイル
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
Hi,

I tried in another PC, in the local server is running the SQL Browser service, this services is required to Valentina Studio work?
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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.
添付ファイル
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
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.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
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 :(
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
External - so you connect over the internet (no VPN, SSH) by IP address, right?
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
Yes, I connect directly over internet, I not use VPN or SSH.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
コメント
There are no comments made yet.
Jhonattan Guillen 承諾済みの回答
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
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Thank you, not sure, but that may explain the difference - these applications use a client library from Microsoft.
コメント
There are no comments made yet.
  • ページ :
  • 1


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