Help Web And Configuration Sql

[NaelsonMT]

My site does not connect this in perfect installation by following the tutorials from the internet

What is the right way to set the sql server to connect to the database?

 

I think the problem I have in a week already and configuration of sql server

My configuration the web configuration

 

/* SQL Auth */

$CONFIG['address'] = "192.95.14.456";  

$CONFIG['dbuser'] = "lin2world"; 

$CONFIG['dbpass'] = "admin123";

 

:-\

 

Thank you

Edited October 17, 2015 by NaelsonMT

[NaelsonMT]

resolved by Myutsu 

painel internal !

does not work in external !

Edited October 24, 2015 by NaelsonMT

[GLO]

Be sure that you allowed access firstly.. Is it from remote or is it from the same Pc?

Check firewall roles, check if port 3306 is restricted or not.

Also i think you must have and a dbname...to get a specific database.

[tk422]

- Ensure that you have manually ENABLED remote connections to the SQL server in the SQL Server Configuration Manager. Please change the port to something non standard!!!

- Ensure that your connection string in the webshit specifies the correct database name. Some libraries will afix the default one while others will not. If you need help google <programming-language> mssql connection string example

- Forward the remote connection port in your firewall. Both on the server and on your network.

- Ensure that the port is open and something on the other end is listening using this online tool: http://www.yougetsignal.com/tools/open-ports/

Edited October 17, 2015 by tk422

[NaelsonMT]

Web hosted free + dedicated

 

Hosted web free door 3306 = is closed

 

Dedicated door 3306 and 9014 = os closed

 

summarized hosted web and dedicated not this open 3306 

 

The two need open the 3306?

 

I have to work I'll be back later

Edited October 17, 2015 by NaelsonMT

[Anarchy]

3306? you mean 1433.

 

port 1433 needs to be open on the server running sql and you will need TCP/IP enabled in the network configuration for your sql instance.

[NaelsonMT]

3306? you mean 1433.

 

port 1433 needs to be open on the server running sql and you will need TCP/IP enabled in the network configuration for your sql instance.

I read the rules and does not speak that is prohibited youtube

https://www.youtube.com/watch?v=j_iX2v8iHIE&feature=youtu.be

What have to do to operate the accounts

Edited October 21, 2015 by NaelsonMT