Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?

From: Jack Peacock (peacock_at_simconv.com)
Date: 03/02/05 

Date: Tue, 1 Mar 2005 16:37:22 -0800

"Vsevolod Ukrainsky" <vsevolod@comstar.ru> wrote in message
news:OKAsxeiHFHA.3244@TK2MSFTNGP09.phx.gbl...
> The question is - can I connect to this instance with either SQL Server
> Enterprise Manager or
> SQL Server Query Analyzer?
>
The firewall MSDE is a SQL 2000 instance. You can register it in Enterprise
Manager using the name "nodename\MSFW", where "nodename" is the name of the
firewall. For example, my firewall node name is W3WALL, so I register
W3WALL\MSFW as the SQL Server in Enterprise Manager.

You may encounter some problems if you try to access the instance remotely,
instead of running Enterprise Manager on the firewall. MSFW runs as a local
service (login is NT AUTHORITY\NETWORK SERVICE) and doesn't have any logins
set up for network authentication other than "sa" and
BUILTIN\Administrators. Install the client tools on the firewall, login as
Administrator, and you shouldn't have any problems with Ent Mgr or Query
Analyzer. Be aware that normal behavior is to create a new ISALOG database
every day, so you will see several in the list of databases.
  Jack Pea***