Community
Showing results for 
Search instead for 
Do you mean 
Reply

Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

Accepted Solution Solved
Copper Contributor
Posts: 42
Country: United States
Accepted Solution

Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

On occasion, I find it useful to connect to the SQL database via MSSMS.  Historically, I've been able to connect to the database and run queries via MSSMS using Windows Authentication; however, we recently installed and began familiarizing ourselves with v18 Premium, and I discovered that I'm denied access to the database completely.  Act works fine.

 

I know I can set the sa password by manually installing the instance, but I'd prefer to avoid that if possible.  Any idea as to why this change?  Can I access the backend by some other means?

 

Thanks.


Accepted Solutions
Solution
Accepted by topic author bconner26
‎01-06-2016 07:37 AM
Copper Elite Contributor
Posts: 81
Country: Canada

Re: Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

[ Edited ]

Use this script and pass in the act SQL service name as a param https://gist.github.com/wadewegner/1677788

Ahsan Khalid

Chief Technology Officer
Keystroke Quality Computing Inc.
www.keystroke.ca

View solution in original post


All Replies
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

You should be able to access it using Windows Authentication.  I've run into this issue quite a few times on various systems and I suspect it is a system policy issue but I haven't ever tried to figure it out.  If you figure it out let us know what the resolution was.  I have I use to reveal the SA password so I just log in using the existing SA login and password.  Send me a private message if you want me to remote in to your system and provide you with your SA password.


Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
Solution
Accepted by topic author bconner26
‎01-06-2016 07:37 AM
Copper Elite Contributor
Posts: 81
Country: Canada

Re: Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

[ Edited ]

Use this script and pass in the act SQL service name as a param https://gist.github.com/wadewegner/1677788

Ahsan Khalid

Chief Technology Officer
Keystroke Quality Computing Inc.
www.keystroke.ca

Copper Contributor
Posts: 42
Country: United States

Re: Unable to connect to Act v18 Premium SQL database via Microsoft SQL Server Management Studio

Brilliant, thank you!