11-26-2012 11:54 AM
You can also change this in the initial connection window for SSMS. From the query window, right click -> Connection -> Change Connection. Thjis will open the Connect to Database window, choose Options then go to the Additional Connection Parameters window.
From that window add "Application Name= <put your USERID GUID here>" and this will impersonate an act user and allow you to perform the query. As Stan has mentioned the problem is that the query you are trying to run has some security requirements and as a result needs a qualified Act user to execute.
11-27-2012 02:20 AM
Guys Thank you very much, adding the APP in my PHP connection string and "Application Name=" in my SQL connection on Management Server solved the problems now I can access all the data I wanted. Much appreciated..
11-27-2012 03:19 AM
Quick follow up question guys, I changed my ACTADMIN, ACTREADER and sa users' passwords
by any chance is there anyway for me to restore them or do I need to reinstall my ACT and get another copy of my database ?
11-27-2012 09:26 AM
There is a program in ACT! for Windows folder called SecurityCmdLnApp.exe. I believe that program will reset all the passwords for you.
11-29-2012 03:16 AM
I couldn't reset my passwords and deleted my ACT and SQL Server and reinstalled them but now I'm having a different problem the ACT I installed is Version 14.1.108 and my old ACT was version 126.96.36.199 when I try to open my database on this new version ACT i got the warning that the database needs to be updated to work with this new version I click OK and everything goes well but it keeps working to update my database and my database doesn't gets updated, there is no error report or something like that it just stucks there. Is there anyway for me to install my older version of ACT, I couldn't find it online.
12-06-2012 03:36 AM
I am thinking of getting sa password to allow me to extend ACT functions such as writing information to ACT database. But I am concerned about the product license policy. What do you think about getting sa password?
Just like you, I am developing my application in PHP, and integrate it through ContactWebContextBrowser.
I use actreader to read ContactID, and use external database to extend the system functions. The two systems' bridge is ContactID.
I have some other information that I want to write into ACT database, while I want to avoid SDK development. The other reason is CompanyWebContextBrowser doesn't work for me. I cannot get CompanyID.
12-06-2012 07:52 AM
What I did for login purpose was to create another user from SQL Managment Studio and give that user the rights to modify database. I think purchasing sa password would not be necessary if you can install SQL Managment Studio, and since this user has the all the rights to modify database I don't have any problems with reading or writing anything to database.
12-06-2012 12:26 PM - edited 12-06-2012 12:35 PM
12-08-2012 12:48 PM
Did you manage to get in the database?
12-08-2012 03:02 PM
thanks for your reply.
No. But I can ask my IT administrator to create a database user.
I tested the solution on my computer. It seems good to R/W database directly via such a user.
1) Login with Windows Authorization, not sa
2) Create a user with r/w permission on ACT7/database
3) Test to R/W a table. It is good!
2) Create another user with Owner permission on ACT7/database
3) Test to create a table. It works.
Any warning you want to give me regarding this solution?
Do you have a CompanyWebContextBroswer that can retrieve CompanyID? I want to use it to extend the company table.
I downloaded a Act.Devnet.CompanyWebContextBrowser v1.2 from the community. But it doesn't work for me.
Appreciate your reply.