July 28, 2008 at 7:09 am
We have an instance of a SQL Server 2005 database running on a non-standard port (1435) at a remote site. To connect to the database locally in SQL Mgt Studio we specify a server name of servername\instancename, and this works fine. However I need to access this database instance from a remote SQL Mgt Studio session (i.e. over the internet).
To connect to the other SQL instances on that server I would usually specify a server name of the IP address of the server (i.e. for those instances which are running on the standard SQL server port) - this works fine. If I want to connect to the "non-standard" instance on that server, and try the following as the server name: n.n.n.n\instancename I get an error: "An error has occurred....may be caused by the fact that under the default settings SQL Server does not allow remote connections).
Port 1435 is open at the firewall on the database server, and there is no general connectivity issue with the server. Could someone please advise on:
(a) What settings/server name I need to connect to the SQL instance running on port 1435
(b) What settings do I need in order to set up an ODBC link to the remote instance running on port 1435?
TIA
Ian
July 28, 2008 at 7:18 am
YOu need to add the port to your connection servername\instance, port
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 28, 2008 at 7:32 am
Hi Ian,
Following on from what Jack has said see the link below in Bol re: Connection Strings
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ee5dbc2c-1fc6-42bd-bdf5-efa792557934.htm
Is your 'non-standard' instance a named instance of SQL? If so it sounds like you will need to open 1434 UDP as well.
Cheers,
Mark
July 28, 2008 at 7:40 am
Ian,
I'm sure there are msdn articles out there dicussing remote access using SSMS... i'll try and find them for you.
Mark
July 28, 2008 at 7:50 am
Thanks so much for the prompt reply - that's worked!
July 28, 2008 at 8:37 am
No problem...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply