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, 201511 yr by NaelsonMT

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.

- 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, 201511 yr by tk422

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, 201511 yr by 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.

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, 201511 yr by NaelsonMT

resolved by Myutsu 

painel internal !

does not work in external !

Edited October 24, 201511 yr by NaelsonMT