API Error.

WO_5SQL Connect failed

I Added all the users to database and configured SQL_Base.cs and dbinfo.inc.php

that doesn't help at all.. say what you've changed.. look through the SQL_Base.cs..

Code:

---

using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Web;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Configuration;

/// <summary>
/// Summary description for SQLBase
/// </summary>
public class SQLBase
{
    string server = "127.0.0.1,11433";
    string user = "wz_api_user";
    string pass = "r3n3gad3";
    string workdb = "warZ";

    SqlConnection conn_ = null;

    public SQLBase()
    {
        /*
        if (ConfigurationManager.AppSettings.Get("WO_Region") == "RU")
        {
            server = "localhost,11433";
            //server = "rudb1.thewarinc.com,11433";
            user = "WOAdmin";
            pass = "r3n3gad3";
        }
        else*/
        {
            server = "127.0.0.1,11433";
            user = "wz_api_user";
            pass = "r3n3gad3";

---

Thats all i changed in sqlbase

Is your MSSQL Server running on port 11433 or 1433?

Default is 1433

Port set at 1433 still doesnt connect with either port im not sure i have all database settings right in it lol

same here

what MSSQL do you use?

try instead of 127.0.0.1:
localhost
localhost\\SQLEXPRESS

Quote:

---

Originally Posted by GigaToni

what MSSQL do you use?

try instead of 127.0.0.1:
localhost
localhost\\SQLEXPRESS

---

Microsoft SQL Server 2008 is what im using.

Trying localhost or localhost\\SQLEXPRESS at this minute will edit post.

EDIT: Still getting WO_5SQL Connect failed with localhost\\SQLEXPRESS and localhost.

is the MSSQL Server running on the same machine as the server??

Quote:

---

Originally Posted by GigaToni

is the MSSQL Server running on the same machine as the server??

---

Yep same machine

Open up cmd and type 'netstat -an' and tell me if you have any TCP ports listening on port 11433 or 1433

Quote:

---

Originally Posted by minusZero

Open up cmd and type 'netstat -an' and tell me if you have any TCP ports listening on port 11433 or 1433

---

No i do not have a TCP 1433 or 11433

Try that:
look in Services -> SQL Server and start the service if not already running

http://i.minus.com/iZKfNOGPXoXbG.png

http://i.minus.com/iyCTb03izSAyH.png

Now check to see if the ports are listening.

http://img803.imageshack.us/img803/2...42cb002769.png

This is what i get now.. is this right?