Jump to content
  • 0

Web And Configuration Sql


Question

Posted (edited)

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 by NaelsonMT

6 answers to this question

Recommended Posts

  • 0
Posted

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.

  • 0
Posted (edited)

- 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 by tk422
  • 0
Posted (edited)

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 by NaelsonMT
  • 0
Posted

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.

  • 0
Posted (edited)

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 by NaelsonMT

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock