Re: Newbie question on SQL connection
From: Rudy (Rudy_at_discussions.microsoft.com)
Date: 01/14/05
- Next message: Ken Cox [Microsoft MVP]: "Re: Help! Can't create ASP.NET project"
- Previous message: SirPoonga: "Event not firing"
- In reply to: Peter Chadwick (MCP): "Re: Newbie question on SQL connection"
- Next in thread: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 14 Jan 2005 09:29:03 -0800
Hello Patrick and Peter,
Thank you for the advice. Patrick, I tried to add "localhost/aspnet, but
I'm not able to add non-domain user to the AD. And I don't think I really
want to.
Peter - I am using intergrated security. I think my connection string is
good, but I didn't think about adding the user to the string. Last night I
did put web online from my web server, which is also my domain server. And my
website launched, but when I went to login, it gave me an error. My login
names and password are part my database, so it's not connecting to the
database on my developer machine. Didn't try to connect to database on my
domain server, going to try that tonite.
Thanks again for the advise!
Rudy
"Peter Chadwick (MCP)" wrote:
> Hi,
>
> I take it you are using integrated security for connection to your SQL
> databases? In which case, the user your website uses will need access
> to the SQL databases (but I think you already know that).
>
> You can change the user your ASP.NET websites run under by changing the
> "processModel" section of machine.config (usually found in somewhere
> like C:\WINNT\Microsoft.NET\Framework\v1.1.4322\CONFIG), although I
> would be very careful doing this on anything other than a development
> machine. The ASPNET user deliberately has little permissions as it is
> essentially exposed to all users accessing the site.
>
> It sounds like you are approaching this correctly. It's good practice
> to develop databases away from the live SQL server - that way in the
> future you can develop changes to the database without affecting the
> existing version. And the beauty of connection strings is that you can
> change them to point to different databases/servers very easily.
>
> I'm not sure why you are getting that error when connecting to your
> domain SQL Server. Maybe there is a problem with permissions to your
> domain SQL server? Does your connection string contain a typo?
>
> Another option would be to set up a sql login (an actual sql server
> user) and connect using the username and password properties of the
> connection string rather than integrated security.
>
> Hope this sets you off in the right direction!
> Regards,
>
> Peter Chadwick (MCP)
> pete@code-explorers.com
>
>
- Next message: Ken Cox [Microsoft MVP]: "Re: Help! Can't create ASP.NET project"
- Previous message: SirPoonga: "Event not firing"
- In reply to: Peter Chadwick (MCP): "Re: Newbie question on SQL connection"
- Next in thread: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
