July 12, 2005 at 2:57 am
Hi guys,
Maybe someone here can help me with a little issue I'm currently having:
I have created a new MSDE instance on Small Business Server 2003 standard edition. Any application on the server itself can access the database. Any application on a workstation (XP or Win 2000) can not access the database. Is there any special consideration in terms of security (Ports and Firewalls) in order to connect to this database?
Thanx in advance
July 12, 2005 at 7:42 am
Your MSDE instance may not be setup to listen on any network libraries except shared memory, meaning only applications on the local server could. Look for a file called svrnetcn.exe on the server. This is the Server Network Utility. For whatever reason Microsoft adds a shortcut for it in the Start menu when installing a regular instance of SQL Server, but not when you install MSDE (actually no tool shortcuts get created so maybe this isn't so surprising). If everything is in its default location, you'll likely find the file at:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
K. Brian Kelley
@kbriankelley
July 13, 2005 at 12:03 am
Thanx! your solution solved my problem!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply