By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Connection Woes :-(

P: n/a
i am trying to connect to SQL 7.0 using the following connection
string
myConnectString = "Initial Catalog=[SmartLan 2.0 ED];Data
Source=localhost;Integrated Security=SSPI;"

i always the get the following error message
Cannot open database requested in login '[SmartLan 2.0 ED]'. Login
fails. Login failed for user 'L20935-P3\ASPNET'.

In the Web.Config file i have the following setup

<authentication mode = "None"></authentication>
<identity impersonate="false" />

I have also granted Permission in Sqlserver/Users to ASPNET which is
the Id for asp worker process.

I cant figure out whats going on, maybe you have come across this
problem.

I also tried changing the identity to true in the webconfig, but that
didnt work either???

i also noticed that the ASP.NET state service is off, is this
required??
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Is your sql server on the same computer as your webserver? Then you didn't grant the appropriate permissions to the aspnet user on sql server.

Is your sql server on a different computer than the webserver? Then you are going to need to set up a domain account that your asp.net application hits the sql server with, the aspnet account would never have enough privelages to hit another computer.

If you have more problems please reply, but microsoft.public.dotnet.framework.aspnet.security would be a more appropriate forum for this.

--Michael

"lloyd" <ll***********@rediffmail.com> wrote in message news:e7*************************@posting.google.co m...
i am trying to connect to SQL 7.0 using the following connection
string
myConnectString = "Initial Catalog=[SmartLan 2.0 ED];Data
Source=localhost;Integrated Security=SSPI;"

i always the get the following error message
Cannot open database requested in login '[SmartLan 2.0 ED]'. Login
fails. Login failed for user 'L20935-P3\ASPNET'.

In the Web.Config file i have the following setup

<authentication mode = "None"></authentication>
<identity impersonate="false" />

I have also granted Permission in Sqlserver/Users to ASPNET which is
the Id for asp worker process.

I cant figure out whats going on, maybe you have come across this
problem.

I also tried changing the identity to true in the webconfig, but that
didnt work either???

i also noticed that the ASP.NET state service is off, is this
required??

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.