I have written code in Visual Studio.NET and used data from SQL Server 2008. After debugging, it says:
Login failed for user 'sunny'.
When I try to set the user as something else, it keeps on reporting that error. I start sql with windows authentication and the username there is:
I do not have any sql authentication user/pass on sqlserver express 2008.
I tried changing the authentication in server/security tab. I changed it to both windows and sql. but it didn't fix the error.
What should I do?
Here is the connection string in web.config:
<configuration> <appSettings> <add key="SchoolsDBConnectionString" value="server=sunny-lptp\sqlexpress;database=SchoolsDB;"> </add> </appSettings>
And the code:
scn = new sqlConnection( ConfigurationManager.AppSettings["SchoolsDBConnectionString"].ToString());