Connection with SQL server failed

  • Thread starter Thread starter BIJU
  • Start date Start date
B

BIJU

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 address removed)
 
BIJU said:
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 address removed)
Click to expand...

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.
 
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
 
Back
Top