Register for your free account! | Forgot your password?

You last visited: Today at 03:19

  • Please register to post and access all features, it's quick, easy and FREE!

 

Problem with sql

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
Problem with sql

Hi guys , i have been installed slq 2012 and i use appserv to my register page, but safety policy of the SQL does not allow apache to connect to the database, the setting in the conf.php file is correct, since I created a new User, put the permissions still access SQL blocks.



8holyavenger8 is offline  
Old   #2
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
may be u have some closed ports?
check 1433 port


Vake24 is offline  
Old   #3
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
i need put port 1433
8holyavenger8 is offline  
Old   #4
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
U use apache on your computer? if yes u dont must open ports check apache configs or use hosting^^


Vake24 is offline  
Old   #5
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
i use appserv and he use port 8090
8holyavenger8 is offline  
Old   #6
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
u have screens with problem?
Vake24 is offline  
Old   #7
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
Warning: mssql_select_db() [function.mssql-select-db]: message: A entidade de seguran�a de servidor "AUTORIDADE NT\SISTEMA" n�o pode acessar o banco de dados "auth" no contexto de seguran�a atual. (severity 14) in C:\AppServ\www\register\index.php on line 27

Warning: mssql_select_db() [function.mssql-select-db]: Unable to select database: auth in C:\AppServ\www\register\index.php on line 27
Couldn't open database auth

Don't use special char in your password or username, it will be deleted by our internal security system
8holyavenger8 is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
i cant read first part of error

check index.php on line 27
it error with database select
Vake24 is offline  
Old   #9
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
Warning: mssql_select_db () [function.mssql-select-db]: message: The server principal "NT AUTHORITY \ SYSTEM" can not access the database "auth" in the current security context. (severity 14) in C: \ AppServ \ www \ register \ index.php on line 27

1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2<html xmlns="http://www.w3.org/1999/xhtml">
3 <head>
4 <title>Arcadia Test Server</title>
5<?php
6require("conf.php");
7if ($registration ==0){
8?>
9 <h1>Registrations closed</h1>
10 </div>
11 </div>
12<?php
13exit;
14}
15if(isset($_SERVER['HTTP_REFERER'])
16 && $_SERVER['HTTP_REFERER']!=''
17 && substr($_SERVER['HTTP_REFERER'], 7, strlen($_SERVER['SERVER_NAME'])) != $_SERVER['SERVER_NAME'])
18 {
19 $_POST = array();
20 $_GET = array();
21 }
22function connect(){
23 require("conf.php");
24 $db = $Auth_db;
25 $connect = mssql_connect($sql_host, $sql_user, $sql_password);
26 if (!$connect) {echo 'connection error'; exit;}
27 mssql_select_db($db, $connect) or die("Couldn't open database $db");
28 return $connect;
}
$do = $_POST['do'];
switch($do){




and my other archive

<?php
$sql_host="LEONARDO-TI\SQLEXPRESS"; // It can be : localhost\sqlexpress
$sql_user="sa";
$sql_password="";
$Auth_db="auth";
$md5_key="2011";
$registration = "1";
$max_accounts = "50";
?>
8holyavenger8 is offline  
Old   #10
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
try to change
$sql_host="LEONARDO-TI\SQLEXPRESS"; // It can be : localhost\sqlexpress
to
$sql_host="localhost"; // It can be : localhost\sqlexpress

i know 10% php i think that here missed SQL_port in config and script ^^ but i dont sure 100%
Vake24 is offline  
Old   #11
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
not work,
I believe that SQL has security policy, ie, it authenticates the server, but not allow the database seje modivicado AUTH not due to some blockage in the User SA or NT Authority \ System.
8holyavenger8 is offline  
Old   #12
 
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
HMM i Try to find fix and help u with u problem but it can take 1-3 days
Vake24 is offline  
Old   #13
 
elite*gold: 0
Join Date: Jun 2011
Posts: 26
Received Thanks: 4
not work.
I believe that SQL has security policy, ie, it authenticates the server, but not allow the database seje modivicado AUTH not due to some blockage in the User SA or NT Authority \ System.

ok ty


8holyavenger8 is offline  
Reply

Tags
problem, sql



« Previous Thread | Next Thread »

Similar Threads
[Problem]Habe ein Problem und zwar spinnt mein VPC etwas(ohne Grund)?!
Also wie schon gesagt meins Server spinnt wodurch kiks usw. kommen :( ich lade euch die Screens in den Anhang, mit der Hoffnung, dass ihr mir helfen...
10 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 03:19.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.