"Erland Sommarskog" wrote:

> Ade (aah@nospam.nospam) writes:
> > I am in the process of evaluating SQL Server 2005 (Developer Edition) on
> > a Windows 2000 SP4 member server in a Windows NT domain with three
> > domain controllers (not active directory).  I have installed both
> > operating system and SQL server software from scratch and succeeded at
> > the second attempt.  The hardware is a P4 2GHz, 1Gbyte RAM and a 40Gbyte
> > disk PC. 
> >
> > When I start the Management Studio on the server, it takes roughly about
> > 5 minutes before it opens up and another few minutes to connect.  Task
> > manager tells me that there is plenty of physical memory available and
> > CPU usage is low so what is it doing?  Network Access?  Is it looking
> > for an Active Directory Domain Controller?
>
> Five minutes each time? The first startup takes longer time. And certainly
> Mgmt Studio takes longer time to start than QA, but five minutes?
>
> The only thing I can think of is that it's looking for the status of
> registered servers that are not available.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

"Erland Sommarskog" wrote:

> Ade (aah@nospam.nospam) writes:
> > Erland, thanks for replying.  If it is looking for the status of
> > registered servers, how can I stop it doing this?  This is the only SQL
> > Server 2005 server on our LAN.  There are other SQL Servers on our LAN
> > (6.5 & 7.0 and possibly MSDEs), is it trying to determine the status of
> > these?
>
> It should track the servers that you see in the window Registered
> Services, but no other.
>
> > The other thing that occurred to me is that our Firewall does not allow
> > browsing or access to the Internet from our servers.  Could it be trying
> > to access the Internet?  If I try and access the Internet via IE, there
> > is a very long delay before IE reports an error that it could not open
> > the search page.  Is there a link? If so, how do I stop it trying to
> > access the Internet?
> 
> If Mgmt Studio would attempt to access the Internet, I should have noticed
> as I run ZoneAlarm to monitor outgoing traffic. (Books Online on the
> other hand attempts to call home when you start it.)
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

"Erland Sommarskog" wrote:

> Ade (aah@nospam.nospam) writes:
> > It is.  I now have it working properly.  By insisting on a proxy for
> > internet connections and changing the default gateway of the server,
> > control is returned straight back to IE (and therefore Mgmt Studio).
> > Also proved it by allowing access to the internet temporarily and there
> > it was in the firewall log, a connection from the server to a Microsoft
> > IP address (Autoupdate is turned off by the way).  Perhaps its not be
> > doing it directly hence ZoneAlarm not picking it up.
>
> Glad to hear that you got it working.
>
> In the SQL 2005 Program group, there is a folder Configuration Tools,
> and there is one program "Error and Usage Report Settings". Do you by
> chance have "Send feature usage reports for all components..." checked?
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>