Home > Sql Server > I Cannot Connect Remotely To My 2000 Server

I Cannot Connect Remotely To My 2000 Server


Workgroup\mylogin and it appears that workgroup\ actually is the same as somedomain.net\mylogin. Happy coding... I opened 1433 port from my router's configuration page and forwarded it to If the tests with all tools failed, there is a good chance that steps 1-3 were not set correctly, unless the failure is logon-related then you can look at step 6. http://bestimageweb.com/sql-server/load-balanced-server-cannot-connect-to-sql-server.php

You can open errorlog file to see if the server is successfully listening on any of the protocol. So I log onto the actual server, verify that my login is in security and has rights and it appears there. Report Abuse. Happy coding...

Configure Sql Server 2000 Allow Remote Connections

Thanks. What is the most someone can lose the popular vote by but still win the electoral college? I think in your case, it is (c) configure port forwarding as TCP. I will find another computer to test it.

You cannot edit your own events. PLEASE REMEMBER to disallow incoming inbound connections after you did this test!!! Wednesday, April 19, 2006 7:51 PM Reply | Quote 0 Sign in to vote Yes, It's working. Sql 2000 Sp4 Jaime E.

Saturday, April 15, 2006 11:37 AM Reply | Quote Answers 0 Sign in to vote Can you try "telnet internal_ip 1433" from a machine other than [sql server] inside of your I suggest the following. 1) goto the actual sql server and connect using the userid/password that you plan to use. 2) on a different box (that does not go through a Wrong DNS entry could cause of all sorts of connectivity issue later. If no, install sp3a => YES 2.

HTH.   Sunday, April 16, 2006 1:48 AM Reply | Quote 0 Sign in to vote Thank you for your reply "MING LV" 1) SQL 2000 cannot find server. 2) SQL Flush Dns Make sure to check clients connectivity and use TCP/IP => How can I check it? Happy coding. I'm connected tot their VPN so what could be the problem?

How To Test Sql Server Connection From Command Prompt

Here is the "netstat" report.   TCP                LISTENING       1216  TCP                LISTENING       204  TCP                LISTENING       4  TCP               LISTENING       204  TCP               LISTENING       3388 how about use :telnet 1433, what happened? Configure Sql Server 2000 Allow Remote Connections Example for a commutative subring of a non-commutative ring more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us Sql Server Connection Problem On which point(s) in a jet engine does the reaction force act?

With thanks in advance, P.Nellaikumar. http://bestimageweb.com/sql-server/i-cannot-install-sql-server-2005.php Find the Emirps! You cannot delete your own topics. thank you and I am waiting for your response. Cannot Connect To Sql Server A Network Related Or Instance-specific

Take it a step at a time to find the problem. « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch I connected with Management Studio too. The time now is 07:21 PM. have a peek here Outside is the my modem's internet ip.Does anyone know about free Sql Server host providers?

Happy coding... What Is My Ip I don't know what sysadmin logic goes into it, but we have two domains, and user domain2\Bob_Smith can connect to a server on the other domain if he enters SQLDB01.domain1.corp.com. –user565869 You cannot post topic replies.

No luck.

I'm trying to connect with "OutsideIp\SONMEZKARTAL2,1433".Thanks for reading. So I tried, using the username and password they gave me. You cannot edit HTML code. Would an Agricultural Scythe work as a the Signature Weapon of an Assassin?

[email protected] #9 (permalink) December 21st, 2006, 10:34 AM mbrabazon Registered User Join Date: Dec 2006 Location: London, , United Kingdom. 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). There's a new forum for SQL Server 2005. http://bestimageweb.com/sql-server/i-cannot-install-sql-server-2008.php I have had to reboot the server for those changes to allow remote connections to that instance.Note that Remote Connections are DISABLED by default, for SQL Server 2005.Hope This Helps "Key"MCITP:

I removed forwarding from my router and used Windows's Network Connection to forward ports. Restart the SQL Server instance service from SQL server Services node (All this configuration is still done from within the SQL Server Configuration Manager). You cannot post IFCode. I have been trying to setup Microsoft SQL Server 2008 to allow remote connection and specifically I wanted the SQL server to allow SQL Server Management Studio on a different computer

xparse processor with multiple arguments As Italian citizens, what legal documents are we supposed to carry when traveling to Ireland? It is not recognizable by your router externel interface for routing/port forwarding. Is adding the ‘tbl’ prefix to table names really a problem? Posts: 385 Thanks: 0 Thanked 0 Times in 0 Posts troubleshooting is best done a piece at a time.

and make any changes, it will give a warning window that states that you will have to restart the SQL Server Service for changes to take effect. However, I am 99.99% confident that won't ever work because the SQL Server can't validate it with the Domain Server on the domain. –Mike Perrenoud Aug 20 '12 at 18:33 Is there still a way to prevent Trump from becoming president? I put the server name ( used the same as the server PC's name) in the SERVER box, put a check for Using Trusted Conneciton and click OK.

This is what worked: Connecting remotely while specifying the port number in the connection string (SERVER\INSTANCE,PORT) Connecting locally using just SERVER\INSTANCE The SQL Server Browser service is enabled and running for You can use SQL Server Configuration Manager (SCM) to enable protocols on the server machine. Step 2: SQL Server configuration issue You need to make sure the target SQL Server is running and is listening on appropriate protocols.