bplogan

Hi there, thanks for reply, I tried what you suggested and get the following error: Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' code: <?php $host='IASSQLDEV'; /* The host/ip of your MSSQL server */ $dbuser='user'; /* The SQL DB user you setup in Management Studio */ $dbpasswd='password'; /* The password associated with the new SQL user */ $db = mssql_connect ($host,$dbusername,$dbpassword) or die("Error connecting to database");; // Attempt to connect to ?>

Thanks for the reply. So I am going to create the user and pass on the MSSQL server. Then should I change the NT Authentication in the php.ini file back to off?

Hello, I am new to php and MSSQL. I have php 5 running on a windows 2000 box. I added a DSN to the SQL server database I am trying to connect to using admin tools and Data sources in control panel. Now I'm not sure how to connect to the database via php. I found the following code using odbc_connect $dsn="issueTracker"; $username=""; $password=""; $sqlconnect=odbc_connect($dsn,$username,$password); $sqlquery="SELECT * FROM status;"; $process=odbc_exec($sqlconnect, $sqlquery); I am not entering anything for username and password as I setup the DSN using NT Authentication. I did set mssql.secure_connection = on in the php.ini file. I get the following error on the page: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver] Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'., SQL state 28000 in SQLConnect Any help would be awesome!

Ya, windows does suck, lol. I wish I could get them to switch.....I can't thank you all enough for the ideas, I will explore them all and get back to you. Again, thanks for geting me started.

Sorry, should have posted this elsewhere......

I have been assigned a project to create a page that displays the last reboot times of our company servers. All servers are running MS Server 2003. I found a way using ASP.NET but I hate ASP.NET with a passion. Does anyone know of a way to use PHP or javascript to accomplish this? Or does anyone have a different approach? I think I may have to bite the bullet and use ASP, but hopefully someone can suggest something different. Thanks.