This error makes no sense to me whatsoever.
I'm using Enterprise Manager to create a new user for a new dbase and
regardless of anything I put in there, it gives me that 15007 message.Make sure the user that you are adding to the database has corresponding
login created.
Ex:
--To create login
use master
go
sp_addlogin 'user1', 'password'
go
--To add the user to the current database(here im picking up northwind).
use northwind
go
sp_grantdbaccess 'user1'
go
--
-Vishal
"Robert Blackwell" <robbie@.NOspamwowcentral.com> wrote in message
news:enYIIRVVDHA.2328@.TK2MSFTNGP12.phx.gbl...
> This error makes no sense to me whatsoever.
> I'm using Enterprise Manager to create a new user for a new dbase and
> regardless of anything I put in there, it gives me that 15007 message.
>|||Okay thanks, I was able to copy your instructions exactly. However, isn't
there a way to do all of that in Enterprise Manager?|||Hmm, maybe I should try clicking the new login button on the tool bar? ;o)
Thanks again.
Thursday, March 22, 2012
error 15007: The login'anything' does not exist.
Labels:
create,
database,
dbase,
enterprise,
error,
exist,
loginanything,
manager,
microsoft,
mysql,
oracle,
regardless,
sense,
server,
sql,
user,
whatsoever
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment