Re: Microsoft BCM on SBS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Jim Federico" <JimF@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O7op1fITGHA.6084@xxxxxxxxxxxxxxxxxxxxxxx
We have setup BCM to work with our SBS network and want to move the
database
from a workstation to our server which has SQL server running on it. We
have successfully moved the database from MSDE on workstation to server
and
database is running. The problem is the machines running BCM on
workstations
do not see the instance of database running on SBS server under regular
sql.
Is there any instructions on now to do this? I am so close it is probably
a
simple fix but I am not a SQL expert. I have found numerous vague
articles on this but nothing that helps fix this.

Look through archives of microsoft.public.outlook.bcm for more clues :-)

Are you connecting to SQLSERVER$InstanceName or just SQLSERVER instance?

How are you connecting to the server - sa account or windows account? How
did you move the database?

I think you need to run SVRNETCN to enable TCP/IP and Named Pipes on that
MSDE instance on the SBS server.

Here is a Microsoft document for you:
http://download.microsoft.com/download/c/e/1/ce1ddfb8-ef91-4324-a9c7-28365087441f/W09_Troubleshooting.pdf
--
Leonid S. Knyshov, CEO
Crashproof Solutions, LLC - http://www.crashproofsolutions.com
MCP Exchange 2003/Small Business Server 2003, CCNA, SCSA 8, NCIE
Microsoft Small Business Specialist Partner


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)