asp.net - Exception: query() error.Login failed for user 'adminaa' -
in 20 years of microsoft programming never have not been able resolve this.
i have tried normal stuff.
iis 7.0, windows 7.0, sql server 2012 running locally, there should no trust or network issues. been researching couple of hours , checking various stuff , not seeing reason why should not working.
here have attempted normal stuff:
1
i used sa it's user name password. got same message. went ssms , verified sa dbowner of db is. ssms logged in sa when connecting sql , verified password correct through cutting , pasting web.config file text box. logged in no problem ssms , able see database
2
in ssms created login adminaa user mapped db owner database. disconnected sql server reconnected new user, no issues. plugged new username , password in config file. got error can't login. went ssms disconnected sql server. ssms selected connect copied username , password config file appropriate areas. connected sql server went , browsed database, see data base ran select query no problem.
i @ loss. because message literally saying log in failing , nothing else when attempting run query.
this first time have used computer asp.net sql.
Comments
Post a Comment