RE: MELL and SQL
- From: "Scott" <Scott@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 28 May 2005 18:24:02 -0700
I too am having trouble. Although I haven't had any success yet, you might
want to check the DSN. Make sure it is using Windows Authenticatin. A
description is in the deployment guide. Have you had success yet? As for me,
when I connect to the reports, the web page replys it can't connect. When I
go to the home page, it tells me there is an ASP error, bad string "..".
"Cannon" wrote:
> Thanks for the response Tony.
>
> It's not giving me the option one way or the other. The error message is
> basically saying that it can't establish a trusted relationship and assumes
> it's a permissions problem. At this point I'm logged in as admin and since
> windows authentication was used, I'm assuming that the admin account would
> have the necessary permissions for the installation. Maybe it doesn't. I'll
> go back and see if I can find something in the MELL documentation concerning
> this. But I also just on a whim tried to create a new database and register
> it. The enterprise manager wouldn't let me do it saying that the server
> (local) doesn't exist or access is denied. Again, I know enough to go huh?,
> but not enough to go "duh, I need to do this first".
>
> Thanks
>
> Cannon
>
>
> "Tony Su" wrote:
>
> > Most third party apps don't use Windows Authentication, they use SQL
> > authentication and even use the SA account for access (very bad practice).
> >
> > You'll likely have to configure Mixed Mode authentication... Read your app's
> > docs and verify it wants to use a Windows or a SQL account.
> >
> > HTH,
> > Tony
> >
> > "Cannon" wrote:
> >
> > > I went to install MELL on IIS and it told me that it couldn't find a trusted
> > > relationship on my SBS. It said check the permissions. Now I know as much
> > > about MS SQL as the Local Urban Development Committee knows about milking
> > > cows. However, I did use windows authentication when I installed SQL. My
> > > assumption then is that if I'm logged in as the admin, then SQL should be
> > > able to authenticate admin.
> > >
> > > So where do I start? Is there a different set of permissions for SQL that I
> > > need to look at? Is this a symptom of a bigger problem? Am I going to feel
> > > sheepish once somebody points out to me that the solution was simply a check
> > > box?
> > >
> > > Thanks
> > >
> > > Cannon
.
- Prev by Date: Re: SBS SP1 went fairly well
- Next by Date: Re: Upgraded to ISA 2004, now we have web problems
- Previous by thread: SBS SP1 went fairly well
- Next by thread: SP1 finally done but port 444 not working
- Index(es):
Relevant Pages
|
