Internosis - knowledge management,ecommerce and project consulting
*Home>>>Application Development

Failing to connect to remote SQL Server 2000 from ASP.NET 2.0?


I have a remote server running Windows XP SP2, with both SQL2005 Express with Advanced Features and SQL 2000 installed. I can remotely connect to the SQL2K instance using Query Analyser or Enterprise Manager. I can also remotely connect to the SQLEXPRESS using Management Studio Express Edition.

I am writing an ASP.NET 2.0 with VS2005 application (actually upgraded from .NET 1.1 with VS2003). However, now I cannot connect to the remote SQL2K from the application. I can connect to a locally installed SQL2K on the development machine, but I cannot connect to the remote server.

WITH NAMED PIPES DISABLED AND TCP/IP ENABLED IN THE SQL2K CLIENT NETWORK UTILITY
provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

WITH BOTH NAMED PIPES AND TCP/IP ENABLED IN THE SQL2K CLIENT NETWORK UTILITY (TCP/IP WITH HIGHER PREFERENCE THAN NAMED PIPES)
An error has occurred while establishing a connection to the server. When connecting to SQL2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have also noticed that from VS2005 using the Server Explorer to add a data connection, I can only connect to the remote SQL2K if I use the OLEDB provider but not the SqlClient.

HOW CAN I FIX THIS? WHERE AM I GOING WRONG?

So... I am not clear from your information - have you or have you not enabled remote connections using the Surface Area Configuration manager for your SQL 2005 instance?

Tags
  E-Commerce   Supply Chain   Data Mining   ERP   CRM   Application Development   Software Consulting   Software Development   Information Technology   Technology Consulting   Project Training
Related information
  • Can you give me a hand?

    looks great to me! have a nice day!

    ...
  • How can IT developer find job in the UK if he has no practice in spoken English, but good writting skills?

    You haven't said what your first language is. Without decent spoken English skills colleagues would imagine they would have problems discussing software build and testing plans with you. There...

  • How is applications of differentiation related to calculus of variation?

    In Calculus of Varations deals with minimization problems the most elementary of which is the Brachistochrone. This is the problem of the shape of a wire which provides the fastest path between tw...

  • Why are people slow to take torture of women seriously?

    Most people are too disconnected from the incidents. Although they hear about it on the news and feel some empathy for the women and men involved, the next day it's back to work/school and the...

  • Best folder structure?

    Well, the best folder structure is to allow for the different areas (GL, AP, AR...) under their respective folders. You should also allow for the ability to introduce newer version of each program...

  • Where can I get funding to start a business?

    Princess trust is a good idea and the age limit is up to 30. They can give you a low interest loan of 拢1000 - 拢5000 providing you have a detailed business plan, cash flow forecast and sales foreca...

  • How to access a database on anothe server in vb.net?

    your connection string should stay close to the same. the difference should be instead of c:/... it would be the machine address or name. also you would include the login/pass with the connection s...

  • How can a UXD / UI designer assess the back-end effort involved when designing front-end functionality?

    Well, MySQL can handle lots of information and still be fast. It works well with PHP, and PHP is easy to learn and code. You probobly want a good control panel for coding and management. I recomend...

  •  

    Categories--Copyright/IP Policy--Contact Webmaster