MSSQL Permissions help

6 public posts in this discussion.

Post 1

Not sure why this isn't working but I've followed the steps I've taken with every other database but this one just doesn't want to work.

Login failed for user 'PARENTHESIS\ASPNET'.

[FONT=Arial, Helvetica, Geneva, SunSans-Regular, sans-serif] Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'PARENTHESIS\ASPNET'.

Source Error:

Line 443: updateCommand.Parameters["@userid"].Value = userid;
Line 444:
Line 445: headsonicConnection.Open();
Line 446: updateCommand.ExecuteNonQuery();
Line 447: headsonicConnection.Close();[/FONT]

Post 2

Server Error in '/HeadsonicLocal' Application.
--------------------------------------------------------------------------------

Login failed for user 'PARENTHESIS\ASPNET'.

Post 3

Do you have code that resembles something like the following, in your page?
[PHP]
OleDbConnection oleDbConnection;
oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = "Provider=SQLOLEDB;Password=MYPASSWORD;User ID=MYUSERID;Data Source=SERVERADDRESS";
oleDbConnection.Open();[/PHP]

And this tag at the top of your page?
[PHP]<%@ import Namespace="System.Data.OleDb" %>[/PHP]

Post 4

[HTML]this.headsonicConnection.ConnectionString = "packet size=4096;integrated security=SSPI;data source=\"(local)\";persist security info=False;initial catalog=Headsonic";[/HTML]

Post 5

20 hours onward, and I have still not found a conclusion.

Post 6

By all means Microsoft allows you to connect the dots in about 50 million ways, but does not tell you the numbers of the dots.