I've fixed it now... I used the "Trusted_connection=yes;" now it said login failed for user DOMAIN\ASPNET so I just made an account called ASPNET :( Althought I would have liked to see if I could make it so it logged in using my sql authentication...
My connection String is:
<add key="strSqlConnectionString" value="server=localhost;database=sladesfaculty;Trusted_Connection=yes;" />
^ Should work fine. Also, you need to make sure your SQL Server is set for SQL Server Authentication (and not just Windows Authentication). Just because you've made SQL Server Authentication usernames and passwords doesn't mean its set properly.
In SQL Server Enterprise Manager, right click on your server, and go to properties. On the "Security" tab, make sure the "SQL Server and Windows" radio button is selected.
FYI, the "." is a shortcut for localhost in an SQL Server connection string :cool: .
that was my original string. I also used sql & windows authentication but it didn't work, not even when I have the username and password as my actual windows authentication... it still said it wasn't a trusted connection. Any ideas?
If you want to use Windows authentication in ASP.NET, you can't just put in your DOMAIN\USER and password. You need to enable a trusted connection and use identity impersonation on your web application (or enable the ASPNET account on your database).
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...
I'm working in Excel to extract content of a table from a web page and populate Excel sheet cells with it. I'm trying to extract data from a table that gets loaded to a web page after show results method gets called. I have an error that says "Run-time error ...