asp.net - Using windows authentication but getting access denied -


i created db via app-data folder, migrated on server explorer , tried connect , get

cannot open database "abc" requested login. login failed. login failed user 'xyz'. came across this: [cannot open database “test” requested login. login failed. login failed user 'xyz\aspnet'

i have 2 questions concerning best answer.

whenever connect ssms windows authentication selected. windows authentication still matter if db created using visual studio?

second concerning this:

update: ok, you're using integrated windows authentication --> need create sql server login "xyz\aspnet" on sql server"

what mean create sql login user "xyz"?

i thought purpose of win authentication didnt have type login , pass connect. you're automatically connected through windows. right?


Comments

Popular posts from this blog

javascript - Confirm a form & display message if form is valid with JQuery -

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

android - ConstraintLayout: Realign baseline constraint in case if dependent view visibility was set to GONE -