Hai,
I am a new in ASP.NET. I tried to connect ASP.net(VB) with SQL server 2000.
I got the connection failed message as Login Failed for user 'NT
AUTHORITY\NETWORK SERVICE' " ie. System. Data.sqlclient.sqlException: Login
Failed for user 'NT AUTHORITY\NETWORK SERVICE'. Kindly provide solution.
Thank you in advance
Thanks and regards
BIJU
(E-Mail Removed)

BIJU wrote:
> Hai,
> I am a new in ASP.NET. I tried to connect ASP.net(VB) with SQL server
> 2000. I got the connection failed message as Login Failed for user 'NT
> AUTHORITY\NETWORK SERVICE' " ie. System. Data.sqlclient.sqlException:
> Login Failed for user 'NT AUTHORITY\NETWORK SERVICE'. Kindly provide
> solution. Thank you in advance
> Thanks and regards
> BIJU
> (E-Mail Removed)

As the error message says: Login Failed.
Make sure you add a login to your SQL Server for the NETWORK SERVICE windows
account.
And make sure that that login has access to your database.

--

Riki

Hai Riki,
Thanks 4 ur response. I am using windows NT authentication for SQL SERVER.
How I can check whether I add a login to your SQL Server for the NETWORK
SERVICE windows account. and have login has access to your database. Kindly
provide solution
BIJU


"Riki" wrote:

> BIJU wrote:
> > Hai,
> > I am a new in ASP.NET. I tried to connect ASP.net(VB) with SQL server
> > 2000. I got the connection failed message as Login Failed for user 'NT
> > AUTHORITY\NETWORK SERVICE' " ie. System. Data.sqlclient.sqlException:
> > Login Failed for user 'NT AUTHORITY\NETWORK SERVICE'. Kindly provide
> > solution. Thank you in advance
> > Thanks and regards
> > BIJU
> > (E-Mail Removed)
>
> As the error message says: Login Failed.
> Make sure you add a login to your SQL Server for the NETWORK SERVICE windows
> account.
> And make sure that that login has access to your database.
>
> --
>
> Riki
>
>
>

In SQL Server 2000 Enterprise Manager, go to Security-Logins.

--

Riki

BIJU wrote:
> Hai Riki,
> Thanks 4 ur response. I am using windows NT authentication for SQL
> SERVER. How I can check whether I add a login to your SQL Server for
> the NETWORK SERVICE windows account. and have login has access to
> your database. Kindly provide solution
> BIJU
>
>
> "Riki" wrote:
>
>> BIJU wrote:
>>> Hai,
>>> I am a new in ASP.NET. I tried to connect ASP.net(VB) with SQL
>>> server 2000. I got the connection failed message as Login Failed
>>> for user 'NT AUTHORITY\NETWORK SERVICE' " ie. System.
>>> Data.sqlclient.sqlException: Login Failed for user 'NT
>>> AUTHORITY\NETWORK SERVICE'. Kindly provide solution. Thank you in
>>> advance
>>> Thanks and regards
>>> BIJU
>>> (E-Mail Removed)
>>
>> As the error message says: Login Failed.
>> Make sure you add a login to your SQL Server for the NETWORK SERVICE
>> windows account.
>> And make sure that that login has access to your database.
>>
>> --
>>
>> Riki