Setting password for each database

[compassSoftware]

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

[Erland Sommarskog]

(co*************@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, es****@sommarskog.se

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

[compassSoftware]

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?

[Erland Sommarskog]

(co*************@gmail.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, es****@sommarskog.se

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