Showing posts with label purpose. Show all posts
Showing posts with label purpose. Show all posts

Friday, March 23, 2012

Error when installing MSDE

Hello Everyone

I have worked a little with MSDE mainly for the purpose of a tutorial book.

Right now I have just switched to an XP pc, and i am trying to install it once more, However I am experiencing severe problems when doing so, and i cannot find the correct answer, despite trawling thru these forums.

I am running the command prompt and

cd \sql2ksp3
then cd msde, followed by
Setup SAPWD=password SecurityMode=SQL
It then begins installing, and as it reaches the conclusion i get an error

Setup Failed to configure the server ,refer to the server error logs and the setup error logs for more information.

I just cannot work out what is causing this, i have plenty space on my pc, i am running winXP It seems so many people are having problems with MSDE

is there any way i can install it without a command prompt? or does anyone have a link to a proper installation guide.

Or maybe somone can help me with this problem

Thanks so much in advance

RaphaelIt seems like the Security Mode=SQL causes trouble. Try to install it with just SAPWD=password, I did and it worked

Friday, February 24, 2012

Error traping in DTS

I am using a DTS for my purpose and I am calling that DTS execution in a stored procedure(using master..xp_cmdshell dtsrun/F).I like to store the error meassage or error description in the Stored Procedure if it fails due to any reason.How can I do that?call the dtsrun also with /L<log file path >|||Will you kindly give me a brief of that please?|||dtsrun gets some arguments the /L <file path > switch "tells" dtsrun where to log it executed steps results
for more info search books online for "dtsrun Utility" there you can find all info about dtsrun.