RE: MELL and SQL

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
.

Relevant Pages

  • RE: mofifying webparts
    ... webpart or add the default webparts... ... > You can go to sql manager to check the right. ... >> I have created another user with admin permissions but the same happens again. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... > have the necessary permissions for the installation. ... >> Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)