Groups | Blog | Home
all groups > asp.net > january 2008 >

asp.net : Connection with SQL server failed


BIJU
1/11/2008 10:44:00 PM
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
1/12/2008 1:13:00 AM
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


[quoted text, click to view]
Riki
1/12/2008 9:58:42 AM
[quoted text, click to view]

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

Riki
1/12/2008 2:00:01 PM
In SQL Server 2000 Enterprise Manager, go to Security-Logins.

--

Riki

[quoted text, click to view]


AddThis Social Bookmark Button