Home > Sql Server > Cannot Connect To Remote Sql Server 2000

Cannot Connect To Remote Sql Server 2000

Contents

If no, install sp3a => YES 2. I been experimenting with alias on the testing environment. Can any help please Apr 24, 2009 09:16 AM|[email protected]|LINK Error mes: Server Error in '/JenisonES' Application. There is no simple solution for this, and we have to solve it case by case. http://electrictricycle.net/sql-server/cannot-connect-remote-sql-server-2000.html

That's all for now. Unfortunately, I don't think my company will be willing to purchase and upgrade to SQL2005 just on the off chance that it might fix my problem!! c) Check the eventlog on your system see if there is more information Reference: http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx Sorry for this wall of text, i hope that something from here can help you solve Can't see what could be wrong with that network. http://stackoverflow.com/questions/12041629/cannot-connect-to-remote-sql-server

How To Test Sql Server Connection From Command Prompt

Posts: 625 Thanks: 0 Thanked 0 Times in 0 Posts Here is my response: Can you connect to your database using Query Analyzer? => YES. What is really curved, spacetime, or simply the coordinate lines? Share a link to this question via email, Google+, Twitter, or Facebook.

Check this page for reference http://msdn.microsoft.com/en-us/library/ms188670.aspx b) Make sure your login account has access permission on the database you used during login ("Initial Catalog" in OLEDB). Where shall I insert it? Sylvain Lafontaine, ing. Welcome to the p2p.wrox.com Forums.

You can try connection using both Windows Authentication and SQL Authentication. Sql Server Connection Problem Not the answer you're looking for? Test connection using SQL Authentication. https://social.msdn.microsoft.com/Forums/en-US/86bde582-5999-46f6-b726-38a861853a94/cant-connect-to-sql-2000-server-from-a-windows-7?forum=sqldataaccess Reply hermiod Member 148 Points 83 Posts Re: SQL Server 2000 Enable Remote Connections Oct 04, 2007 10:05 AM|hermiod|LINK Web.Config as requested.