SSM Remote
- Hello,
I have SSMS on my computer and would like to access remotely the SQL
server on my VPS remotely using SSMS?
How can I do this?
I think I should allow remote connections on my VPS SQL Server and
open the port in Windows firewall?
If yes what is the port of SQL Server?
And can I do the following using SSMS remotely?
1. Restore a database
2. Run TSQL script
3. Edit data on a table
4. Create a backup of a database
Thanks,
Miguel
All Replies
- Hello Miguel,
the default port for TCP/IP communication with Sql Server is port 1433; for the Sql Browser service (resolving Sql Instance names) you need also port 1434 UDP.
But that's the default port; the on which is used you can look up in Sql Server Configuration Manager or in the Sql Server log.
If you can connect to the server, you can perform any operation; of course all you listed.
Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de - Hello,
I tried to setup this but I am not able to access it remotely.
1. My Remote SQL Server Name is something like:
WIN-AAAAAAAA\SQLEXPRESS
2. In server sucrity I defined Authentication as Windows and SQL.
3. I enabled TCP/IP and in the IP2 (the one on my server) I defined the port as 1443; Dynamic Ports is 0.
4. On firewall I added the exceptions:
a) to Port 1443 and TCP
b) C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\Sqlservr.exe .
Finally on my computer's SSMS I am using:
Server Name: WIN-AAAAAAAA\SQLEXPRESS,1443
SQL Authentication
And for username and password I use the same as I use for Remote Desktop.
I also created a Login in my VPS's SQL Server and tried to use that.
Could you someone, please, help me?
I don't know what else to try.
Thanks,
Miguel - Miguel,
Can you ping the remote server?
Can you SQLping it?
Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
