Mucore Problem?

[CrypticVicious]

This problem is getting very annoying for i don't know if its my sql or not. But its getting very annoying.

On the second step it always fails to connect to my database. No matter what i have done.


Im using zteam s8 e2 files and using sql 2008 r2

 
/*-------------------------------------*\| MUCore SQL Connection Type:           |
|                                       |
|  MSSQL : Connect using mssql_conect() |
|  ODBC : Connect using odbc            |
\*-------------------------------------*/


$core['connection_type'] = "ODBC";


#########################################








/*--------------------------------------------------*\
| MuOnline Database Connection Settings              |
|                                                    |
| $core['db_host'] : Database host address           |
| $core['db_name'] : Database name                   |
| $core['db_use'] : SQL Authentication user          |
| $core['db_password'] : SQL Authentication password |
\*--------------------------------------------------*/


$core['db_host'] = "CHAOS-PC\SQLEXPRESS";
       
$core['db_name'] = "MuOnline";    
     
$core['db_user']= "sa";


$core['db_password'] = "SQL-Pass";


######################################################

And yes before you ask. I have changed ODBC to MSSQL.

and yes i edit the sql password before you say that.

I done all that. But i always get failed to connect to database.

I used xampp 1.7.1 and xampp 1.7.7 i get both same errors on xampp 1.7.7 when i run debug and it says missing extension for mssql.

on xampp 1.71 it says failed to connect to sa if anyone can help that would be nice.

Yes i have turn my firewall off and allowed port 1433 as well.

I have notice my mumaker dont work either it gives me a error as well: Named Pipes Provider Errors :40 Could Not Open A Connection To Sql Server...

Thanks To Anyone Who Helps,

[MentaL]

[ScriptKid]

and what OS are you using?

[CrypticVicious]

Windows 7.

- - - Updated - - -

Problem has been fixed Thanks. it was my sql server kinda figure it was. I changed it from MSSQL back to ODBC and fixed it.

[Soumyxorp]

Happens to me all the time idk if this would work for you, but works for me:
So just search up any random ntwdblib.dll from google then replace it. Also use MSSQL on your config.php instead of odbc if you use this method. Only for xampp/site sql connection, idk about MuMaker.

From: https://community.apachefriends.org/...934408db43b2b3

If the mssql extension was loaded in the php.ini, sometimes it comes to access problems when only TCP/IP is used. You can fix that problem with a newer "ntwdblib.dll" from Microsoft. Please replace the older file in "\xampp\apache\bin" and "\xampp\php" with the new one. Because of the license, we can't package a newer version of this file with XAMPP.

[CrypticVicious]

I fixed both mate. It just took some time and research. It annoyed me but i found out the solution. Open SQL Server Configuration Manager
SQL Server Network Configuration>
Enable TCP/IP>
Right Click TCP/IP Go To Properties
Go To IP Addresses.
Everything that says Enabled No Make It Yes
and put all Blank TCP Port to 1433.

it worked for me :))