SQL Server login failing

[Anil Gupte]

I am getting the following error:

*********
Login failed for user 'AUM\ASPNET'.
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.Sql Client.SqlExcep tion: Login failed for user
'AUM\ASPNET'.
*********
It is failing on the dbConnection.Op en(); line

I am using the following to connect (this is from a tutorial in a book):
************
string connectionStrin g =
ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];
System.Data.IDb Connection dbConnection = new
System.Data.Sql Client.SqlConne ction(connectio nString);
string queryString = "Select count([Fans].[FanEmail]) from [Fans] where
([Fans].[FanEmail] = @FanEmail)";
System.Data.IDb Command dbCommand = new System.Data.Sql Client.SqlComma nd();
************

I am using a local SQL server (installed with my VS.Net 2003. How can I
allow it to login or use the dbo user to do the database stuff?
Thanx,
--
Anil Gupte
www.keeninc.net
www.icinema.com

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Anil Gupte wrote:

Thanx. If I wanted to do it using the connection string, how would I do it?

With integrated windows security you do not specify any username in
the connection string.

If you want to specify a username and a password you need to enable
SQLServer security (mixed mode).

Another poster has give you instructions for this. But I would
recommend integrated security.

Arne

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Anil Gupte wrote:

Thanx, but what is OSQL? I tried this Query Analyser, and the first part
seems to work, but I stumbled on this:

GRANT dbo.owner TO ASPNET

Obviously the syntax is incorrect for dbo.owner, but what should it be?

OSQL is a command line utility that comes with SQLServer.

You can also use QA.

Se GRANT syntax at:
http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx

Arne