API Issue WO_5SQL Connect failed

Hello,

I'm trying to get the API to connect to MSSQL and I'm having issues. I can connect through SQL Server Management Studio fine but through ASP.NET on IIS it just will not connect.

Code:

---

public class SQLBase
{
    string server = @".\WARZ,1433";
    string user = "TheWarZ";
    string pass = "removedpass";
    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 = "frtV4zAqo";
        }
        else*/
        {
            server = @".\WARZ,1433";
            user = "TheWarZ";
            pass = "removedpass";
        }
    }

---

Anyone have any idea why I'm getting "WO_5SQL Connect failed"

Fixed. If anyone gets the same issue then leave "public class SQLBase" as this:

Code:

---


public class SQLBase {    string server = "";    string user = "";    string pass = "";    string workdb = "WarZ";

---

WO_5SQLConnectfailed fixed now i get "WO_5no parameter username" but i can connect with dashborad all is fine

LG

WO_5no parameter username is just because the parameters for the api haven't been given someone can correct me if i'm wrong

Quote:

---

Originally Posted by limodor

WO_5SQLConnectfailed fixed now i get "WO_5no parameter username" but i can connect with dashborad all is fine

LG

---

The fix for u is:

Code:

---

username=[USERNAME HERE]&password=[PASSWORD HERE]&serial=[SERIAL HERE]&email=[EMAIL HERE] Remove the []

---

Put that behind the api link

Quote:

---

Originally Posted by Xangu

The fix for u is:

Code:

---

username=[USERNAME HERE]&password=[PASSWORD HERE]&serial=[SERIAL HERE]&email=[EMAIL HERE] Remove the []

---

Put that behind the api link

---

When I do that I get this WO_5SQL Select Failed: Could not find stored procedure 'WZ_ACCOUNT_CREATE'. is they anyway you can help as it is been annoying me for a while

You have a problem with your database , the procedure is missing ?

I think so but my sql compare won't compile because of an error so i used the sql's from the FAQ and that fails also i have the error from the MSSMS if that is helpful?

Quote:

---

Originally Posted by Dreamzy

I think so but my sql compare won't compile because of an error so i used the sql's from the FAQ and that fails also i have the error from the MSSMS if that is helpful?

---

i had the same error as you , because i was connecting to Sql server 2005 instances insteed of 2008 one.

How did you fix your error?

i used the 2008 instance.
for 2005 it was : SQLEXPRESS
for 2008 it was : MSSQLEXPRESS (i set it up like that when installing sql server 2008)

Ahh kk so i will have to reset it by reinstalling?