I have setup MSDE on a Windows 98SE system and SQL Server 2000 on a Windows 2003 Server. I have enabled NETBIOS over TCPIP on the Windows 2003 server system. I have a dial up connection established between the two systems. I am able to ping between both the computers successfully using both, the computer names as well as their IPs. Using Enterprize Manager, I am able to register the Windows 2003 SQL Server on the Windows 98 system.
But I am not able to register the Windows 98 MSDE instance in Enterprize Manager on the Windows 2003 system. I keep getting the message that the specified SQL Server does not exist or access denied.
I have added the entry into the HOSTS file, I have tried making the alias for the MSDE system using the Client Network utility. But nothing seems to work. Can someone please help.