not able to connect...
 
Notifications
Clear all

not able to connect mysql server while installing the solidcp

5 Posts
4 Users
0 Likes
882 Views
Prabhu
Posts: 3
Topic starter
(@prabhu)
New Member
Joined: 2 years ago

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)

4 Replies
Trevor Robinson
Posts: 1444
Admin
(@trobinson)
Noble Member
Joined: 7 years ago

Hello,

SolidCP does require MsSQL for its database.

Regards,

Trevor

Reply
RascalSnake
Posts: 1
(@rascalsnake)
New Member
Joined: 2 years ago

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

Reply
Prabhu
Posts: 3
Topic starter
(@prabhu)
New Member
Joined: 2 years ago

Hi Rascalsnake,

Pls add SQLEXPRESS after localhost so the issue will be resolved.

SQL Server:  localhostSQLEXPRESS

Reply
cristydavidd
Posts: 1
Customer
(@cristydavidd)
New Member
Joined: 3 weeks ago

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.

Reply
Share: