BCM and SQL connection issues " can not connect to database"

Similar Threads:

1.MSO OL sp2 for BCM broke SQL Database connection

Two days ago an MS update for MSO OL sp2 for BCM wanted to be installed so I 
left it get installed. After the installation I noticed that my data 
connection to the BCM database was broken.

I am using MSSQLSERVER instance name for SQL Server Developer Edition 
instead of MSSQL instance name which is for SQLEXPRESS. I have been usine SQL 
Server Developer edition with BCM for quite awhile without any problem but 
now after sp2 was installed I cannot connect to the database as it cannot 
find it.

I ran the database Admin tool to share it and everything ran successfully 
with a pretty instruction page that opened in IE to walk one through 
connecting to the database in OL. The initial connection failed when I 
selected the connect to an existing databse as it wanted to connect to the 
default SQLEXPRESS instance, then I typed in the computer name 
localhost\MSSQLSERVER,1433 and it cannot find the database to connect.

Has anyone else had this ridiculous issue and how can I solve it?

-- 
Thanks,

MaitreMind

2.Outlook with BCM installed on SQL server cant connect to database

Question:
Can BCM 2007 client access a shared database hosted on SQL2005 on the same 
machine client installed on?

I know this should not normally be done, but have new client who has one 
remote user who is the MD who uses an RDP session to thier SBS 2003 box to 
work.  He does not want to have an extra desktop PC for his sole remote 
access, or a Terminal Server when he's the only remote user.

The BCM database is on a custom instance/database on the SQL, but when 
trying to connect to shared database, using the same details which work on 
the workstations, it can connect and shows the database name.
But when we click Next we recive
"Business Contact Manager for Outlook could not complete your last action or 
actions. Please try again."

In the event viewer we recive :
Event ID 17207
FCB::Open: Operating system error 32(error not found) occurred while 
creating or opening file 'C:\Documents and Settings\%username%\Local 
Settings\Application Data\Microsoft\Business Contact 
Manager\MSSmallBusiness.mdf'. Diagnose and correct the operating system 
error, and retry the operation.

and

Event ID 17204
FCB::Open failed: Could not open file C:\Documents and 
Settings\%username%\Local Settings\Application Data\Microsoft\Business 
Contact Manager\MSSmallBusiness.mdf for file number 0.  OS error: 32(error 
not found). 

3.BCM Database and SQL Server Issues?

Hi,

This is a follow-up question to one that I wrote last night concerning using 
the .mdf and .ldf files from a previous installation of BCM to get most of my 
data back.

I have received an error which states "Unable to open the physical file.... 
.mdf. Operating system error 5: "5(Access is denied)" when I attempt to 
troubleshoot the problem from within Outlook.

I remember when I logged on the backup image file to mount the backup on the 
external hard drive, and then copy the two files above from the image file to 
a location on the local hard drive, a window pops up that states that I will 
need to provide administrator permission to copy each file. I click continue, 
and it is copied.

If I look at the security section of the properties window for each file, I 
see that there is an entry for 
"SQLServer2005MSSQLUser$NewTechFX530$MSSMLB1(NewTech....)" on the files which 
are part of the image backup file. But, when I copy the files over to my 
current boot drive, there is no longer a reference to that group or user 
name. (The groups and user names listed are: "SYSTEM", "NETWORK SERVICE", 
"Jeff (NewTechFX530\Jeff)" and "Administrators (NewTechFX530\Administrators".

I am trying to muddle my way through this... so pardon my thought process if 
it is wrong. Based upon the fact that SQL is not referenced in the copied 
group or user names, should I be doing something with SQL to add it to get 
these files to work on this system? (It is the same system, I just restored 
the boot drive from a much older backup image. The computer name and the 
permissions should all be the same.)

Thanks in advance for any help that can be offered.

Jeff

4.BCM SQL database file not recognized

I had to move my SQL file from my laptop drive to my desktop drive due toa 
unit failure. However, BCM will not recognize the database even though it is 
located in the same folder as the default database and has the same 
extension. I have tried all of the available restore and database rebuild 
options that I can find but noe of them will allw me access to the file. I 
am wondering if it has something to do with permissions. At any rate I am 
hamstrung if I can't get this file to open. Anyone out there who might be 
able to help with this? 

5.Connecting BCM 2007 to a shared BCM 2003 Database

6. BCM for Outlook 2007 not connecting with database on server

7. Connection with an SQL Server 2005 database

8. Unable to connect to local SQL 2005 Database