02-22-2010 04:31 AM
Hi
While i am installing saleslogix 7.5 i am getting following error message while attaching dbs could any one please help me on this. Following is the error message
"Error Copying Databases. Access violation at adress 004C4DBB in module "InstallslxDBS.exe".Read of address FFFFFFF
I am using windows server 2003 as my os and sql server 2008 as my data base server
I am having a valid sa user login for sql server 2008. I am having practise of installing saleslogix 7 but i am running out isseus with 7.5 installation.
Could any one help me on this
Thanks in advance
Solved! Go to Solution.
02-22-2010 04:34 AM
02-22-2010 04:47 AM
Hi when i try to attach it by below process is throwing a error that ldf file not found. Could you please help me on this. Also let me know like whether we need to create sysdba user login on sql server. Also when we need to run the update sysdba user script
Regards
Jack
02-22-2010 04:50 AM - edited 02-22-2010 05:09 AM
You can just delete the entry row for the ldf when attaching the database (it will create the ldf for you)
You will need to create the sysdba user manually attaching the database this way (let me know if you need help with that)
Run the sysdba fix script after you have attached the database - the script will only need to be run again after that if you move the database to another server.
I hope this helps?
02-22-2010 05:00 AM
Just to add to this as Ive noticed your using SQL2008 - You must ensure you follow step 6 on page 29 of the SLX implementation guide (its an easy one to miss)
(Microsoft SQL Server 2008 Only) On the All tab:
a. Double-click Persist Security Info.
b. In the Property Value drop-down list, select True.
c. Click OK.
d. Double-click Integrated Security.
e. Click Reset Value.
Data may exist that does not display in the Value field. This value must be reset to ensure that all data is removed.
f. Click OK.
02-22-2010 05:34 AM
I have tried by deleting the ldf row but i am still getting the same error. So first i created the sysdba user with masterkey as password in sql server 2008. Then i have logged in to sql server 2008 by using sysdba credentials and tried to attch the mdf file but i am unable to attach the mdf file. Please suggest
Regards
Jack
02-22-2010 06:08 AM
02-22-2010 07:04 AM
TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'VDEVSLX'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease)....
------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Could not open new database 'saleslogix'. CREATE DATABASE is aborted. File activation failure. The physical file name "D:\BuildRoot\Gobi\SlxSahara_Release\Sources\SlxSahara\Databases\MSSQL\saleslogix_log.LDF" may be incorrect. The log cannot be rebuilt when the primary file is read-only. (Microsoft SQL Server, Error: 1813) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&Evtsrc=MSSQLServer&E...
------------------------------ BUTTONS: OK ------------------------------
But unfortunately i dont have BuildRoot folder in my d drive i am attaching the mdf file from copying the dvd and placing it in the d drive and attaching it
Regards
Jack
02-22-2010 07:07 AM - edited 02-22-2010 07:08 AM
02-22-2010 07:17 AM
Read only button is not checked but no clue. I am doing that on another machine it is getting attached fine dont know the reason what exactly i am missing
shall i copy the .ldf file from another machine and paste it here will that works???