.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Cannot connect to SQL 2000 via VPN

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


Why can't VPN users run our applications, none of the apps will connect to SQL? It used to be fine, then some MS certified techy dialed in , trashed our server and left us without a functioning system, I cannot work out how to fix the problem so your help is appreciated.

We have SBS 2003 Premium with SQL 2000.

They corrupted our default SQL so created a new instance, all apps work fine if ran while connected in-house , but VPN users can no longer run and use our SQL apps.

I've telneted to the server IP on port 1433 and I get a repsonse, so it isn't firewall or port settings that is the probelm.

I've installed SP4, which the VPN issue is suposed to be fixed in SP2, but this hasn't made any difference.

I've checked that named pipes has the correct syntax..




 and TCP/IP is enabled on port 1433, the old corrupted default instance I have set to port 0 and ticked 'hide server'.

All services such as SQL Browser are running and also the web applications that connect from a co-located server down our dedicated DES VPN (router 2 router) all works fine.

It is ONLY remote users connecting to the SBS server via VPN and that SQL server that cannot be contacted, even the web server

View Complete Post

More Related Resource Links

Problem with MOM using DMO to connect to SQL 2000 instance

Since the bank holiday weekend the following error message have been generated in MOM The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running. I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues and now I have the following error appearing: The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION" I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors  

Visual Studio won't connect to SQL 2000


Can VS 2010 connect to a SQL 2000 database?

I get this error while using the Data/Connect and SQL Server 2008 R2 comes up.

"The connection failed because this instance of SQL Server is not supported. The Editor cannot connect to SQL Server 2000 or earlier


Our production server is on SQL 2000

How can connect Sqlserver 2000 over internet


Dear All

i need all of you help me. i want to conect sql server over internet from 1 country to other country using vb 6.

if can please show in example code?


thank for your help.


How to create linked Server to connect from SQL Server 2008 to SQL Server 2000


How to create linked Server to connect from SQL Server 2008 to SQL Server 2000.

I following the steps to create the linked server in the GUI but failed with the following error message.

I used the full computer network name as the 'Linked Server' name

 OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "my_server_network_name" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "my_server_network_name". The provider supports the interface, but returns a failure code when it is used.

Thanks a lot for your help.


InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

could somebody give me example how I can connect to database only once if I use many models in contr


I use in my ASP.NET MVC application repository pattern and I use in controller for example 3 models:

   namespace MvcApplication1.Controllers  
        public class HomepageController : Controller  
            private IWebsitesRepository _repository_websites = new WebsitesRepository();  
            private IFirmRepository _repository_firm = new FirmRepository();  
            private IPhotosRepository _repository_photos = new PhotosRepository();  

In WebsiteRepozitory, FirmRepository and PhotosRepository classes I have:

Database1Entities _entities = new Database1Entities();

So I have 3 connections to database ? Is it wrong ? How can I solve it ?

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

SAAS: Connect Enterprise Apps with Hosted BizTalk Services


In this article we introduce you to BizTalk Services, new technology that offers the Enterprise Service Bus features of BizTalk Server as a hosted service.

Jon Flanders and Aaron Skonnard

MSDN Magazine June 2008

Interop: Connect To Mainframe Apps With BizTalk Adapters and .NET


If you have a significant investment in legacy COBOL applications running on mainframes, you need the BizTalk Adapters for Host Integration Server .

Bashar "Bash" Badawi

MSDN Magazine December 2007

Data Points: XML Features in SQL Server 2000


SQL ServerT 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.

John Papa

MSDN Magazine June 2005

{ End Bracket }: On Being Crew for Fantasia 2000


I was asked to reminisce about my experience as a software technical director on the Firebird segment of Disney's Fantasia 2000 in the special effects group. They're the group that puts the twinkle in Mickey's eyes, literally.

Stanley B. Lippman

MSDN Magazine May 2005

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000


SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003

Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to


Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002

SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000


XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002

Windows 2000 Loader: What Goes On Inside Windows 2000: Solving the Mysteries of the Loader


DLLs are a cornerstone of the Windows operating system. Every day they quietly perform their magic, while programmers take them for granted. But for anyone who's ever stopped to think about how the DLLs on their system are loaded by the operating system, the whole process can seem like a great mystery. This article explores DLL loading and exposes what really goes on inside the Windows 2000 loader. Knowing how DLLs are loaded and where, and how the loader keeps track of them really comes in handy when debugging your applications. Here that process is explained in detail.

Russ Osterlund

MSDN Magazine March 2002

SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web


Using XML for data access allows you to separate the data from the presentation, and promotes reuse, extensibility, and division of labor. XML also has a simplified data model, which promotes easier testing. This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

Scott Howlett and Darryl Jennings

MSDN Magazine January 2002

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend