473,396 Members | 2,020 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,396 software developers and data experts.

unable to connect with mssql_connect()

hii all

i am using php 5 and a warning has occured in my application

"
Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'PAYDATA'. (severity 14) in C:\WINNT\Temp\tmpqjqokj.php on line 7

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 10.23.80.6 in C:\WINNT\Temp\tmpqjqokj.php on line 7"


any suggestions??

regards

Aryan
Sep 13 '07 #1
4 20231
ak1dnar
1,584 Expert 1GB
Check the user name and password again.

Thread title [login failed...need help] changed. Do not use "need help" with your thread titles.
Sep 13 '07 #2
webandwe
142 100+
I found that usally the DB or the server host is incorrect.

Find out from your hosting company what the details must be?

Example of DB

1.yourdomain_com_-_yourdb
2.yourdb

And your serverhost

1.localhost
2 292.282.29
3. nk1.222.ns.host

Hope you come right.

Regards
Sep 13 '07 #3
thank you guys.. that problem is solved. but now i am getting a new warning in different link...


Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'CRB'. Reason: Not associated with a trusted SQL Server connection. (severity 14) in C:\WINNT\Temp\tmpuaobbb.php on line 155


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: HARDWARE in C:\WINNT\Temp\tmpuaobbb.php on line 155
Unable to make connection with server HARDWARE

mssql.secure_connection is off in ini file....


any ideas???


regards
aryan
Sep 14 '07 #4
ak1dnar
1,584 Expert 1GB
The default way to connect to MSSQL Server with user names and passwords, but the mssql extension can be configured to use secure/trusted
connections. So you have to set mssql.secure_connection = On in
php.ini. and restart the machine before execute the script. Thanks!
Sep 14 '07 #5

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

Similar topics

4
by: Biffo | last post by:
I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the webserver. All is working well, except I get a - Fatal error: Call to undefined function mssql_connect() in...
1
by: EricP | last post by:
Hello, First, sorry for my bad English. Here is my problem: BoxA: XPpro + Apache + php (using php_mssql.php)+ ADOdb + MS SQL Server + My_Prog (using local MS SQL PUBS database) BoxB: NT4...
2
by: alasdair.watson | last post by:
PHP 4.3/MS-SQL7/IIS5. At the start of every script, I include db.php which contains this: <? $db = mssql_connect('devbox','foo','bar'); mssql_select_db('', $db) or die ("Couldn't open database...
13
by: printline | last post by:
Hello I have problems connecting to my MSSQL through php. I have a microsoft windows server 2003, web edition with php5 installed and Microsoft SQL Server: SQL Server 2005 Express Edition as my...
3
by: Matt White | last post by:
Hello, Is there any way to connect to SQL Server without using mssql_connect? The installation of PHP I'm using was not compiled with the MSSQL extensions. Thanks.
0
by: dreamer247 | last post by:
hii all i am working with mssql 2000 and after restoring a databas from device the warning is .. Warning: mssql_connect() : message: Cannot open user default database. Using master database...
1
by: dreaken667 | last post by:
I've dealt with issues with not being able to connect to the database through PHP and know how to correct most of them fairly easily, however, I've got a really odd situation here. I'm running PHP...
2
by: yashiro | last post by:
Hello , i am moving my server (php,apache (wamp 2c)) to a new machine. while executing my php file ,i get the warning : Warning : mssql_connect() : unable to connect to server ..... i dont...
2
by: mirali00 | last post by:
Hello, This is a strange one! I'm getting blank results for mssql_connect. I created a simple testmssql.php page with the following code: <?php if (function_exists('mssql_connect')) {...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.