Click here to Skip to main content
13,048,846 members (76,332 online)
Rate this:
Please Sign up or sign in to vote.

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

Kindly suggest some solution to access sql server remotely.

Thanks & Regards,
Sheetal Gawde
Posted 9-Apr-13 2:05am
ryanb31 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?
ThePhantomUpvoter 9-Apr-13 8:37am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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..

If Con.State = 1 Then
    ''Do nothing
    Con.Open _
            "Provider = sqloledb;" & _
            "Data Source=ServerIP;" & _
            "Initial Catalog=DatabaseName;" & _
            "User ID=UserName;" & _
End If

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

Hope it will help.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 14 Sep 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100