Posted by Erland Sommarskog on 05/27/05 01:20

(compassSoftware@gmail.com) writes:
> When I create a new database from Enterprise Manager (right click on
> databases > New Database) I noticed that I am not prompted to create a
> password or user name. Can I take it then that all databases under the
> same local group will have the same password and user name?
>
> I have tied to access the newly created database using the same
> password and username but haven't had any luck.

There is no password per database. However, a login must be granted
access to a database to be able to access it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Still need help creating a DB by RESTORE - problems
• Prev in forum: Re: Help with SELECT please
• Thread view: Re: Setting password for each database

[Reply to this message]