May 14, 2016 at 10:31 am
Hello,
i installed MS SQL Server 2014 on windows server 2008 r2 , now i want connect to it from another computer in another internet , what is i need to do it?
thanks
May 15, 2016 at 10:31 pm
Take a look at this link hope this will help you out: http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer
May 16, 2016 at 2:54 am
I strongly recommend you don't leave that SQL Server accessible from the internet. Set up VPNs so that you can connect securely and ensure that random computers on the internet can't connect to your SQL instance, unless you want it to be hammered by automated connection attempts from China and eastern Europe.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2016 at 4:25 am
I can connect to server via VPN but cann't conecct to SQL Server via VPN.
can you help me how can i connect to SQL via VPN?
Thanks
May 16, 2016 at 4:29 am
Speak to your network admin, or whoever set the VPN up. It's not something that random people on the internet are going to be able to fix for you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2016 at 4:34 am
i am admin of server , when i connect to VPN after it i setup ODBC then SQL Server but not find server to setup.
May 16, 2016 at 4:38 am
Then you're going to have to sit and debug the network connectivity. It's probably closed ports on a firewall or similar, which is why it's going to need a local network admin to help fix.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2016 at 6:23 am
GilaMonster (5/16/2016)
Then you're going to have to sit and debug the network connectivity. It's probably closed ports on a firewall or similar, which is why it's going to need a local network admin to help fix.
And if you're trying to connect to another computer / server on a different network, you'll also need someone over there to troubleshoot with you. The problem may exist on both ends. You'll find it hard to solve this on your own, especially if the different network is in a different geographical location.
May 17, 2016 at 6:44 am
In reading the replies, not sure if you are building an internet application or attempting to connect via a VPN. Your scenario isn't clear. If it's as simple as building and internet application against it, then your code should only need a connection string. What is the Use Case?
May 17, 2016 at 8:18 am
dukanif (5/14/2016)
Hello,i installed MS SQL Server 2014 on windows server 2008 r2 , now i want connect to it from another computer in another internet , what is i need to do it?
thanks
Launch SSMS from the other computer.
Specify the SQL Server Instance Name.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2016 at 8:29 am
Welsh Corgi (5/17/2016)
dukanif (5/14/2016)
Hello,i installed MS SQL Server 2014 on windows server 2008 r2 , now i want connect to it from another computer in another internet , what is i need to do it?
thanks
Launch SSMS from the other computer.
Specify the SQL Server Instance Name.
Huh.
You know, the rest of us assumed this was a cross-network connection. None of us read it as "connect desktop to server" like you did. Now that I go back and re-read the OP, I'm wondering if that's what (s)he actually meant.
dukanif, what exactly are you trying to do? Establish a connection from a desktop to the server? Or connect multiple servers together? Or what?
If the first option, do as WelshCorgi suggested. If it errors out on a remote connection error, then you'll need to update the server config settings to allow remote connections.
If the later options, please clarify how you're trying to connect so we can better assist you.
May 17, 2016 at 10:58 am
I'm sorry. But again, I don't understand your need.
- Are you building an application to connect to your database?
- Are you trying to connect to it from an application?
- Are you trying to administer it via SQL Server Management Services (build databases, etc)?
- Are you a programmer?
- When you installed it, did you use the default instance or create a named instance? If you used a default instance, then you would use the server name and your credentials via SSMS.
There are more questions. But, I'll stop here.
May 17, 2016 at 11:04 am
Tim Curtin (5/17/2016)
I'm sorry. But again, I don't understand your need.
Tim, the OP has not responded to any of our posts.
May 17, 2016 at 11:58 am
hello,
I am so sorry not answered you , i am so sick .
And sorry i can not speak english good .
I connected to main server via VPN correctly , and in server has SQL Server , now I want connect to sql server on MS Access .
In Server PC , MS SQL Server work correctly and i can connect to it from ms access via odbc connector , but in VPN cannot connect it .
thanks
May 17, 2016 at 12:02 pm
The ODBC connection/Access client has to be on the workstation that you VPN into.
Viewing 15 posts - 1 through 15 (of 39 total)
You must be logged in to reply to this topic. Login to reply