 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / October 2006Server no longer on list
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 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.  SignatureKevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com > Hi > When I click on the connection part of my adp, the sql server I normally [quoted text clipped - 4 lines] > Thanks > 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 > 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 [quoted text clipped - 14 lines] >> Thanks >> Vayse 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 SignatureKevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com > Thanks Kevin. As you say, not an error, but I was worried in case it > indicated something else. [quoted text clipped - 25 lines] >>> Thanks >>> 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 > Definitely not. > [quoted text clipped - 32 lines] >>>> Thanks >>>> Vayse Do you have a MSSQL$MICROSOFTSMLBIZ? If so, you have (or had) Microsoft Small Business Accounting on the system or Business Contact Manager. SignatureKevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com > Neither of those are on the PCs, only SQL service is > SQLAgent$MICROSOFTSMLBIZ [quoted text clipped - 40 lines] >>>>> Thanks >>>>> 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. > Do you have a MSSQL$MICROSOFTSMLBIZ? > [quoted text clipped - 45 lines] >>>>>> Thanks >>>>>> Vayse 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 SignatureKevin Hill 3NF Consulting http://www.3nf-inc.com/NewsGroups.htm http://kevin3nf.blogspot.com > 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. [quoted text clipped - 51 lines] >>>>>>> Thanks >>>>>>> Vayse |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.