Connection with SQL server failed

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)
 
R

Riki

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.
 
B

BIJU

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem while connecting sql server ASP.net 1
Login failed for user '(null)' 5
Open Connection error 1
asp.net 2
Impersonation with SQL Server SSPI 3
Problem with sql connection with impersonate true 9
sql server and asp.net problem 8
Windows authentication from ASP.net application to Sql Server 7

Top