Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server-2008
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 3:05am
ryanb31 at 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 at 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
0 Sergey Alexandrovich Kryukov 424
1 OriginalGriff 375
2 CHill60 230
3 CPallini 220
4 Maciej Los 210
0 Sascha Lefévre 75
1 OriginalGriff 70
2 F-ES Sitecore 55
3 Peter Leow 50
4 Dave Kreskowiak 40

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 14 Sep 2013
Copyright © CodeProject, 1999-2015
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