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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
kal3003 Posted March 25, 2007 Share Posted March 25, 2007 i mean 'CHAUDHRY\SUPER$' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.