Setting password for each database

[compassSoftware@gmail.com]

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]

Re: Setting password for each database

(compassSoftwar e@gmail.com) writes:[color=blue]
> 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.[/color]

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@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[compassSoftware@gmail.com]

Re: Setting password for each database

[color=blue]
> There is no password per database. However, a login must be granted
> access to a database to be able to access it.[/color]

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).
[color=blue]
>From this description can you tell anything I am missing in accessing a[/color]
newly copied db?

[Erland Sommarskog]

Re: Setting password for each database

(compassSoftwar e@gmail.com) writes:[color=blue]
> What I am doing is I have exported a production db in to a new one[/color]

How did you export it? Is the new database on the same server as the
old one?
[color=blue]
> I have created and I am tring to work with the newly created one but I
> can't seem to access it.[/color]

What error message do you get?




--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp