471,089 Members | 1,253 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,089 software developers and data experts.

Problem when accessing SQL database in website

I am developing apps in VWD Express and SQL Svr 2005 Express. I currently
have a web server running Win2K3 SBS W/IIS V.6.0 & ASP.NET 2.0. I am
currently using a test site that is only availible on my intranet. I have no
problem accessing the site, but when a link is clicked or somthing happens
where data is required from the SQL database, I get a long, ugly error
message that says:

Server Error in '/' Application.
----------------------------------
Cannot open user default database. Login Failed.
Login failed for user "NT Authority\Network Service".

Then the error message continues forever. This is what I have tried to do to
correct the problem: I have change the permissions in the SQL Server
Management Studio Express program that I downloaded from the Microsoft
website to allow the "NT Authority\Network Service" account authorization to
the database. I am a beginner at developing web apps, so I don't know much
about Visual Basic, so I havn't really done much code to the web.config file.
I have read books, and searched google for about a week and I still can't
find anything. I hope that this question doesn't seem too stupid. Thank You
for your help, and your response. - Jake
Mar 13 '06 #1
1 2139
why not turn on SQL Authentication and specify a username/password in your
connection string?

So ur connection string would look like:
Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

instead of using Trusted_Connection or Integrated_Security

Karl

--
http://www.openmymind.net/

"Jake Henderson" <Ja***********@discussions.microsoft.com> wrote in message
news:19**********************************@microsof t.com...
I am developing apps in VWD Express and SQL Svr 2005 Express. I currently
have a web server running Win2K3 SBS W/IIS V.6.0 & ASP.NET 2.0. I am
currently using a test site that is only availible on my intranet. I have
no
problem accessing the site, but when a link is clicked or somthing happens
where data is required from the SQL database, I get a long, ugly error
message that says:

Server Error in '/' Application.
----------------------------------
Cannot open user default database. Login Failed.
Login failed for user "NT Authority\Network Service".

Then the error message continues forever. This is what I have tried to do
to
correct the problem: I have change the permissions in the SQL Server
Management Studio Express program that I downloaded from the Microsoft
website to allow the "NT Authority\Network Service" account authorization
to
the database. I am a beginner at developing web apps, so I don't know much
about Visual Basic, so I havn't really done much code to the web.config
file.
I have read books, and searched google for about a week and I still can't
find anything. I hope that this question doesn't seem too stupid. Thank
You
for your help, and your response. - Jake

Mar 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by ndsoumah | last post: by
9 posts views Thread by Pacific Design Studios | last post: by
5 posts views Thread by =?Utf-8?B?bXVzb3NkZXY=?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.