Dotnetpanel Forums

Hi,

I just came across an issue / bug when performing installation of the ES component. When configuring the database properties, the error "unable to configure the database server" is generated and installation cannot proceed if the SQL server authentication details input by the user contain the ; character. Obviously not a massive problem, but I couldn't find any other references to this error so hopefully this post will help anyone else running into the same situation and it can be fixed for a future release.

Kind Regards

Lee

Hi Lee,

 I think  ; is an illegal character as it causes errors in the connection string. ; typically represents a full stop (period) so I am guessing that a password such as pass;word will only be read as pass.

 

Cheers,

Mark 

 

 

A fair assumption and it certainly appears to be the case that the ; is ending the recognised input as far as the setup is concerned (putting a ; at the end of an otherwise correct password for example has no effect), but ; is not an illegal character for SQL Server authentication details so DNP ES setup should be able to handle this properly really.

You are correct to a point. DNP is built on the .Net framework and as such the format for connecting to a database using any of the provided connectors is to seperate each item by a semi colon. So a properly formated connection string would be

server=blah;database=blahblah;uid=fred;password=flintstone;

As you can see, if you add a semicolon in the password it will truncate your password. I dont think there is anyway around this other than not using a semi colon in your password. This is not a DNP issue but a .Net issue. The only thing DNP could do it trap for a semi colon make you change it before going any further.

Jerel

I've actually been able to successfully use what would otherwise be an 'illegal' character in MS SQL by wrapping the password with single quotes. Therefore, the following should work...

server=blah;database=blahblah;uid=fred;password='flint;stone';

However, this will not work in DNP because DNP doesn't add the single quotes.

Hi Lee,

 If you don't want to change the password that DNP uses go to the web.config file in the Enterprise Server folder, find the following line and add single quotes around the password...

<connectionStrings>
    <add name="EnterpriseServer" connectionString="server=localhost;database=DotNetPanelEnterpriseServer;uid=[username];pwd='pass;word';" providerName="System.Data.SqlClient" />
  </connectionStrings>

 Felix