can't connect to sql server

This topic is locked

can't connect to sql server	7/19/2007 7:42:29 PM
PHPRunner General questions
N ncea314mirror author i am using phprunner setup, and i put my correct user/pass with correct sql server and i get the error: sql error state:08001, native error code: 11, odbc error: [microsoft][odbc sql server driver][dbnetlib]sql server does not exist or access denied. i am using a remote sql server Database Version:2005, DSN:Not Installed, ASP Schema:Not Installed. what could be the cause?


J	Jane 7/20/2007
	Hi, verify that a SQL Server authentication login or a Windows NT authentication login exists in SQL Server for the Windows user account that IIS uses to access the ASP page. If a login does not exist, use the SQL Server Enterprise Manager to create it. Also, when creating an ODBC Data Source Name (DSN) in the ODBC Administrator, make sure to choose the appropriate authentication method when you configure the DSN, and to test the DSN in the ODBC Administrator to verify that it is working correctly. For information on how to configure SQL Server authentication or Windows NT authentication for SQL Server, please refer to the following Microsoft Knowledge Base articles: http://support.microsoft.com/default.aspx?...b;en-us;Q247931 http://blogs.msdn.com/sql_protocols/archiv.../29/486861.aspx