db owner

I created a new db under sql 2000. I created an ASP page to access the db, I
can access the database via the asp from my machine but others cannot. They
get a NT logon error.
I noticed that the db I created the owner has my network logon id and domain
name.
example: db owner: domain/logonid
and all the other db system generated have owner od SA.
What should the owner name be?
If its SA how can i change that?
If not, how can I allow others to access the DB via the asp page?
thanksMike
See sp_changeobjectowner in books on line. Generally it is
best for all database object to be owned by dbo.
Regards
John|||use sp_changedbowner
--
BR,
Mark Broadbent mcse+i, mcdba
_________________________
"Mike" <csharpcoder@.sbcglobal.net> wrote in message
news:OBlBsQfUDHA.212@.TK2MSFTNGP12.phx.gbl...
> I created a new db under sql 2000. I created an ASP page to access the db,
I
> can access the database via the asp from my machine but others cannot.
They
> get a NT logon error.
> I noticed that the db I created the owner has my network logon id and
domain
> name.
> example: db owner: domain/logonid
> and all the other db system generated have owner od SA.
> What should the owner name be?
> If its SA how can i change that?
> If not, how can I allow others to access the DB via the asp page?
>
> thanks
>|||Mike
Oops read the post without reading it properly, Mark is of
course right. Still now you know what to do if you do the
same with an object.
Regards
John|||I changed the db owner, but I still can't access the db via asp from a
remote machine.
Do i have to change IIS settings or something to be able to do this?
Its currenlty set up to allow anonymous access, but i'm not allowing IIS to
control the password, should I?
"John Bandettini" <johnbandettini@.yahoo.co.uk> wrote in message
news:0ff201c351f9$3d40a860$a001280a@.phx.gbl...
> Mike
> Oops read the post without reading it properly, Mark is of
> course right. Still now you know what to do if you do the
> same with an object.
> Regards
> John|||Hi Mike, does the account that you are using to connect to the remote data
source (specified in your asp pages) have access permissions to the
database.
If you are using integrated security when forming the connection I would
expect that the account used would be the iis service one (in this case
would need access), I would be very suprised if security of each user was
delegated to the sql server (a-la kerberos style).
Also look at your DSN, cos if you have configured it to connect to the data
source using sql server authentication then I would expect that this user is
the one which would need the db rights.
Its been a while since I've done this but you should get there in the end
thru trial and error. The first thing you need to get working is getting the
asp pages to run (and connect) successfully from the web server itself. Then
try getting a remote client to work (connecting and running the asp).
First
--
BR,
Mark Broadbent mcdba,mcse+i
_________________________
"Mike" <csharpcoder@.sbcglobal.net> wrote in message
news:%23nhcm2fUDHA.2316@.TK2MSFTNGP09.phx.gbl...
> I changed the db owner, but I still can't access the db via asp from a
> remote machine.
> Do i have to change IIS settings or something to be able to do this?
> Its currenlty set up to allow anonymous access, but i'm not allowing IIS
to
> control the password, should I?
> "John Bandettini" <johnbandettini@.yahoo.co.uk> wrote in message
> news:0ff201c351f9$3d40a860$a001280a@.phx.gbl...
> > Mike
> >
> > Oops read the post without reading it properly, Mark is of
> > course right. Still now you know what to do if you do the
> > same with an object.
> >
> > Regards
> >
> > John
>