Microsfot SQL connection FAILS only post deployment - Works in designer???

Seth Dailey

My (MS) SQL connection is acting strange, I can validate connections but it says the username accessing the DB within the Metastorm site it fails… how does that even make sense?

 

Basically:

In terms of connections everything checks out, but when it does a query it fails.

 

How is this even possible?  It is the same user credentials that are used in the designer?  ANYONE???

 

Thanks.

Michael_Turek

Check to see if you have permissions to the tables you are trying to query.

Jerome_Pearce

Check that the account you deploy from has DBO rights on the database. This is required in version 9. See:
http://metastorm.processmapping.com.au/post?id=4115877
http://metastorm.processmapping.com.au/post/DB-privileges-required-to-publish-procedures-5142577

Seth Dailey

Yes, nothing has changed other than the update.  To reconfirm i've logged in with the credentials and everything checks out.

Seth Dailey

Bingo! (ish).... I found the Metastorm problem.

 

…the logon should be: '?\?' not '??'. However this is nothing I can control, not sure how to fix it.

 

System.Data.OleDb.OleDbException: Login failed for user '??'.
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Metastorm.Engine.Connectors.OleDBConnector.Execute(String commandText, IList`1 parameters, Boolean includeSchemaInformation)
   at Metastorm.Engine.Runtime.FolderMethods.SelectSql(String sql, String connectionString, IList`1 parameters)
   at Metastorm.Runtime.Core.Mstm.SelectSql(MboConnectionInfo connection, Text sql, QueryParameter[] parameters)
   at Metastorm.Runtime.Core.Scripts.Activities.MstmActivity.SelectSql(MboConnectionInfo connection, Text sql, QueryParameter[] parameters)
   at Metastorm.Runtime.Models.Project_RxCredit.RxCOverRideFileProcess.Declarations.RxCOverRideFileProcess_RxCORFTimelinekey_WhenActionCompleted.Declarations.CopyOfCopyOfCodeActivity1.Execute(ActivityExecutionContext executionContext)