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
biju_sur@hotmail.com
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
> biju_sur@hotmail.com
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
> > biju_sur@hotmail.com
>
> 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
>>> biju_sur@hotmail.com
>>
>> 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