473,394 Members | 1,773 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Trouble connecting to remote db using the .NET data provider for Sql Server

I am working with a database on another system via a ssh tunnel using
plink. We have setup an alias the local system for the remote database.

I am able to connect and work from within Visual Studio if I connect to

the remote database using with "SQL Server" as the data source and
".NET Framework Data Provider for OLEDB" as the data provider . If I
change the data provider to ".NET Framework Data Provider for SQL
Server" I get the following error:

"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default setting SQL Server does not allow remote
connects. (provider: TCP Provider, error: 0 - No connection could be
made because the target machine actively refused it.)"
What do I need to do to fix this?
All help is appreciated.
===
Local system:
Windows 2000 Professional,
SQL Server 2005 Standard
Visual Studio 2005 Standard
.NET Framework 2.0 (1.1 not installed)
Remote system:
SQL Server 2000

Mar 14 '06 #1
0 1649

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Thomas Scheiderich | last post by:
I get an error from trying to connect to my Sql6.5 server (which is why I am using Ole). It says the server doesn't exist or the password is wrong. I can't understand that because I use...
3
by: Ann Marinas | last post by:
Hi there, I am currently developing an ASP.NET program that connects to a SQL Server 2000 database. I also have SQL Server 2005 Express installed on the same local machine. Prior to...
2
by: Dabbler | last post by:
I'm trying to use SqlDataSource to connect to a remote SQL Server 2005 (virtual shared hosting e.g. TCP/IP). I keep getting the following error: provider: Named Pipes Provider, error: 40 - Could...
6
by: Todd Brewer | last post by:
Windows Server 2000 ASP.NET 2.0 SQL Server 2000 (on a physically seperate server) I moved an ASP.NET 2.0 application from a development server to production, and am getting the following error:...
2
by: Patrick F | last post by:
Hi, i have SQL Server 2005 and a database set that is called, myCompany the problem is that i cant connect from my page to it, here is from the web.config: ( i have got this connectionstring from...
4
by: axel22 | last post by:
Ok, I've installed MS Sql Server Express, and I've created a database 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the database locally through a project in Visual Studio. I...
1
by: Lou Civitella | last post by:
I created a test web site with VS2008 using Framework 2.0. Created a database in SQL Server 2005 and am able to connect to it without any problems. I then setup the database to be accessed using a...
2
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to...
0
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.