fix logins

How do you create the logins with the same password, when
you backup and restore a database to a seperate server and
those logins do not exist at the server level?
AdamEither specify the SID that the user has in the database in your sp_addlogin
call, or just add the login and
fix the user's sid using sp_change_users_login, or use the KB article to exp
ort the logins from the source
server (search KB for sp_help_revlogin).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam" <anonymous@.discussions.microsoft.com> wrote in message news:12ade01c41874$f63ca8e0$a
001280a@.phx.gbl...
> How do you create the logins with the same password, when
> you backup and restore a database to a seperate server and
> those logins do not exist at the server level?
> Adam|||Thanks Tibor,
Does sp_change_users_login work for non-windows accounts?
What about adding the login and fix the user's sid? How
does that work for non-windows, how do I keep the
passwords from the database?

>--Original Message--
>Either specify the SID that the user has in the database
in your sp_addlogin call, or just add the login and
>fix the user's sid using sp_change_users_login, or use
the KB article to export the logins from the source
>server (search KB for sp_help_revlogin).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message news:12ade01c41874$f63ca8e0$a001280a@.phx
.gbl...
when
and
>
>.
>|||This will not transfer the passwords. You can add a login
by using sp_addlogin and then map it to the user in the
database but for that you will have to know all the
passwords. sp_help_revlogin will move the passwords for
you.
You can also move the logins by using Login Transfer task
in DTS wizard.
Obaid
>--Original Message--
>Thanks Tibor,
>Does sp_change_users_login work for non-windows accounts?
>What about adding the login and fix the user's sid? How
>does that work for non-windows, how do I keep the
>passwords from the database?
>
>in your sp_addlogin call, or just add the login and
>the KB article to export the logins from the source
>message news:12ade01c41874$f63ca8e0$a001280a@.phx
.gbl...
>when
>and
>.
>|||> Does sp_change_users_login work for non-windows accounts?
Yes, it is used exactly for SQL Server logins.

> What about adding the login and fix the user's sid?
That is another option. See Books Online, sp_addlogin, and you'll find a par
ameter for specifying the SID.
Again, search KB for sp_help_revlogin and you'll find an a article with whic
h you can export all logins from
one server to another.

> How
> does that work for non-windows, how do I keep the
> passwords from the database?
It work just fine for non-windows accounts. I'm not sure I understand the pa
rt about password. There's no
password stored inside a database, only in master.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam" <anonymous@.discussions.microsoft.com> wrote in message news:17c1601c418d4$d21fcf90$a
101280a@.phx.gbl...
> Thanks Tibor,
> Does sp_change_users_login work for non-windows accounts?
> What about adding the login and fix the user's sid? How
> does that work for non-windows, how do I keep the
> passwords from the database?
>
> in your sp_addlogin call, or just add the login and
> the KB article to export the logins from the source
> message news:12ade01c41874$f63ca8e0$a001280a@.phx
.gbl...
> when
> and

fix logins

How do you create the logins with the same password, when
you backup and restore a database to a seperate server and
those logins do not exist at the server level?
Adam
Either specify the SID that the user has in the database in your sp_addlogin call, or just add the login and
fix the user's sid using sp_change_users_login, or use the KB article to export the logins from the source
server (search KB for sp_help_revlogin).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam" <anonymous@.discussions.microsoft.com> wrote in message news:12ade01c41874$f63ca8e0$a001280a@.phx.gbl...
> How do you create the logins with the same password, when
> you backup and restore a database to a seperate server and
> those logins do not exist at the server level?
> Adam
|||Thanks Tibor,
Does sp_change_users_login work for non-windows accounts?
What about adding the login and fix the user's sid? How
does that work for non-windows, how do I keep the
passwords from the database?

>--Original Message--
>Either specify the SID that the user has in the database
in your sp_addlogin call, or just add the login and
>fix the user's sid using sp_change_users_login, or use
the KB article to export the logins from the source
>server (search KB for sp_help_revlogin).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Adam" <anonymous@.discussions.microsoft.com> wrote in
message news:12ade01c41874$f63ca8e0$a001280a@.phx.gbl...
when
and
>
>.
>
|||This will not transfer the passwords. You can add a login
by using sp_addlogin and then map it to the user in the
database but for that you will have to know all the
passwords. sp_help_revlogin will move the passwords for
you.
You can also move the logins by using Login Transfer task
in DTS wizard.
Obaid
>--Original Message--
>Thanks Tibor,
>Does sp_change_users_login work for non-windows accounts?
>What about adding the login and fix the user's sid? How
>does that work for non-windows, how do I keep the
>passwords from the database?
>
>in your sp_addlogin call, or just add the login and
>the KB article to export the logins from the source
>message news:12ade01c41874$f63ca8e0$a001280a@.phx.gbl...
>when
>and
>.
>
|||> Does sp_change_users_login work for non-windows accounts?
Yes, it is used exactly for SQL Server logins.

> What about adding the login and fix the user's sid?
That is another option. See Books Online, sp_addlogin, and you'll find a parameter for specifying the SID.
Again, search KB for sp_help_revlogin and you'll find an a article with which you can export all logins from
one server to another.

> How
> does that work for non-windows, how do I keep the
> passwords from the database?
It work just fine for non-windows accounts. I'm not sure I understand the part about password. There's no
password stored inside a database, only in master.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Adam" <anonymous@.discussions.microsoft.com> wrote in message news:17c1601c418d4$d21fcf90$a101280a@.phx.gbl...
> Thanks Tibor,
> Does sp_change_users_login work for non-windows accounts?
> What about adding the login and fix the user's sid? How
> does that work for non-windows, how do I keep the
> passwords from the database?
>
> in your sp_addlogin call, or just add the login and
> the KB article to export the logins from the source
> message news:12ade01c41874$f63ca8e0$a001280a@.phx.gbl...
> when
> and

Firefox and password problem with URL access

with URL access, IE does not prompt for password to report server on
"localhost" but Firefox (1.07 - latest version) prompts repeatedly for id and
password. Even when the correct admin credentials are entered it still
continues to prompt for password.We had similar problem with RS2005 in IE. The quick fix was to go into
Tools | Internet Options | Security | Local Intranet | Custom Settings
then scroll down to User Authentication | Logon and set to "Automatic
logon with current username and password"
You may also have to do this for the "Internet" zone too.
We got group policies set to cure this in the long term, but this is
not my area so I can't give specifics.
Now in Firefox, I don't know if there is a setting to pass windows
credentials through to IIS - which is what is going wrong in your
scenario. I've had a quick check and couldn't see anything. But with
Sept CTP it doesn't work well at all with FireFox anyway!!
--
Regards
Chris
Sammy wrote:
> with URL access, IE does not prompt for password to report server on
> "localhost" but Firefox (1.07 - latest version) prompts repeatedly
> for id and password. Even when the correct admin credentials are
> entered it still continues to prompt for password.