Setting password for each database

Hi,

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.

Thanks

(compassSoftware@gma
il.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/techin.../2000/books.asp

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

What I am doing is I have exported a production db in to a new one I
have created and I am tring to work with the newly created one but I
can't seem to access it. In the newly created db I have create a user
name in the Users folder to match the user name in the production db.

I am using the same code in trying to access the new one as I use in
accessing the production db except I have changed the name of the
database to reflect the new db (i.e. I use the same user name and
password).

>From this description can you tell anything I am missing in accessing a
newly copied db?

(compassSoftware@gma
il.com)  writes:
> What I am doing is I have exported a production db in to a new one

How did you export it? Is the new database on the same server as the
old one?

> I have created and I am tring to work with the newly created one but I
> can't seem to access it.

What error message do you get?




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

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