Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
EXECUTE permissions
Author Message
ldeeder Offline
Junior Member
**

Posts: 3
Joined: Feb 2012
Reputation: 0
Post: #1
EXECUTE permissions

I have installed the trial or VisionAppRD on a terminal server.

Windows 2008 R2 with database on Windows 2008 R2\SQL 2008

I have installed the app with the "change user /install" switch.

The application runs fine when logged in as administrator, but not any other user. Here is the error:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
visionapp.vCCCommonLib.ExceptionHandler.vCCException: The EXECUTE permission was denied on the object 'vCCSelectAllConfigValues', database 'VisionAppRD', schema 'dbo'. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'vCCSelectAllConfigValues', database 'VisionAppRD', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at visionapp.CommonLib.Provider.Database.DbProviderSql.ExecuteReader()
--- End of inner exception stack trace ---
at visionapp.vCCCommonLib.Configuration.GetDbProvider.HandleCommonLibExceptions(Cus​tomExceptionType type, Exception e, String title, String details)
at visionapp.CommonLib.ExceptionHandler.ErrorHandler.ThrowException(CustomException​Type type, Exception e, String title, String details)
at visionapp.CommonLib.Provider.Database.DbProviderSql.ThrowExecption(Exception e, String title, Boolean logConnectionString)
at visionapp.CommonLib.Provider.Database.DbProviderSql.ThrowExecption(Exception e, String title)
at visionapp.CommonLib.Provider.Database.DbProviderSql.ExecuteReader()
at visionapp.vCCCommonLib.Database.ConfigDb.LoadConfigurationValues()
at visionapp.vCCCommonLib.Factory.Preferences.GetPreferences.LoadConfigurationFromD​atabase()
at visionapp.vCCDesktopFrontend.Dialogs.DialogDatabaseManager.buttonConnect_Click(O​bject sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5448 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
vCC
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vRD70.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5446 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5447 (Win7SP1GDR.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
vCCAPI
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vCCAPI.DLL
----------------------------------------
vWinCommonLibC
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vWinCommonLibC.DLL
----------------------------------------
vCCCommonLib
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vCCCommonLib.DLL
----------------------------------------
vCCDesktopFrontend
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vCCDesktopFrontend.DLL
----------------------------------------
CommonLib
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/CommonLib.DLL
----------------------------------------
SandDock
Assembly Version: 3.0.5.1
Win32 Version: 3.0.5.1
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/SandDock.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
vCCResources
Assembly Version: 7.0.3328.0
Win32 Version: 7.0.3328.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vCCResources.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
vSIT
Assembly Version: 1.1.0.0
Win32 Version: 1.1.0.0
CodeBase: file:///C:/Program%20Files%20(x86)/visionapp%20Remote%20Desktop%202011/vSIT.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:


<system.windows.forms jitDebugging="true" />


When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
15-02-2012 11:59 PM
Find all posts by this user Quote this message in a reply
ryanr Offline
visionapp
***

Posts: 141
Joined: Dec 2008
Reputation: 0
Post: #2
RE: EXECUTE permissions

For your database connection how did you configure the connection?
Integrated windows auth, or specified user/password.

If your using database mode and used integrated windows auth for the db connection. you'll need to grant all your users I believe DBO access to the database for access. Once in the program you can activate rights control within the program based on their logins to restrict their access.

In a TS environment it usually makes sense to create a SQL account grant it DBO and specify that for the connection account. its stored in the vrd.config file in C:\ProgramData\visionapp\vRD 2011 on server 2k8 r2. Users wont see it and if they do the information for the password is encrypted as well. This way you don't open the database up to any users. If your going to distribute the program to various users and machines in the environment then it makes alot of sense to grant a those users via a ad group access to the database.

Hope this helps out.
16-02-2012 12:19 AM
Visit this user's website Find all posts by this user Quote this message in a reply
ldeeder Offline
Junior Member
**

Posts: 3
Joined: Feb 2012
Reputation: 0
Post: #3
RE: EXECUTE permissions

Thanks for the quick reply.

I am using specified user/password.

I have a designated user with DBO permissions.

And like I said, it works fine if I am logged into the terminal server as administrator.
16-02-2012 01:46 AM
Find all posts by this user Quote this message in a reply
DevOma Offline
Posting Freak
*****
visionapp

Posts: 3,385
Joined: Aug 2006
Reputation: 10
Post: #4
RE: EXECUTE permissions

Perhaps you set up the database with "Username/Password" - but if you are using aother user you can connect again to the database - it seems to be "Integrated" configured - the message/error comes from the sql server and the user that is used (by the connection string) is not able to connect to the database bacause of missing security rights...

Regards/Gruss
Oliver
16-02-2012 12:43 PM
Find all posts by this user Quote this message in a reply
ldeeder Offline
Junior Member
**

Posts: 3
Joined: Feb 2012
Reputation: 0
Post: #5
RE: EXECUTE permissions

I created a new user in Active Directory calle vision.app. I then added that user to the VisionAppRD database as DBO. I specified that user as the user to access the database in the configuration wizard. I still get the same error.
I also forgot to add that the application works fine if it is locally installed on a PC.
(This post was last modified: 17-02-2012 01:10 AM by ldeeder.)
17-02-2012 12:33 AM
Find all posts by this user Quote this message in a reply
DevOma Offline
Posting Freak
*****
visionapp

Posts: 3,385
Joined: Aug 2006
Reputation: 10
Post: #6
RE: EXECUTE permissions

Perhaps you have any restirctions on your terminal server - if it is working on a local pc it must be any configuration of the server...

Regards/Gruss
Oliver
17-02-2012 09:28 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)

Contact Us | ASG Software Solutions | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication