Click here to Skip to main content
14,579,188 members
Rate this:
Please Sign up or sign in to vote.
See more:
User Access Permission in Database Scripting file
"Control" Permission (Grant and With Grant)

What I have tried:

I have tried this

Create Login SampleDataBase With PASSWORD = '123456789'
Create User SampleDataBase For LOGIN SampleDataBase

This error showing ?
Cannot open database "ABC" requested by the login,
login failed for user 'SampleDataBase' ?

No more further idea
Posted
Updated 24-Jun-20 8:43am
v4
Comments
ZurdoDev 24-Jun-20 9:32am
   
What!!!??
Richard MacCutchan 24-Jun-20 10:19am
   
"Cannot open database "ABC" requested by the login,"
Where does this message come from?
Computechsoft 28-Jun-20 12:39pm
   
I have created user login in SQL server when i do run application.

This error showing ?
Cannot open database "ABC" requested by the login,
login failed for user 'SampleDataBase' ?
Maybe access permission issue ?
Richard MacCutchan 28-Jun-20 12:42pm
   
Something is still wrong with your login details. See Create a Login - SQL Server | Microsoft Docs[^].
Computechsoft 4 days ago
   
I have resolved ? this issue
Integrated security = True
Afzaal Ahmad Zeeshan 24-Jun-20 18:05pm
   
It means that the user account that you have created either did not have a login set up properly for the database, or the password is incorrect.

Check this thread to learn more on that.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100