Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 3:05am
Comments
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
   
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

Rate this: bad
good
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
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.
  Permalink  
v2

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 504
1 Maciej Los 349
2 Kornfeld Eliyahu Peter 325
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,303
1 DamithSL 4,764
2 Maciej Los 4,306
3 Kornfeld Eliyahu Peter 3,914
4 Sergey Alexandrovich Kryukov 3,538


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 14 Sep 2013
Copyright © CodeProject, 1999-2014
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