Hi Sergey,
I installed AMI "Bring Your Own License" Version on an EC2 Instance with an RDS MS SQLExpress 2012 DB. The Connection String fails when I try to install the DNNSoftware CMS ASP.Net application. Amazon Support engineers have looked it over and cannot find any problems with security or connectivity. I can create a DB on Amazon RDS using Plesk 12.0.18. I can connect from my desktop to the DB via MS SQL Management Studio. I found this article in Odin support and verified that SQL is configured to run with "NetworkService". (
http://kb.odin.com/en/124715)
Here are the iterations attemped to connectString:
using the RDS endpoint
<add key="SiteSqlServer" value="server=alto-db.vvvvvxxxxxxx.us-east-1.rds.amazonaws.com\SQLEXPRESS;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=alto-db.vvvvvxxxxxxx.us-east-1.rds.amazonaws.com;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=alto-db.vvvvvxxxxxxx.us-east-1.rds.amazonaws.com,1433;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=alto-db.vvvvvxxxxxxx.us-east-1.rds.amazonaws.com\MSSQLSERVER2012;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=alto-db.vvvvvxxxxxxx.us-east-1.rds.amazonaws.com\SQLEXPRESS2012;database=altodb;uid=alto_user;pwd=XXXX;" />
using IP:
<add key="SiteSqlServer" value="server=54.1.23.xxx;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=54.1.23.xxx,1433;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=54.1.23.xxx\SQLEXPRESS;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=54.1.23.xxxMSSQLSERVER2012;database=altodb;uid=alto_user;pwd=XXXX;" />
<add key="SiteSqlServer" value="server=54.1.23.xxx\SQLEXPRESS2012;database=altodb;uid=alto_user;pwd=XXXX;" />
The Control Suite indicates that this string is Valid: <add key="SiteSqlServer" value="server=54.1.23.xxx;database=altodb;uid=alto_user;pwd=XXXX;" />
The error returned when attempting to the run the App install scripts which build the DB tables is "db connection path format not supported"
Can you assist?