Prosi Lv2Posted 12 Dec 2023 16:50
  
1. If you're doing your own membership you probably don't need a stored procedure to login, just return the user by username and then check their password in code.
2. Check your SP if you're going down that route, do the following:
Check that the SP exists within your EDMX, do this via the model browser
Check that the SP exists on your Database Server, via SSMS
Check that you can execute the SP as yourself on SSMS with appropriate params
Check that the user your website is connecting to the db with (likely a SQL login) can both connect to the database and has execute permissions to the stored procedure.

I Can Help:

Change

Moderator on This Board

0
2
4

Started Topics

Followers

Follow

67
14
3

Started Topics

Followers

Follow

3
0
2

Started Topics

Followers

Follow

1
131
3

Started Topics

Followers

Follow

Board Leaders