| Author |
Setting password for each database
|
|
| compassSoftware@gmail.com 2005-05-26, 8:24 pm |
| 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 2005-05-26, 8:24 pm |
| (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
| |
| compassSoftware@gmail.com 2005-05-26, 8:24 pm |
|
> 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 2005-05-27, 8:23 pm |
| (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
|
|
|
|