Configuring Plastic with SQL Server 2005

[tom.peters]

Howdy -

I have used this link as a reference for configuring Plastic 3 with SQL Server 2005: http://codicesoftware.blogspot.com/2008/08/configure-sql-server-database-backend.html

I must be missing a setting or something because I cannot get Plastic to use my DB. Here's what I did:

1. Created SQL Server DB, PlasticTest, on my LOCAL server

2. Added logon/user for read/write on PlasticTest

3. Tested credentials

4. Create C:\PlasticSCM\server\db.conf with the following:

<DbConfig>

<ProviderName>

sqlserver

</ProviderName>

<ConnectionString>

SERVER=xxx-xxx-xxxxxxx\CI;User Id=xx;Pwd=xx;DATABASE={0};

</ConnectionString>

</DbConfig>

NOTE: I also tried this with DATABASE=PlasticTest

NOTE: I am not allowed to list our server info... don't worry, I am not using X in my real file.

5. Restarted the Plastic service

6. Started Server Configuration Wizard... still shows Firebird stuff

7. Restarted the Plastic service

8. started the client... went to Firebird.

Any assistance would be appreciated.

Thanks,

Tom

[psantosl]

Hi Tom,

Sorry for the delay.

Plastic will create *a new* database upon start up, in fact a couple of them.

Please double check the db.conf format. I'm afraid it's not correctly formated or something. I see you've things in two lines instead of one. Can you double check?

pablo

[tom.peters]

I found the following error in the loader.log

2010-11-08 12:04:37,596 6548 (null) (null) (null) ERROR Codice.CM.Data.ConnectionConfig - Error reading config file C:\Program Files\PlasticSCM\server\db.conf. [There is an error in XML document (6, 6).]

2010-11-08 12:04:39,299 6548 EVERY_USER_OR_GROUP e5ba4f70-bb38-418e-875e-95f3a6eb47c1 Server:SIS-ARM-TPETER4 INFO Transaction - Transaction timeout -> 120000ms

Here is my db.conf

<DbConfig>

<ProviderName>

sqlserver

</ProviderName>

<ConnectionString>

SERVER=SIS-ARM-TPETER4\CI;Trusted_Connection=True;Database={0};

</ConnectionString>

</DbConfig>

Do you see anything wrong with the XML? I am all setup for Windows Authentication on this SQL server instance.

[miller]

HI Tom,

Your connection string does not correct:

<ConnectionString>

SERVER=SIS-ARM-TPETER4\CI;Trusted_Connection=True;Database={0};

</ConnectionString>

server= has an \CI ?? Is this your server name "SIS-ARM-TPETER4\CI" ?

try:

<DbConfig>

<ProviderName>sqlserver</ProviderName>

<ConnectionString>SERVER=SIS-ARM-TPETER4;Trusted_Connection=True;Database={0};Connect Timeout=50</ConnectionString>

</DbConfig>

If the above does not help, put the IP of the server instead of the hostname, and try again.

Miller

[tom.peters]

Hi Miller -

CI is the SQL Server instance. We always have CS (case-sensitive) versus CI (case-insensitive). I used the following and it worked!!!!

<DbConfig>

<ProviderName>sqlserver</ProviderName>

<ConnectionString>SERVER=SIS-ARM-TPETER4\CI;Trusted_Connection=True;Database={0};Connect Timeout=50</ConnectionString>

</DbConfig>

I had copied the XML from http://codicesoftware.blogspot.com/2008/08/configure-sql-server-database-backend.html and I guess it was the line wrapping and/or the missing timeout parm.

Well, whatever is was, it works now and this great. Thank you very much!!!

Tom