XP Home -LAN Remote Access - Unable to connect from one single computer.

Hot Topic

Error in Derived Column component
Changing data type to the fields of my tables.
Problem appending to a raw file
Microsoft Sql Server Embedded Edition Service
Attribute/Tags style search
Updating column values on Insert trigger
Does MS have a glossary of terms?
Trigger on Select
generate report using recordset
Percentage Format

SQL Server

Check if a windows/nt user account exists
Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permission.
single node cluster
Aggregation dependent on dimension attribute
running ssis package with a remote sql agent?
SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!
Interactive Sort on Drillthrough reports
Tempdb Issues Urgent Help
Data Conversion Error on Excel Destination
Stored procedure parameter position

XP Home -LAN Remote Access - Unable to connect from one single computer.

Hi,

I have Windows XP Home Workgroup LAN.

I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.

I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.

Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.

I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.

Is there any limitation on SQL Express remote connections




Answer this question

XP Home -LAN Remote Access - Unable to connect from one single computer.

  • MichaelD!

    Raghuvt wrote:

    Hi,

    I have Windows XP Home Workgroup LAN.

    I am treating one of the XP Home system as 'Server' and installed SQL Express 2005 SP1. Enabled remote connections access.

    I have total 4 XP Home systems, out of which one i am treating as Server, from the rest 3 computers, 2 are successfully connected to the Server and able to access SQL Express without any problems. But the 3rd system is unable to communicate with the Server. I disabled all firewalls in this 3rd system but still unable to connect to the server. I am able to ping the server, browse for shared folders on the server. Except SQL Express remote connection, everything else in the network is accessible from this 3rd computer.

    Can anyone help me on how to troubleshoot this 3rd computer sql express connection problem to the server.

    I don't have any error message to provide here. It just says, unable to connect to sql server, verify username/password etc.

    Is there any limitation on SQL Express remote connections

    Hi,

    As the error message stated can you re-ensure that Username and password you are using are correct !!!! Or post exact error message and refer SQL Error Log and Windows Event Viewer for errors.

    Hemantgiri S. Goswami



  • XP Home -LAN Remote Access - Unable to connect from one single computer.
Answer this question