Trying to debug a connection issue

  • Thread starter Thread starter Clint
  • Start date Start date
C

Clint

I'm getting an "Unknown connection option: user" error when trying to

The connection string block in the dataConfiguration.config file looks like:

<instances>
<instance name="Instance1" type="Sql Server"
connectionString="Connect_String1" />
</instances>
<connectionStrings>
<connectionString name="Connect_String1">
<parameters>
<parameter name="database" value="databasename"
isSensitive="false" />
<parameter name="user" value="xxx" isSensitive="false" />
<parameter name="password" value="yyy" isSensitive="false" />
<parameter name="server" value="server.domain.com"
isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>



The code that causes the error is:

db = DatabaseFactory.CreateDatabase("Instance1");

A weird thing is that this (code and config file) appear to work fine from
my development machine, but fails on the server hosting the webservice. If
I point my consuming application to the server, it fails with the same
error, but I can't debug it there. Any pointers on debugging this would be
appreciated.
 
The only problem I can see with this theory is that my development machine
is outside of their domain, and my login isn't part of their domain
(although I have a domain user for VPN access, but that user doesn't have
SQL access). And from my machine, I can hit their database just fine.

I'm getting the site to change that line anyway, just for kicks.
 
You rock, dude! (or dudette, no offense intended) Changing that line
worked! I still don't understand why it works on my web service talking to
their database server, but what the heck.

Thanks again, and tell your boss you deserve a raise.
 
Back
Top