I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007
Then I having a custom page where store the data into SQL Server Database.
below is how my connectionstring look like:
<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>
however I hit error when browse to the custom page by the users.
Cannot open database "XXX" requested by the login. The login failed.
Login failed for user 'xx\user1'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
It was fine if I login as System Account.
Can anyone help me in this? thank you in advance.
View Complete Post