Community
Showing results for 
Search instead for 
Do you mean 
Reply

Act v17 can't create new database "SQL Server blocked access to procedure ..."

New Member
Posts: 6
Country: United_Kingdom

Act v17 can't create new database "SQL Server blocked access to procedure ..."

Hi folks,

 

Got a problem with creating a new Act database on a server 2008 R2 / SBS 2011 server...

 

It comes up with the following message :

ActSQLError.png

 

SQL Server blocked access to the procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server.

So - I found out how to enable it (eventually) from the blog post at :

http://mehdimirza.blogspot.co.uk/2012/12/sql-server-blocked-access-to-procedure.html

 

So - The problem is now I have three databases that crashed in creation, but I can't log in to delete them.

 

Any ideas how to delete them?

 

Regards

 

Jules

 

 

Nickel Super Contributor
Posts: 341
Country: USA

Re: Act v17 can't create new database "SQL Server blocked access to procedure ..."

The following link is a video with an idea to Fix the problem SQL Server...

 

https://www.youtube.com/watch?v=aEPFd78whBU

 

You need to install  SQL Server Management Studio...

 

Best regards and good luck...

Juan Carlos Otero
juancarlostero@icloud.com