Ask PHP to connect to the SQL server!

rayallan

$ connect = mssql_pconnect ("", "sa", "haha");
 mssql_select_db ("UserInfo", $ connect);

 $ query = "select * from UserInfo";
 $ result = mssql_query ($ query);
 $ rows = @mssql_num_rows ($ result);
 

 for ($ i = 0; $ i <$ rows; $ i ++) {
 @mssql_data_seek ($ result, $ i);
 $ data = @mssql_fetch_array ($ result);
echo "$ data [id] $ data [username] $ data [name]";
    
 }
 
 mssql_close ($ connect);



The code is as above, the data cannot be displayed using SQL authentication mode!
If you comment out the first line, the code runs normally. I guess php is connected using the windows login mode of sql server, but in actual applications, it should be connected using sql authentication mode.
Please friends who have experience in this area help!

ccc060

Modify the authentication method of MSSQL Server, and support both Windows authentication and SQL Server authentication.
Is ready to be modified using Enterprise Manager

rayallan

Sorry, the first line should be: $ connect = mssql_pconnect ("servername", "sa", "haha");

Please help, hurry ~~

迪迪安

The problem with the host address, right? Fill in 127.0.0.1 and try?