Connection Woes :-(

  • Thread starter Thread starter lloyd
  • Start date Start date
L

lloyd

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