Server no longer on list

[Vayse]

Hi
When I click on the connection part of my adp, the sql server I normally
connect to is not in the dropdown list. If I type the name it, the
connection works ok.
Anyone got any ideas why this has happened?

Thanks
Vayse

 

[Kevin3NF]

That particular function does a "best effort" to list all the SQL Servers it
can find in a short time frame, and is not guaranteed to work. If you had a
large domain with hundreds of SQL Server instances, it would take forever
for the dropdown to populate.

Since you can connect by typing in the name, you are not technically seeing
an error.

Hope that helps.

 

[Vayse]

Thanks Kevin. As you say, not an error, but I was worried in case it
indicated something else.

This may relate to another issue. Since running the latest windows update
last week, all the PCs in the office appear in the dropdown list. Thats most
likely what pushed the server I use off the list.
Anyone hear of some component of windows update that installs SQL server on
a PC?

Vayse

 

[Kevin3NF]

Definitely not.

Go to one of the machines, and look in services for "MSSQLServer" (2000) or
"SQL Server" (2005)

Never heard of this, so I'll be interested in the results

 

[Vayse]

Neither of those are on the PCs, only SQL service is
SQLAgent$MICROSOFTSMLBIZ
I've tried googling for that, but haven't found anything useful yet.
SQLAgent$MICROSOFTSMLBIZ is set to manual, and is not started, yet these PCs
appear as a server. Any suggestions?
Thanks
Vayse

 

[Kevin3NF]

Do you have a MSSQL$MICROSOFTSMLBIZ?

If so, you have (or had) Microsoft Small Business Accounting on the system
or Business Contact Manager.

 

[Vayse]

Probably the Business Contact Manager that came with Office 2003, I think it
loads up in first time you use Outlook and you can then cancel it.

Wierd that it never happened before this week.Maybe the windows update reset
it.

 

[Kevin3NF]

If it is showing on the drop down, its likely that the service is started.
I think the drop down process (which actually calls a windows API) queries
Active Directory AND makes a lightweight ping to the SQL Server instances
you see