trouble hit me
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
GOT IT...!!!!!
Your commands did not seem to work separately but with a space line between command it worked and 4:53am my data is recovered. It need some work. Filters gone. Seems my coding structure is a mess. Level of effort activities lost interface milestones betwen programs. A days work and it is all running again....
Backups after updates....no I will freely wet myself and soak that Faulty HDD. Yeah !!!
yes I can....dont give up on me!
Gordon
Can you see the users privuser and pubuser in the Object Explorer under Security --> Logins?
Do you have appropriate access rights?
Maybe your PC need some rest.
Good luck!
Dieter
Dieter
It is 4 in the morning and I am up the bloody wall.
Line for line test and same error "...line1" and"...line2"
Sorry but this is not working. How it is working for you is beyond me.
Gordon
Please check the syntax.
I checked (SQL 2005) and it worked. This script I used for MS-SQL Version 7 already.
I cant check with 2008, but it should work.
Try to execute line by line.
Regards
Dieter
All you guys thanks for the info but no success.
Dieter
If I do run your query then error
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ’.
That helps me...not sure where to look
Gordon
MS SQL-Server requires to synchronize priv- and pubuser if you transfer a database from one PC to another.
Run:
exec sp_change_users_login Update_One, Pubuser, pubuser
exec sp_change_users_login Update_One, Privuser, privuser
for your database and your new PC from MS-Sql Server Management Studio... .
Good luck!
Dieter
I have two computers. The one crashed. I installed P6 on the other. What I could recover reading the faulty disk as d: drive I can get the raw pmdb$primavera file. Even if I change the other computer name to the same as faulty machine it still has error. SQL is crap. I can not over write or seem to import the file. The raw file is just there. What can open it? SQL studio can not create another datafile under database.
Hi Gordon,
I am not sure with my answer but perhaps this will help you. If this a stand-alone installation try to configure your database using the following:
Host Name: COMPUTER_NAME\PRIMAVERA
Database name: PMDB$PRIMAVERA
Username: pubuser
Password: pubuser
Public group ID: 1
Otherwise, there is something wrong with your database during the installation process.
Regards,
Arnold
I was almost so happy but it lasted 1 minute.
Like I wrote...HDD crashed. Can not back up for restore. I can see the file so I need to get the SQL studio express to see it. But I can not seem to get the file attached. Same error...login bad user name from the word go. With the raw file I need magic. I can not understand why SQL can not read it. In the file is user name and password which seems to be the problem. Got to be a way to open it or bypass it. it is 2 am in the morning and still at it...I need a solution please help.
Hi Gordon,
Check the link showing all the necessary steps
http://primavera.zxlm.cn/kb/prim54984
HTH
Cheers,