Re: IIS6 to access SQL db

From: Kristofer Gafvert (kgafvert_at_NEWSilopia.com)
Date: 05/15/04


Date: Sat, 15 May 2004 10:46:08 +0200

Hello,

You need to grant access to the user in the database. You do not need to do
anything in IIS, you do NOT need to create a virtual directory (but you
might need one for another reason). Share the database? I dont even know how
to share the database, so that doesn't sound like something you need to do.

As for the connection string, see here:

http://www.connectionstrings.com

-- 
Regards,
Kristofer Gafvert - IIS MVP
http://www.ilopia.com - When you need help!
"shashi" <anonymous@discussions.microsoft.com> wrote in message
news:6B4E5C0D-8896-40BC-B4E0-5E1EFE3415C2@microsoft.com...
> Hi,
>
> I'm trying to setup iis to access a sql db which is in a separate machine
(SQL SERVER) in the same domain.
> Could anyone guide me how to set this up in the iis. then I have to
provide my customer the connection string
> to be added in is sql db. I know I have to create a vertiual directory in
iis I'm not sure what to do then.
> Do I have to share the sql db on the sql server machine?
> Please help
> Thanks
>


Relevant Pages

  • Login failure from asp.net delegation
    ... We want to use windows 2000 User auth to query sql 2000 using security ... checked "Integrated Windows Auth" in IIS and have added this to web.config. ... I have not added a login to the database since i thought it passes in the ...
    (microsoft.public.sqlserver.security)
  • Re: Whats best practice for connecting to a Sql Server database
    ... I doubt you are moving to IIS 8 yet since IIS 7 is the version shipping in ... I generally prefer using Windows auth over SQL auth when possible ... that the web app ran under a user that had very weak rights and the ... connection string had the uname/pw to connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to read data from stand alone SQL CE database on mobile device from VB.net 2005
    ... server running IIS to make the connection. ... the IIS requirement for SQL Server but I don't know. ... I have a stand alone SQL CE database on my windows mobile device. ...
    (microsoft.public.sqlserver.ce)
  • Delegation not working, please help
    ... We want to use windows 2000 User auth to query sql 2000 using security ... checked "Integrated Windows Auth" in IIS and have added this to web.config. ... I have not added anything to the database since i thought it passes in the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Server or IIS
    ... > user accounts to authenticate to SQL when they access the ... > database over the web. ... > is the database that locks them out or IIS. ...
    (microsoft.public.sqlserver.security)