I have a ASP.Net MVC3 web app connecting to a MS SQL 2008 database. I dont want to set my user id and password in web.config. How do I set up Integrated Security = True or Integrated Security = SSPI When the above is set in my connection string get the error Login failed. The login is from an untrusted domain and cannot be used with Windows authentication Help appreciated thanks
What you are trying to do is to use the Windows authentication method to connect to the SQL server this will not work. I understand you are concerned with security but technically when you upload your web application to our web server and when your web application makes a call to our SQL server, the login credentials never gets passed to the Internet. It stays locally because both the SQL server and web server are on the same LAN. However, the bottom line, if your application is going to connect to our SQL server, you will need to use the db login and password assigned to it.