SiriusBlackOp
Programmer
- Oct 20, 2006
- 503
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
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