I have written a code in Visual Studio.NET and used data from SQL Server 2008. But after debugging, it says:
Login failed for user 'sunny'.
When I try to set the user as something else, it keeps on saying 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 didnt 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>
scn = new sqlConnection( ConfigurationManager.AppSettings["SchoolsDBConnectionString"].ToString());
any help ??