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

I Cannot Connect Remotely To My 2000 Server

Contents

Wednesday, April 19, 2006 6:50 PM Reply | Quote 0 Sign in to vote Are you sure that your sql 2000 is named instance? I think in your case, it is 10.0.0.4. (c) configure port forwarding as TCP. Externel ip address should be "0.0.0.0" (b) configure  "internel port" of port forwarding to "1433" and "ip address" to ip address of [sql server]. Safety - Improve braking power in wet conditions Washington DC odd tour request issue Ballpark salary equivalent today of "healthcare benefits" in the US? http://tcsmacs.net/sql-server/error-40-sql-server-cannot-connect-sql-server.php

Is the connection string compatible to your driver? I thing my TCP/IP settings are not fine for SQL Server or I need to do something for add "TCP - 10.0.0.4 to OutsideIp:1433" to my "netstat" report.I'm using Windows XP In addition, you can use “-Stcp:Your_target_machine, Tcp_port” for TCP, “-Snp:Your_target_machine\Your_instance” for NP, and “-Slpc:Your_target_machine\Your_instance” for Shared Memory. since TCP portwarding need to keep TCP session state. [2] configure client to use the "public ip address" assigned by your ISP, (the outside ip address as you refered to).  (a)  test port 1433, with http://stackoverflow.com/questions/12041629/cannot-connect-to-remote-sql-server

Configure Sql Server 2000 Allow Remote Connections

Try to connect remotely to the server (using the SQL Server management studio or Visual Studio .NET), if it works, then your issue was the Firewall. 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. There is no simple solution for this, and we have to solve it case by case. ALSO CHECK REVERSE DNS and also try to connect to the server via \\IP\instance. –Ali Razeghi Jul 18 '14 at 21:16 add a comment| active oldest votes Know someone who can

Make sure to check clients connectivity and use TCP/IP => How can I check it? It is not recognizable by your router externel interface for routing/port forwarding. Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts CAN NOT CONNECT TO SQL SERVER 2000 REMOTELY HI Everyone, I am having trouble with connecting to the sql server 2000 Sql 2000 Sp4 Why were pre-election polls and forecast models so wrong about Donald Trump?

To check this: [u]In Enterprise Manager: Right-click on the appropriate Server Group Select Properties On the General tab, click the 'Network Configuration..' button Select 'TCP/IP' in the 'Enabled protocols:' list box You cannot delete your own events. Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. 2013 John Wiley & Sons, Inc. {{offlineMessage}} Store Store home Devices why I still get the error.checkedremote access 0 1 1 1 Post #442938 GilaMonsterGilaMonster Posted Tuesday, January 15, 2008 6:17 AM SSC-Forever Group: General Forum Members Last Login: Today @ 1:30

I know  how to open SQL Server 2005 for TCP/IP connections. Flush Dns Step 2: SQL Server configuration issue You need to make sure the target SQL Server is running and is listening on appropriate protocols. What is the most someone can lose the popular vote by but still win the electoral college? Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied ================== But it is OK when I use the front-end access database

How To Test Sql Server Connection From Command Prompt

My problem is both of instances are not working on listening ports successfully. Can u provide more detail info about the error message? 1) use Enterprise Manager(use ODBC) to connect to sql 2000, what error reported? Configure Sql Server 2000 Allow Remote Connections Why are wavelengths shorter than visible light neglected by new telescopes? Sql Server Connection Problem What is the out put of netstat -ano the contain state = "LISTENING".

Should you change a thermostat when changing your water pump Photographing Sea Turtles hatching on the beach Lab colleague uses cracked software. navigate here Anyway, do you know a free or trial SQL Server host provider? Else nothing. Happy coding... Cannot Connect To Sql Server A Network Related Or Instance-specific

You cannot edit other events. I can connect to the sql server instance from the visual studio Run a program, that access the data base, without success. I connected with "osql" too.  But I can't connect remotely.  What will I do now? Check This Out I installed win2000 server and sql server 2000 database to the server machine ( new PC).

since TCP portwarding need to keep TCP session state.   [3] configure client use the "public ip address" assigned by your ISP, and the default port, 1433, for example "telnet public_ip_address 1433". What Is My Ip You can also test with "osql -E -Stcp:localhost,1433 on machine [sql server].   [2] configure the port forwarding correctly. (a) configure "externel port" of port forwarding to what ever client want to connect Because I cannot connect "127.0.0.1:1433" or "10.0.0.4:1433" via telnet.

Wrong DNS entry could cause of all sorts of connectivity issue later.

I successfully managed to implement this in sql server 2005, but i have issue in sql server 2000 SP4. This is the first step to confirm that your tcp/ip stack is functioning well. 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 I can't try it with another computer because I have only one box in home. "telnet" failed again.

You cannot post new polls. If no, install sp3a => YES 2. On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? this contact form When connecting to SQL Server 2005, 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:

sql sql-server sql-server-2008 share|improve this question edited Aug 20 '12 at 18:50 marc_s 457k938771041 asked Aug 20 '12 at 16:39 WeDoTDD.com 13.6k80221400 add a comment| 3 Answers 3 active oldest votes 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 But SQL Server service is started. Charlie Tran #2 (permalink) November 29th, 2004, 05:14 PM jemacc Friend of Wrox Join Date: Nov 2003 Location: Lehigh Acres, FL, USA.

Note, you SHOULD NOT use the internal ip address of your [sql server] box. If no, install sp3a 2. If no, install sp3a => YES 2. opening all these ports for incoming traffic allowing access to my server, once I have done that, all my problems were solved and I managed to connect to the SQL server

I checked all log files.