ارتباط بين SQL Server 2000 & ASP.NET

[mehrdotcom]

سلام !
سعي ميكنم جزئيات كارهائي رو كه انجام دادم بصورت خلاصه بنويسم.
اول اينكه Control Panel هاست من HELM هست ! در قسمت Virtual Directory يك Dir درست كردم و مسير فيزيكي Application ASP.NET خودم رو براش تعريف كردم . webform هائي كه ازConnectionString استفاده نمي كنند به راحتي باز ميشوند. اما وب فرمهائي كه از ConStr استفاده ميكنند با پيعام خطاي Login Faild for user متوقف ميشوند . البته بايد اينو بگم كه DataBase من Sql هست و در قسمت Tables Permission كليه عبارات رو تيك زدم و در قسمت Constr براي وصل شدن User id= و Password خودم رو هم كه در Sql تعريف كردم وارد كردم . اما كار نميكنه !
و ضمنا" وقتي از localHost اون پروژه اجرا ميكنم به Sql Server در Host وصل ميشه و اطلاعات رو درست مي ياره !

متشكرم .

 

[chophe]

Login failed for user <user>
This error can take a variety of forms, including:

"Login failed for user '(null)'"
"Login failed for user domain\username"
"Login failed for user computer\ASPNET"
The likely cause is that you are working with a Web application and are trying to access a SQL Server. The specific error or exception that is thrown depends on whether the SQL Server is on the same computer as the Web server or on a separate computer. This problem arises because the Web application is not passing proper credentials to the SQL Server. In general, the solution is to:

If the SQL Server is on the same computer as the Web server, give the local ASPNET user login privileges on the SQL Server.
Set IIS or ASP.NET to impersonate a Windows domain user who has login privileges on the SQL Server.
Use a connection string with an explicit user ID and password.
For more information, see Accessing SQL Server from a Web Application.

Note The solutions to this problem can introduce security exposure on your Web server computer. For more information, see Access Permissions for Web Applications.
See Also
Database Security