Re: Frustration

From: Usman (jathol@hotmail.com)
Date: 03/19/03 

From: "Usman" <jathol@hotmail.com>
Date: Wed, 19 Mar 2003 14:49:21 -0800

or you can check if the remote DB amdin is running the SQL server on some
other port then default ;)

thanks
Usman
"Bala Neerumalla[MSFT]" <balnee@online.microsoft.com> wrote in message
news:eTUH3Ud7CHA.3332@TK2MSFTNGP11.phx.gbl...
> Yeah that might be the reason.
>
> Your IIS Server might be running under a local user account
> (IUSER_IISMACHINE) which doesnt exist on the remote SQL Server. So it is
> trying to go out as a guest account and is getting access denied. So You
> need to change that user account to a domain account with proper
permissions
> on the IIS Server and grant him necessary rights on the SQL Server to get
> the required reports or the option is to create IUSER_IISMACHINE user
> account on SQL Server and grant him enough rights in SQL Server.
>
> Thanks,
> Bala.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
> news:#vH$7Qa7CHA.2184@TK2MSFTNGP11.phx.gbl...
> > What security mode is configured on the remote SQL Server?
> >
> > Do you know how front page is trying to make a connection? Could you
post
> > the connect string, may be?
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> >
> >
> > "quixote" <cenospam_reynolds@yahoo.com> wrote in message
> > news:138101c2ed5f$0650f480$3301280a@phx.gbl...
> > OK. I'm a bit new to SQL Server. I am having a
> > user/role/permissions problem.
> > Locally I am running Win2K with IIS. I am logged into a
> > corporate domain. I am trying to connect to a remote SQL
> > serverdb on the same domain. I am using a Frontpage
> > database results page to try to connect to this database
> > but it won't let me. Error: Not associated with a trusted
> > SQL Server connection. I have tried using Windows and SQL
> > authentication but I am obviously doing something wrong.
> >
> > How can I resolve this problem?
> >
> > Thanks
> >
> >
>
>

Relevant Pages

  • Re: Help with Software/Hardware decision....
    ... SQL server on DC question has two aspects such as performance and security. ... the computer running SQL Server as a domain controller will work (and it ... MSSQLServer service must run within the security context of an NT account. ... This configuration lets users assign permissions and rights to a service by ...
    (microsoft.public.windows.server.networking)
  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
  • Re: Scheduling a simple local package wont stick
    ... the FTP is just the first part of this package I wish to accomplish. ... group does not need to be, and on my servers is not, a SQL Server sysadmin. ... it is not obvious to me which account you are running under ... The rights you need to check are not SQL Server rights, ...
    (microsoft.public.sqlserver.dts)
  • Re: ASP.NET - SQL Server does not exist or access denied
    ... Make sure that the account is set up with "Log on as a Service" and "Log on as ... Make sure you've looked at your machine.config file as well (Windows ... ensure it would have no rights as a user), then set it up with the "log on" ... > a "SQL Server does not exist or access denied" error. ...
    (microsoft.public.sqlserver.security)
  • RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
    ... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
    (microsoft.public.sqlserver.dts)