I have a single MSDE SQL-Server instance on a Win 2000 Terminal Server. I can connect by windows authentification or using SQL Server authentification. I can administrate the sql server instance using enterprisemanager. But it only works local. Trying to connect to the server from anonther server or workstation does not work.
I can ping the server and I can use ressources of the server (task for example) from other computers, but enterprise manager 2000, simple ODBC Connection or SQL Server management Studion 2005 can't establish a connection to the MSDE instance.
Any suggestions ?
Thanks a lot