Monday, February 20, 2012

MSSQL Remote Access: Can't find solution after 6 hours of searching...

Hello,
I'm trying to access the MSSQl 'remotey'. I open telnet and go to 127.0.0.1 1433 but can't. It seems I have done everything I can to fix it, but nothing solves the problem.

My firewall is disabled.

I have TCP/IP enabled in "SQL Server Configuration Manager" for both Client Protocol and protocols for MSSSQLSERVER (Shared Memory and NAmed Pipes are also both enabled). VIA is disabled.

In SQL Services, SQL Server Integration Services, Full Text Searc, SQL Server, SQL Server Analysis Services, and Server Browser are running. SQL Server Agent is disabled.

In Server Surface Area configuration, under Database Engine is running (automatic) and "Remote Connections" is enabled to TCP/IP and named pipes. Analysis Service has Local and Remote connections checked and is running (automatic). SQL Server agent is stopped.

Integration Services is running (Automatic) SQL Server Browser is running. (Automatic)

When I look in the error log, it shows...

Date 1/4/2007 3:21:45 AM
Log SQL Server (Current - 1/4/2007 3:21:00 AM)

Source Server

Message
Server is listening on [ 127.0.0.1 <ipv4> 1434].

Date 1/4/2007 3:21:45 AM
Log SQL Server (Current - 1/4/2007 3:21:00 AM)

Source Server

Message
Server is listening on [ 'any' <ipv4> 1433].

I have tried to telnet to port 1434 and 1433 but nothing happens. Does anyone know what else I need to be able to access that port?

Thanks
FoleyOh yeah, this is with SQL Server 2005, Windows XP

Thanks.|||

Hi,

On Windows XP Pro you can install Express & Developer Edition ,Refer below KB and links for workaround

http://support.microsoft.com/kb/555585

http://www.teratrax.com/articles/connecting_sql_server_express.html

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Hemantgiri S. Goswami

No comments:

Post a Comment