Re: Connection Woes :-(
From: Raterus (raterus_at_spam.org)
Date: 05/05/04
- Next message: WJ: "Re: maxlength on multiline textbox"
- Previous message: Bin Song, MCP: "Re: asp:CheckBox problem"
- In reply to: lloyd: "Connection Woes :-("
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 May 2004 16:22:03 -0400
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" <lloydmonteiro@rediffmail.com> wrote in message news:e783765f.0405051052.adf213c@posting.google.com...
> 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??
- Next message: WJ: "Re: maxlength on multiline textbox"
- Previous message: Bin Song, MCP: "Re: asp:CheckBox problem"
- In reply to: lloyd: "Connection Woes :-("
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
