Query Analyzer - Timeout when run from the network.

[SiriusBlackOp]

Question:

Why would the Query Analyzer with a given correct set of SQL Server Authentication connection settings work when run from my client pc, but Fail when I open Query Analyzer from a network location.

---------------------------------------------------
Examples:
Open Query Analyzer from my start menu and populate the SQL Server Authentication Settings against a SQL server on my network. -- This Works.

Open Query Analyzer from a network location (say a given neighboring PC on the same network) and populate the SQL Server Authentication Settings against a SQL server on my network. -- This Fails.

Open Query Analyzer from my start menu and use Windows Authentication against a SQL server on my network. -- This Works.

Open Query Analyzer from a network location (say a given neighboring PC on the same network) and use Windows Authentication Settings against a SQL server on my network. -- This Fails.
--------------------------------------------------

Any Ideas Why this wouldn't connect in all four cases?


Senior Software Developer

http://www.scoutsft.com

 

[hmckillop]

I assume SQL 2005 perhaps - you probably need to enable remote connections - its switched off by default.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[SiriusBlackOp]

I'm told that remote connections is enabled.

Senior Software Developer

http://www.scoutsft.com

 

[mrdenny]

There is going to probably be a firewall on the users machine (could be a network firewall as well) which is preventing the network connection.

This FAQ faq962-5481 may be of some assistance.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog