If the connection fails saying bad public username or password run the resync pubuser account steps on the database. Now now we hope that you got Successful Connection: Just click next (dont change anything again) HOST NAME: IS YOUR COMPUTER NAME\PRIMAVERA (Sometimes the \primavera after the computer name is needed, sometimes not)ĭB NAME: whatever you called your database (Keep database name and alias name the same – be consistent) Now You can Launch P6.2.1 or whatever ver you got:ĭo not hit OK, instead use the … button on the bottom then select Add (to add/create a new DB alias)Įnter Your new name N in the Driver Type Select MS SQL/SQL EXP, OR ORacle?WhATEVER YOUR working on ****Connect to new database / create new alias**** Now: Close SQL Server Management Studio Express Password is Prima123VeraĬlick on the Database that you created: Right Click and Select New Queary:Ĭopy and Paste or type the following text into the query window:ĮXEC sp_change_users_login Update_One,pubuser,pubuserĮXEC sp_change_users_login Update_One,privuser,privuser (change the Authentication mode to SQL Server Authentication). Start SQL Server Management Studio Express and login with the SA account. here (do this before you create the DB alias or lunch P6 or it will not work and you will need to restart the whole thing agian). This is what you need to do first: >Important info.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |