MSDE 2000 'SQL Server does not exist or access denied.' only from other computer

Hi all,

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

Andreas
DatenkulturAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexey KomarovChief Project EngineerCommented:
Good day,
 Please collect the error logs of the SQL instance. Usually they're at
"C:\program files \Microsoft SQL Server\<SQL Server Instance>\MSSQL\Log\"
In this log should be lines of a kind "SQL server listening on"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatenkulturAuthor Commented:
I was looking for the log some minutes before this post. I found, that logging was deactivated. I activated it. After this action, the connection was possible. Strage...

Possibly it was some of my other actions and they only did not work immediately. Who knows...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.