omersarfraz Posted February 19, 2007 Share Posted February 19, 2007 Hiii All I have some problem to create a connection between PHP and SQL Server. I am using SQL Server 2000 installed in Windows Authentication Mode. And i am tryting to connect with ODBC of name "data". Code is this : <?php $server='data'; $username='root'; $password=''; $sqlconnect=odbc_connect($server,$username,$password); ?> In Windows Authentication Mode, there are not user and passwords. So i am using root as default user. When I run this, the following error come : Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver] Login failed for user 'CHAUDHRY\SUPER$'., SQL state 28000 in SQLConnect in C:\wamp\www\test.php on line 8[/i] Please Help me how to resolve this problem. Link to comment https://forums.phpfreaks.com/topic/39147-how-to-connect-php-with-ms-sql-server/ Share on other sites More sharing options...
kal3003 Posted March 25, 2007 Share Posted March 25, 2007 add that user to MSSQL users security -> users Link to comment https://forums.phpfreaks.com/topic/39147-how-to-connect-php-with-ms-sql-server/#findComment-214686 Share on other sites More sharing options...
kal3003 Posted March 25, 2007 Share Posted March 25, 2007 i mean 'CHAUDHRY\SUPER$' Link to comment https://forums.phpfreaks.com/topic/39147-how-to-connect-php-with-ms-sql-server/#findComment-214687 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.