How to create new user login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

How to create new user login

Author

Topic

saxford
Starting Member

7 Posts

Posted - 2006-10-07 : 07:45:23

SQL SERVER 2000
i enter in Enterprise Manager
click on my database
on top i click 'new login' that just enable
on Database acess i check my database name
on General i put myname in Name:'saxford'

i leave password blank
it seem to be OK
but when i log on from another computer
it's appear
SQL SERVER Not Trust bla bla bla

what a man
can you advise me some wizard?

monty
Posting Yak Master

130 Posts

Posted - 2006-10-07 : 08:57:14

Hi,
follow the below procedure.
database>>security>>right click on login>>click new login>> now enter name ie user name and authentication and access...
or click the action menu, click new login and again same procedure..
this will help yaou i believe

its me monty

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources