[HELP] AccountServer [ AccountDB Connect Failed

[obhy]

can anybody help me?
I've edited all the way there on this forum why always appear AccountDB Connect Failed when it was actually all the way that I follow ... no clue?

 

[ammandes]

check your odbc again

 

[obhy]

already sir but still will not connect to MSSQL

 

[likertuban]

run as administrator,
restart your computer,
then try to run as administrator again (i once encounter that problem, and can't solve it, but after restart, it's gone)
and do you see (restricted user) in RF_user?
use google how to remove restricted user :
maybe it'll help,
don't forget to restart computer after removing restricted user

 

[Ron]

Set your RF_User ODBC to Windows Authentication, as shown here,

Then run the AccountServer as Administrator. This will fix the problem.

 

[obhy]

thanks you sir problem is solved ^^ my ODBC is error... thanks..

sir i ask for you.. my register page no connect to MSSQL.. why ?
show pic

 

[Ron]

Make sure it is attempting to connect on the right port. MSSQL needs to be set to listen on port 1433 or 61433, and PHP needs to use that port for connections.

 

[obhy]

Failed to connect to MSSQL Server. again sir...
why ?
my edit 1433 and 61433

 

[Ron]

Failed to connect to MSSQL Server. again sir...
why ?
my edit 1433 and 61433

Please show us your config.php for this website.

~sent from my phone, please excuse my lazy typing and/or typos~

 

[obhy]

show image sir..
my config.php

 

[c3rb3ru588]

appserv?

hmmm this some your need add

RageZone - MSSQL Connect

 

[obhy]

appserv?

hmmm this some your need add

RageZone - MSSQL Connect

im not Appserv im use XAMP

 

[c3rb3ru588]

XAMPP is easy way. just active MMSQL connect and run

 

[obhy]

XAMPP is easy way. just active MMSQL connect and run

no connect to MSSQL sir i need help

 

[ammandes]

show image sir..
my config.php

for db host try to use name of your computer in mssql or odbc.
for db user try to use name of your computer in mssql or odbc
for db pass if you use windows auth,,set blank password

 

[obhy]

for db host try to use name of your computer in mssql or odbc.
for db user try to use name of your computer in mssql or odbc
for db pass if you use windows auth,,set blank password

so if you do not use a password for $ DB_User it in the blank? or his auth here too

indo : maksud nya di set gimana gan? ane masih gak begitu ngerti nih -_-

 

[ammandes]

yeah if you use win auth in your odbc so in your mssql you login use win auth.

#translate indo: kalo lu set di odbc nya windows auth pasti pas lu login di mssql nya conect nya k windows auth juga.brrti lu lsg login g perlu masukin ID: sa PW: homolu.
nah d script regis lu itu,,, kn ada data yg harus d isi..
prtma db host: cba isi ip lu,beserta port contoh 127.0.0.1,61433 atau nama konek win auth td misal. homopc/express
terus db user: cba lu isi nma pc homopc/express sebagai contoh atau masukin RF_User

terus buat pw: klo lu di odbc konek k win auth kosongin aja pw nya.
kecuali lu konek nya pke administrator di mssql yg pke login sa sma pw. baru lu set pw nya.....

 

[obhy]

yes i use you kronog... again sir.. Connect To MSSQL Failed

udah ane cobain bro tetep aja gak bisa nih...
ada ym atau messager gak biar ane tanya2 bro

 

[c3rb3ru588]

that not about config. this last i experience all type webserver is not much using MSSQL connection. need edit it

search php.ini in c:\\windows\

or the your xampp php.ini

Search Keyword "MSSQL"

this

; Compatibility mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

; Use NT authentication when connecting to the server
mssql.secure_connection = Off


Make it On

and look on like sample

D:\BlackDemon\PHP\ext(i config self)

maybe different just in PHP ext

Look there

is there exist this

php_mssql.dll

if no Download plugin your appserv

Note: i config my self using Apache, MSSQL, PHPMyadmin, And Zend Encrypted(because this my work as web programmer)

 

[pekanbarugamer]

in odbc i use sql server

try change mssql_connect to sqlsrv_connect
hope can be usefull,.,