sql server connect:
I have SQL Server 2000 running on a Win2000 server, and MSDE 2000
running an XP Pro machine (named ASUS). I also have two client
machines from which I wish to connect to both of these. All 4 machines
are in a workgroup, not in an domain.
I CAN connect to the SQL Server and its databases from any of the other
3 computers, using any client application I've tried: Enterprise
Manager (locally), osql (locally or from the MSDE machine),
IIS/ASP.NET, Access project, and an Enterprise Manager clone called
DBMGR2K. All of these work just fine.
I CANNOT connect to the MSDE server on the XP Pro computer using any of
these tools EXCEPT ONE: From the SQL Server computer, I can connect to
the MSDE server using osql. Specifally, I am succesful using these
osql command lines:
osql -s ASUS -E
osql -s ASUS -U sa
Both the SQL Server and ASUS are set up for mixed mode security, and
both have Named Pipes and TCP/IP protocols enabled.
I think the key to this riddle is the fact that osql will connect from
the SQL Server to ASUS, but Enterprise Manager and DBMGR2K will not,
while osql and DBMGR2K both connect the other direction. In all cases,
when I try to connect to ASUS using Windows Authentication or trusted
connection options, I get a "SQL Server does not exist or access
denied" error. If I try using a userid and password, I get a "not
associated with a trusted SQL Server connection" error.
If I didn't say this already, I can use the DBMGR2K program to log on
to MSDE on ASUS locally. In fact, I ran this program on both machines
side-by-side, and compared all the entries on every tab (again, it's
very much an EM clone). The only difference I found between the two,
other than paths to files, was that the SQL Server computer is running
MDAC 2.7 and the MSDE computer is running MDAC 2.8. Everything else
appears identical.
Any help is greatly appreciated. I've spent almost two days stuck on
this.
Duane
