473,320 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem connect with SQL SERVER database

I am running a WinXP Pro w/ SP2 (my home computer)
Apache 2.2.11
MySQL 5.1.33
PHP 5.2.9

I have to connect a remote MSSQL database

IIS
MS SQL Sever 2005
I am getting error
Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (severity 14)


- I have ntwdblib.dll in my c:\apache2\bin &
c:\php folders (year 2000 version)


- I have extension=php_mssql.dll in my php.ini

- when I run:
Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3. $host="mssql2.alpha.aussiehq.net.au";
  4. $user="user";
  5. $password="password";
  6.  
  7. mssql_connect($host,$user,$password) or die ("could not connect to
  8. server"); // <-------- It always dies here. :(
  9.  
  10. mssql_select_db("trtrades") or die ("could not connect to DB");
  11.  
  12. ....
  13.  
  14.  
  15. ?>
in php.ini file i set
Expand|Select|Wrap|Line Numbers
  1. mssql.allow_persistent = On
  2. mssql.max_persistent = -1
  3. mssql.max_links = -1
  4. mssql.min_error_severity = 10
  5. mssql.min_message_severity = 10
  6. mssql.compatability_mode = On
  7. ;mssql.connect_timeout = 5
  8. ;mssql.timeout = 60
  9. ;mssql.textlimit = 4096
  10. ;mssql.textsize = 4096
  11. ;mssql.batchsize = 0
  12. ;mssql.datetimeconvert = On
  13. mssql.secure_connection = Off
  14. mssql.max_procs = 25
I know that the $host, $user, and $password are right because I can
connect to the remote DB with the client tools.

Please help me.
Jul 27 '11 #1
1 2113
code green
1,726 Expert 1GB
It looks OK, although which ntwdblib.dll do you have?
version 2000.2.8.0 does not work on server 2005.
You need version 2000.80.194.0.

Maybe it is your DNS, try the ip address rather than domain name 123.45.678.90
Jul 27 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Alex Hardin | last post by:
Hey, I'm trying to use the connect to database wizard to connect to a MySQL database on my web server, 66.235.193.45 (I'm actually not sure if that points specifically to my part of the server, if...
2
by: James | last post by:
Hello I am new to ASP and I am using ASP.Net Visual Web Developer Express Edition. I have been following 'How To' videos online and I am currently trying to add Login forms. When I first go...
1
by: johnlim20088 | last post by:
Hi, Hi, currently I have a timer window application and web application (Visual Studio 2005) which is connect to database (SQL Server 2005). How I connect to database>? I am using Visual...
1
by: ZZ_Scarab | last post by:
Hi, <I posted this on the microsoft.public.dotnet.framework.aspnet.security newsgroup but before I got a reply this newsgroup has become unavailable!! So I'm posting it here again. Sorry for the...
2
by: jeffhan | last post by:
we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect...
4
by: =?Utf-8?B?RGF2ZQ==?= | last post by:
This is kind of a cross forum problem. I am trying to Connect to database by clicking on: Tools Connect To Database Select: Microsoft SQL Server (SqlClient). However, there are no server listed...
1
by: TLS | last post by:
How can i connect database which is hosted in server(Oracle 10g XE) from my client machine(in my client m/c dont have Oracle 10g XE - i using oracle SQL Developer for accessing Server DB) I tried...
0
by: binitarana | last post by:
I have a problem with .net application. We have an application created in VB.Net. It's a client server application. The database is SQL Server 2000. 5-6 clinet machine are accessing the server....
2
by: Wendi Turner | last post by:
ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005 --------------------------------------------------------------------------------------------------- I have successfully created a...
0
by: kurakar | last post by:
Dear all, How to connect SQL Database from Server 2005 through dyndns in php, My dyndns address - xxx-xxx.dyndns.org Port - 3389(default) This is the code i am using: $dsn =...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.