Today, I created a new project and wrote a simple page. The following error occurs:
The requested Database "albums" cannot be opened ". Logon Failed.
User 'nt Authority \ system' Login Failed.
After turning over the Internet for a long time, I finally found a solution:
Under the "albums" database-> Security> User> right-click (New User)> Login Name (select 'nt Authority \ system')> then select the corresponding role member (pay attention to permissions), OK, and OK. OK.
Note that you must add user ing under "Database"> "Login Name" to the user by right-clicking on the user name> Properties> User ing> checking the Database "albums" on the right. OK.
Bytes ------------------------------------------------------------------------------------------------------------------
It should be your web. if the config settings are incorrect, create a file under vs2005 and drag the sqldatasource control to connect it once. Then copy the connectionstring content in the configuration file to the Web. overwrite config.