Hi team,
i have installed mysql sever 2008 in my windows server. but i am unable to install solidcp due to database not connected. while connecting the database i am getting error( Sql server does not exist or access denied)
Hello,
SolidCP does require MsSQL for its database.
Regards,
Trevor
Hi Trevor
I'm also getting the same error.
I have MsSQL2016 express installed
I follow your video, and remove the SQLexpress part.
I have setup the MsSQL in default, and opened port "TCP port 1433"
Can you maybe post us a video on the setup of the MsSQL server, for refrence.
Regards
Corne
Hi Rascalsnake,
Pls add SQLEXPRESS after localhost so the issue will be resolved.
SQL Server: localhostSQLEXPRESS
In some of the ways, spacing and the order of parameters in the MySql connection string does matters. So, stick to the standard format:
MysqlConn.ConnectionString = "Server=localhost;Port=1234;Database=My_Mysql_Database;Uid=root;Pwd=root;"
If the above connection string fails, try update your c# mysql connection string as shown below (without port variable as well):
MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"
Or, sometime the problem could be on your windows firewall, make sure your server allow access to all port associated with your mysql database.
