P
pyay2000
My database was left after system reinslling but I didn't archived it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luther
My database was left after system reinslling but I didn't archived it
Those are sql server files. BCM can't open them directly.
P
pyay2000
Well.So how to open the databese?Where is it?
Luther said:Those are sql server files. BCM can't open them directly.
L
Luther
Well.So how to open the databese?Where is it?
- Show quoted text -
The mdf files needs to be attached to the BCM Sql Server instance.
You can attach a database to sql with sql studio (download it from
microsoft.com) or use osql or sqlcmd:
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html
P
pyay2000
Really thank you but it's too difficult to me
result are
C:\Documents and Settings\Administrator>OSQL -E -S .\mssmlbiz -d master
-Q"CREAT
E DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\Administrat
or\Local Settings\Application Data\Microsoft\Business Contact
Manager\MSBusiness
ContactManager.mdf') FOR ATTACH"
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
result are
C:\Documents and Settings\Administrator>OSQL -E -S .\mssmlbiz -d master
-Q"CREAT
E DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\Administrat
or\Local Settings\Application Data\Microsoft\Business Contact
Manager\MSBusiness
ContactManager.mdf') FOR ATTACH"
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
L
Luther
Really thank you but it's too difficult to me
result are
C:\Documents and Settings\Administrator>OSQL -E -S .\mssmlbiz -d master
-Q"CREAT
E DATABASE MSSmallBusiness ON (FILENAME = 'C:\Documents and
Settings\Administrat
or\Local Settings\Application Data\Microsoft\Business Contact
Manager\MSBusiness
ContactManager.mdf') FOR ATTACH"
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
What version of BCM do you have? With 2003, use microsoftsmlbiz
instead of mssmlbiz on the osql cmd line.
You can check Windows's list of services to confirm whether the sql
service instance is running.
By the way, I recommend you never login and work as user
administrator. That login is not meant for regular use. If the machine
is connected to the internet, the security risks are tremendous.