Dear

I have install a SQL server 2000 on Window 2008 R2 Server
I find that I can't remote connect the DB though SQL Server Management Studio

It show error 1326, When I telnet < Server IP > port 1433, It show "
connecting to .....could bot open connection to the hostr, on port 1433:
connect failed

I have already allow TCP 1433 on Firwall and confrim it is using on SQL server
But Still not work

Any one have idea on it and can't give me some advise on it

Regards,

Sean

On 1/26/2010 12:12 AM, Sean wrote:
What credentials are you using to connect? Be sure that they exist in
the SQL database and that they have the required
authentication/permissions....

--

Regards,
Hank Arnold
Microsoft MVP
Windows Server - Directory Services
http://it.toolbox.com/blogs/personal-pc-assistant/

Sean (Sean (AT) discussions (DOT) microsoft.com) writes:
Hm, I don't think that is supported. Or is 2000 a typo?

Without knowledge of your network, this is difficult. But here is a
checklist:

o Is SQL Server running?
o Can you connect to SQL Server locally?
o What if you try "OSQL -E -S tcp:127.0.0.1", locally? That is, you
force TCP.
o If all this works out, check that you can ping the server from
the remote computer.
o Double-check that you have the server-name correctly.
o Try connecting with IP-address rather than server name.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx