Remotly Access Sql Server 2008 using global IP

Question

2.60/5 (2 votes)

See more:

SQL-Server-2008

Hi,

We have installed sql server 2008 on server PC and all clients can access server using LAN connection. Now we want to access server remotely without VPN network. We are having one global IP through we can connect remotely, but when we try to access server (IP\SqlExpress) it given error number 26.

We have enabled TCP/IP and did all setting using
http://akawn.com/blog/2012/01/configuring-sql-server-2008-r2-express-edition-for-remote-access/

Kindly suggest some solution to access sql server remotely.

Thanks & Regards,
Sheetal Gawde

Posted 9-Apr-13 2:05am

sheetal.gawde

Add a Solution

Comments

ZurdoDev 9-Apr-13 8:18am

I could be wrong but this sounds like a terrible idea. It sounds like you are saying you are trying to open your sql server to the world. Why?

[no name] 9-Apr-13 8:37am

Try http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

khan2010 · Answer 1 · 2013-09-14T03:47:00

I assumed Purpose to Remotly access SQL Server through any application.. Like VB6 or .NET
You can Create a connection string in aaplication (Remote Side Application)

For example in vb6.0 application you can create like this..

VB

If Con.State = 1 Then
    ''Do nothing
Else

    Con.Open _
            "Provider = sqloledb;" & _
            "Data Source=ServerIP;" & _
            "Initial Catalog=DatabaseName;" & _
            "User ID=UserName;" & _
            "Password=Password;"
End If

for "ServerIP" you can use your Internet_Service_Provider's IP.

Hope it will help.