Re: Server no longer on list

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ukONnqd%23GHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
Do you have a MSSQL$MICROSOFTSMLBIZ?

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



--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Vayse" <vayse@xxxxxxxxxxxx> wrote in message
news:uz8iUmd%23GHA.896@xxxxxxxxxxxxxxxxxxxxxxx
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" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:esKlDwc%23GHA.896@xxxxxxxxxxxxxxxxxxxxxxx
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

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Vayse" <vayse@xxxxxxxxxxxx> wrote in message
news:ezIKfnc%23GHA.4468@xxxxxxxxxxxxxxxxxxxxxxx
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" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:u$kZkac%23GHA.4704@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Vayse" <vayse@xxxxxxxxxxxx> wrote in message
news:eHA%23eQb%23GHA.4740@xxxxxxxxxxxxxxxxxxxxxxx
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













.

Relevant Pages

  • Re: Need urgent help in Database update choice
    ... > update the device db data from a central sql server 2000 db. ... > will be the same for all users(either windows or sql server authentication ... > first time, how to just update the updated data of the server and not the ...
    (microsoft.public.sqlserver.ce)
  • Re: alter table query not working after working at least once. MS SQL 2000
    ... constraint. ... server is MS SQL 2000. ... Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text - ... works again the first time. ...
    (comp.databases.ms-sqlserver)
  • RE: Hardware planning for growth
    ... business in 10 years! ... businesses that had a quad-processor server running SQL Server: ... get data from your database server in the future and/or the load will ...
    (microsoft.public.sqlserver.server)
  • Re: upgrade to Windows??
    ... > I have a small business network. ... Currently I use Linux as a mail ... > server and it works great. ... > a critical business application that uses an SQL server and the vendor only ...
    (microsoft.public.outlook.general)
  • Re: upgrade to Windows??
    ... > I have a small business network. ... Currently I use Linux as a mail ... > server and it works great. ... > a critical business application that uses an SQL server and the vendor only ...
    (microsoft.public.windowsxp.general)