Solve error code 5 SQL Connect failed。【YouTube Video】

[ChuTszHin]

Hello everyone.


Solution SQL error code 5.


Sorry, my English is very bad. XD


I hope you can help as much as possible.


First Step:


Make sure before you install SQL 2008, has been uninstalled SQL 2005. (SQL 2005 system comes with.)


And the instance name is set up correctly. (In fact is not particularly important.)


You are ignoring the second step:


See my operation.


In fact you should be able to understand, find the network configuration.


Find the TCP / IP configuration.


Double-click it or right attributes.


Remember where two are YES.


In the TCP port (port remember not dynamic).


1433 written on each one.


Remember to finish the application.


Fill IPAll of dynamic ports: 1444,55363,34000,34001,34011,34010,81


Application


Back to SQL configuration, restart SQL, buttoned.


I hope to help you.


But I also encountered a problem.


I hope you can help me.


http://forum.ragezone.com/f792/oncre...nside-1008034/


Thank you.

- - - Updated - - -

Video is uploaded, transcoding, processing.


Click to enter YOUTUBE page to watch high-definition video.

- - - Updated - - -

@bankok01
@DJYAI
@阿尔曼Avetisyan
@yutabios

[MentaL]

[XxFuR4xX]

I will listen to your tutorial.

[DNC]

@ChuTszHin
I Stickied this thread to help keep it near the top of the Help Section.
Thank you for taking the time to create this thread.

[ChuTszHin]

@ChuTszHin
I Stickied this thread to help keep it near the top of the Help Section.
Thank you for taking the time to create this thread.

Thank you for your attention.


This is what I should do.


Like you also share and publish a Community Edition source code.


Sharing the spirit!

Forgive my bad English, I will try to improve.


I'm going to record a SQL error code on: Solving video 8.

[DNC]

Your English translations are very good.
I know how difficult it is to translate back and forth.

:0)

Keep up the great work. It is very appreciated.


你的英文翻译是非常好的。
我知道它是如何困难，翻译来回。

:0）

跟上伟大的工作。这是非常赞赏。

[XxFuR4xX]

Hello everyone.


Solution SQL error code 5.


Sorry, my English is very bad. XD


I hope you can help as much as possible.


First Step:


Make sure before you install SQL 2008, has been uninstalled SQL 2005. (SQL 2005 system comes with.)


And the instance name is set up correctly. (In fact is not particularly important.)


You are ignoring the second step:


See my operation.


In fact you should be able to understand, find the network configuration.


Find the TCP / IP configuration.


Double-click it or right attributes.


Remember where two are YES.


In the TCP port (port remember not dynamic).


1433 written on each one.


Remember to finish the application.


Fill IPAll of dynamic ports: 1444,55363,34000,34001,34011,34010,81


Application


Back to SQL configuration, restart SQL, buttoned.


I hope to help you.


But I also encountered a problem.


I hope you can help me.


http://forum.ragezone.com/f792/oncre...nside-1008034/


Thank you.

- - - Updated - - -

Video is uploaded, transcoding, processing.


Click to enter YOUTUBE page to watch high-definition video.

- - - Updated - - -

@bankok01
@DJYAI
@阿尔曼Avetisyan
@yutabios

My error is not resolved with your tutorial sir

[ChuTszHin]

Hello, regarding the SQL error code: 5 There are several factors occurs, you can check it.


1:


Your network environment LAN (YES: You have to set your local IP, NO:. 127.0.0.1 or you have to set your external network IP)


2:


Your www / api configuration file is not set up correctly, you need to set the file has two.


web.config

$ db_user = "wz_api_user"; 
$ db_pass = "123456"; 
$ db_dbname = "WarZ"; 


$ db_serverName = "localhost, 1433"; 
$ db_connectionInfo = array (
"UID" => $ db_user, 
"PWD" => $ db_pass, 
"Database" => $ db_dbname, 
"CharacterSet" => "UTF-8" 
/ / "ReturnDatesAsStrings" => true 
);

dbinfo.inc.php

     <add name="dbConnectionString" connectionString="Server=localhost,1433;Database=WarZ;User ID=wz_api_user;Password=123456;Trusted_Connection=False;" providerName="System.Data.SqlClient"/>

Need to pay attention to:


Account Settings API, you have to follow the DNC tutorial.


Password, and duank .

IIS's API conversion and setting process should pay attention to is correct.

[XxFuR4xX]

Hello, regarding the SQL error code: 5 There are several factors occurs, you can check it.


1:


Your network environment LAN (YES: You have to set your local IP, NO:. 127.0.0.1 or you have to set your external network IP)


2:


Your www / api configuration file is not set up correctly, you need to set the file has two.


web.config

$ db_user = "wz_api_user"; 
$ db_pass = "123456"; 
$ db_dbname = "WarZ"; 


$ db_serverName = "localhost, 1433"; 
$ db_connectionInfo = array (
"UID" => $ db_user, 
"PWD" => $ db_pass, 
"Database" => $ db_dbname, 
"CharacterSet" => "UTF-8" 
/ / "ReturnDatesAsStrings" => true 
);

dbinfo.inc.php

     <add name="dbConnectionString" connectionString="Server=localhost,1433;Database=WarZ;User ID=wz_api_user;Password=123456;Trusted_Connection=False;" providerName="System.Data.SqlClient"/>

Need to pay attention to:


Account Settings API, you have to follow the DNC tutorial.


Password, and duank .

IIS's API conversion and setting process should pay attention to is correct.

It's good I have all done correctly. But my mistake and again.

[ChuTszHin]

It's good I have all done correctly. But my mistake and again.

If so, I hope you can see your error log file.


Basically error code: 5 Reasons not particularly high. (Unless you are wrong a lot of steps)


So I'll give you suggestions:


1:


Determine their own networks environment. (127.0.0.1? Or 192.168.XXX.XXX or ADSL)


2:


The first generation solution, preferably using local IP for testing.


3:


According to DNC tutorial step, step by step instructions, including order.


4:


If you have a router, you remember the router to open the required port mapping.


5:


Completely shut down your firewall, it almost does not have any protective effect, and can lead to a variety of port blocking.


6:


Before you set up the game and ensure that the platform is to give a clean, a new operating system. (Because the old operating system has too many unknowns conflict.)


I hope to help you find some ideas, you are welcome to continue to raise your confusion.

[WALKINGDEAD]

Just helped me fix a problem that i had all day. thanks!

[Robison Vargas]

not work for me

[NikolaTesla]

can shut down listen ill?

[IMG][/IMG]