Login failed

[momk100]

Just refreshing this topic cause i got the login failed again.



here is the picture








and here is my r3dlog
--- Log started at Fri May 03 19:44:06 2013


000000.000| r3dFile: can't open game.ini
000000.000| Can't open file "game.ini"
000000.000| r3dFile: can't open local.ini
000000.000| Can't open file "local.ini"
000000.009| Input Devices enabled: Mouse, Keyboard
000000.062| VMEM As seen through DDRaw: 1006
000000.062| VMEM As seen through WMI: 0
000000.105| We have 737 MB texture memory
000000.105| r3dFont: Creating Verdana 10pt
000000.106| r3dFont: Finished creating Verdana 10pt
000000.106| r3dFont: Creating Tahoma 12pt
000000.106| r3dFont: Finished creating Tahoma 12pt
000000.107| r3dFont: Creating Tahoma 10pt
000000.107| r3dFont: Finished creating Tahoma 10pt
000000.107| r3dFont: Creating Tahoma 9pt
000000.107| r3dFont: Finished creating Tahoma 9pt
000000.430| Starting updater, v:0.9.3, cmd:
000000.431| Checking for new updater
000000.491| Checking for new updater - finished
000000.936| failed to get

You must be registered to see links

, http code 404
000003.298| WO_API: failed with error code 5 SQL Connect failed
000003.298| Login FAILED, code: 5
000009.704| Requested to stop, 0 files in queue
000009.704| CUpdater::Stop()

 

[ItsNobody]

your sql isnt connecting for some reason...u have a different code than me

 

[momk100]

how were you able to get your sql to connect because i follow DNC's community release video

 

[ItsNobody]

take api_getserverinfo.xml from warz/bin/build/updater and paste it into c:\\inetpub\wwwroot\

 

[momk100]

just in the wwwroot folder not in WarZ/api or wz/updater

 

[DNC]

wwwroot folder

 

[momk100]

alright once i did that it still doesnt work

 

[ItsNobody]

did you restart your IIS server to be sure?

 

[Sofiane2k6]

i had the same error and i fixed it go into your web.config and i modified this line connectionString="Server=Sofiane-PC\WarZ;

you have to pute your sql server name and remplace it normaly in this part it's written something like localhost i dont remember

and copy paste this in notepad and save him in c:inetpub.wwroot.WarZ and after this go in your web brower and type

You must be registered to see links

<?php
/*
Connect to the local server using Windows Authentication and specify
the AdventureWorks database as the database in use. To connect using
SQL Server Authentication, set values for the "UID" and "PWD"
attributes in the $connectionInfo parameter. For example:
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"AdventureWorks");
*/


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


$db_serverName = "Sofiane-PC\WarZ,1433";
$db_connectionInfo = array(
"UID" => $db_user,
"PWD" => $db_pass,
"Database" => $db_dbname,
"CharacterSet" => "UTF-8"
//"ReturnDatesAsStrings" => true
);
$conn = sqlsrv_connect($db_serverName, $db_connectionInfo);
if( $conn )
{
echo "Connection established.\n";
}
else
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}


//-----------------------------------------------
// Perform operations with connection.
//-----------------------------------------------


/* Close the connection. */
sqlsrv_close( $conn);
?>

 

[DNC]

cleaned thread. This is NOT WarZ don't post how they're down on this forum...

 

[momk100]

DNC this isnt for WarZ its for my WarZ server that im trying to make...

 

[DNC]

momk100 the post I deleted was of a community member stating that the "WarZ" Live website was down.....

 

[momk100]

oh alright sorry about that DNC it was a miscommunication i thought you were talking to me. But thanks for clearing it up.

Sofiane2k6 When i did that it gave me this error and i did change it in my web config.


Connection could not be load established. Array ([0] => Array ([0] => 28000 [SQLSTATE] => 28000 [1] => 18456

 => 18456 [2] => [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Login failed for user 'wz_api_user'. [message] => [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Login failed for user 'wz_api_user.') [1] => Array ([0] => 28000 [SQLSTATE] => 28000 [1] => 18456 [code] => 18456 [2] => [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Login failed for the Users 'wz_api_user'. [message] => [Microsoft] [SQL Server Native Client 11.0] [SQL Server] Login failed for user 'wz_api_user'.))[/COLOR][/B]

go some one help me out?