My application produces this error System.Data.SqlClient.SqlException: Login failed for user..This started after I added a stored proc in my dbml file. It works fine in my local enviroment, but throws that error when deploy to staging sever. the user it displays is foreign to me
A:
Does this post solve your problem? It talks about moving the connection string from the app.config to the web.config
Chris Haas
2010-04-02 18:00:22
My web config matches my local config. No luck yet
Charles
2010-04-02 19:36:41
The problem had nothing to do with the stored proc, thanks everyone.
Charles
2010-04-05 14:16:45