User Entity properties:

<properties>
   <property name="user_name" type="string" displayname="Full Name" purpose="name"/>
   <property name="user_code" type="string" displayname="Name" purpose="identifier"/>
   <property name="email" type="string" displayname="Email" purpose="email"/>
   <property name="supervisor_user_code" type="string" displayname="Supervisor" purpose="manager"/>
   <property name="default_company_id" type="string" displayname="Pwd" purpose="password"/>
</properties>

User provider properties:

<properties>
   <property name="user_name" type="string" displayname="Full Name" purpose="name"/>
   <property name="user_code" type="string" displayname="Name" purpose="identifier"/>
   <property name="email" type="string" displayname="Email" purpose="email"/>
   <property name="supervisor_user_code" type="string" displayname="Supervisor" purpose="manager"/>
   <property name="default_company_id" type="string" displayname="Pwd" purpose="password"/>
</properties>

Datasouce: (password is not really xxx, I tested with the real one)

(SQL Server 2000 Database)

   server=localhost;database=ePC_06_04_00_25;User ID=sa;pwd=xxx;

I also tried my machine name:

   server=pauyoupc3;database=ePC_06_04_00_25;User Id=sa;pwd=xxx;

Data Table / View    system_user_id

User login property   user_code     (this is a column in the system_user_id table)

I get the error when I click "Test SQL Connection", I get the error.  The Logger console shows:

! - Table Exists failed, - Invalid connection string. Please check MSDTC setting
s and check if Database User settings are valid., Module - C:\WINDOWS\assembly\G
AC_MSIL\Skelta.Configurations.DB\3.5.0.0__2e19164ab495b4e7\Skelta.Configurations
.DB.dll, Source -    at Skelta.Configurations.DB.SqlDbCore.TableExists(String ta
bleName), pauyoupc3, Process - aspnet_wp, 1/18/2008 1:20:35 PM

! - Test Connection failed:-Invalid connection string. Please check MSDTC settin
gs and check if Database User settings are valid., - Invalid connection string.
Please check MSDTC settings and check if Database User settings are valid., Inne
r Exception :Invalid connection string. Please check MSDTC settings and check if
 Database User settings are valid., Module - C:\WINDOWS\assembly\GAC_MSIL\Skelta
.CentralConfigCodeBehind\3.5.0.0__0b81c60a2e4cd174\Skelta.CentralConfigCodeBehin
d.dll, Source -    at Skelta.Configurations.DB.SqlDbCore.TableExists(String tabl
eName)
   at Skelta.CentralConfigCodeBehind.CreateRepository.CreateConnectionString(Boo
lean forTestConnection, String connectionstr, String buttonname)
   at Skelta.CentralConfigCodeBehind.CreateRepository.btnTestForms_ServerClick(O
bject sender, EventArgs e), pauyoupc3, Process - aspnet_wp, 1/18/2008 1:20:35 PM

First verify if the "Distribute Transaction Coordinator" Service is running on both the Database Server computer and the Client computer.

Go to "Administrative Tools > Services"
Turn on the "Distribute Transaction Coordinator" Service if it is not running. 
If it is running and the client application is not on the same computer as the database server, carry out the following steps on the computer running the database server.

Go to "Administrative Tools > Component Services"
On the left navigation tree, go to "Component Services > Computers > My Computer" Right click on "My Computer" and select "Properties"
Select "MSDTC" tab
Click "Security Configuration"
Make sure you check "Network DTC Access", "Allow Remote Client", "Allow Inbound/Outbound", "Enable TIP"
The service will restart
You may need to reboot your server if it still does not work.

On your client computer use the same procedure as above to open the "Security Configuration" setting. Then make sure you check "Network DTC Access", and "Allow Inbound/Outbound" options. Restart the service and the computer if necessary.

On you SQL Server Service Manager, click the "Service" dropdown, select "Distribute Transaction Coordinator". It should also be running on your server computer.

Regards,

Moderator

Firstly, you may try with the below connection string (uid instead of User Id) and then try the scenario.

server=pauyoupc3;database=ePC_06_04_00_25;uid=sa;pwd=xxx;

If that doesn't help and the same issue persists, then go for the below MSDTC check.

Go to "Administrative Tools > Services"
Turn on the "Distribute Transaction Coordinator" Service if it is not running.
If it is running and the client application is not on the same computer as the database server, carry out the following steps on the computer running the database server.

Go to "Administrative Tools > Component Services"
On the left navigation tree, go to "Component Services > Computers > My Computer"
Right click on "My Computer" and select "Properties"
Select "MSDTC" tab
Click "Security Configuration"
Make sure you check "Network DTC Access", "Allow Remote Client", "Allow Inbound/Outbound", "Enable TIP"
The service will restart
You may need to reboot your server if it still does not work.


On your client computer use the same procedure as above to open the "Security Configuration" setting. Then make sure you check "Network DTC Access", and "Allow Inbound/Outbound" options. Restart the service and the computer if necessary.

On you SQL Server Service Manager, click the "Service" dropdown, select "Distribute Transaction Coordinator". It should also be running on your server computer.

Thanks, Sri

I tried uid instead of User Id and it still didn't work.

Finally I tried to connect to a SQL Server 2005 database on another machine (the one I put the Skelta Repository on) - and that worked! 

I guess even the Forms/User Provider featuer does not support SQL Server 2000 (I knew BPM.NET 2007 itself required 2005.

.

regards,

Moderator

	Post Attachments
	TestConnection.txt (618 views, 24.00 KB)

server=pauyoupc3;database=ePC_06_04_00_25;uid=sa;pwd=xxxx;

Clicked all 3 Test buttons, and they all responded "Connection Success..."

I also tried:

Conn1: server=pauyoupc3;database=ePC_06_04_00_25;uid=sa;pwd=xxxx;

(Skelta Datasource) Conn2: server=dev;database=SkeltaEval1;uid=sa;pwd=xxxx;

Clicked all 3 buttons, and they all responded "Connection Success..."

(To recheck, I pasted the 1st database back into Central Config / User Provider / Datasource and and clicked "Test SQL Connection" and got back "Forms test failed - Invalid connection string. Please check MSDTC settings and check if Database User settings are valid. - Check logger console for more details"

(Also with the connection (same database contents as above):

server=dev;database=PAUYOU060401MSS;uid=sa;pwd=xxxx;

I can use Enterprise Console and logon as a user out of that database, add Queues, and assign users out of that database, so I assume the other configuration settings are correct.)

Hi,

Can you send the screen shot of MSDTC settings please?

Regards,

Bineesh

using System.Transactions;

SqlConnection sqlConn = new SqlConnection("server=pauyoupc3;database=ePC_06_04_00_25;uid=sa;pwd=xxxx;");
            try
            {
                System.Transactions.TransactionOptions to = new System.Transactions.TransactionOptions();
                to.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
                to.Timeout = TimeSpan.Zero;
                using (TransactionScope tscope = new TransactionScope(System.Transactions.TransactionScopeOption.Required, to))
                {
                    sqlConn.Open();
                    tscope.Complete();
                }
                }
            catch (Exception ex)
            {
                Response.Write(ex.Message + ((ex.InnerException == null) ? "" : "\r\n \r\nInnerException:" + ex.InnerException.Message));
            }
            finally
            {
                sqlConn.Close();
            }

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Transactions;

namespace TestASPX

{

public partial class Connect1 : System.Web.UI.Page

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection sqlConn = new SqlConnection("server=pauyoupc3;database=ePC_06_04_00_25;uid=sa;pwd=xxxx;");

Response.Write(@"Created Connection</BR>");

try

System.Transactions.TransactionOptions to = new System.Transactions.TransactionOptions();

to.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;

to.Timeout = TimeSpan.Zero;

using (TransactionScope tscope = new TransactionScope(System.Transactions.TransactionScopeOption.Required, to))

{

sqlConn.Open();

tscope.Complete();

Response.Write(@"Got to: tscope.Complete();</BR>");

}

}

catch (Exception ex)

{

Response.Write(ex.Message + ((ex.InnerException == null) ? "" : "\r\n \r\nInnerException:" + ex.InnerException.Message));

}

finally