SQL Server Logins Issues

[l_eric_l]

Hi,

I'm trying to create a user login on SQL Server 2000 using a SPROC which
executes the sp_addlogin SPROC. This SPROC runs correctly when using Query
Analyzer while being logged in as a window domain user. However, when I call
this SPROC from a .cfm page logged in as a Standard SQL login user (which I've
set to have server admin rights) I get the folloiwing error:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]SELECT permission denied on
object 'sysxlogins', database 'master', owner 'dbo'.

Why? The account is set to have total control of the server.

TIA,
Eric

[mpwoodward *TMM*]

l_eric_l wrote:

> Hi,
>
> I'm trying to create a user login on SQL Server 2000 using a SPROC which
> executes the sp_addlogin SPROC. This SPROC runs correctly when using Query
> Analyzer while being logged in as a window domain user. However, when I call
> this SPROC from a .cfm page logged in as a Standard SQL login user (which I've
> set to have server admin rights) I get the folloiwing error:
>
> Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver][SQLServer]SELECT permission denied on
> object 'sysxlogins', database 'master', owner 'dbo'.
>
> Why? The account is set to have total control of the server.
>
> TIA,
> Eric
>

Can you hit the database at all from CF? Are you sure you have mixed
mode authentication turned on in SQL Server as opposed to just Windows
authentication?

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[l_eric_l]

Hey Matt,

Yeah I have mixed mode authentication and no I can't even do a simple select
on the master database. I've even redundantly added myself as a user in the
users sections of the database with owner permissions.

Any thoughts?

TIA,
Eric

[mpwoodward *TMM*]

l_eric_l wrote:

> Hey Matt,
>
> Yeah I have mixed mode authentication and no I can't even do a simple select
> on the master database. I've even redundantly added myself as a user in the
> users sections of the database with owner permissions.
>
> Any thoughts?
>
> TIA,
> Eric
>

Hmm ... not sure. Is the SQL Server on the same physical machine as CF
or a different physical machine? If it's a different machine, can you
try and connect to it using Enterprise Manager from the CF box? I'd
just be curious if it's a connectivity problem in general or something
specific with CF. The other thing you could try just for kicks is
setting up an ODBC connection to the SQL Server from the CF box at the
Windows level and see if you can get in that way. That will just help
narrow things down a bit.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion