Can SQL 2000 restore user login and database to another
domain and computer name? If it can't, how to export user
login to another computer?You can migrate logins from one server to another server by generating a
script using a routine called sp_help_revlogin. Here is an article I wrote
about it:
http://databasejournal.com/features/mssql/article.php/2228611
--
----
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Mesak" <anonymous@.discussions.microsoft.com> wrote in message
news:481301c49fe2$d7215e10$a401280a@.phx.gbl...
> Can SQL 2000 restore user login and database to another
> domain and computer name? If it can't, how to export user
> login to another computer?
Showing posts with label domain. Show all posts
Showing posts with label domain. Show all posts
Saturday, February 25, 2012
Sunday, February 12, 2012
Can not send mail with xp_sendmail procedure
Hallo!
Environment:
Windows 2000 domain (2 x win2000 sp4 domain conrollers)
Exchange 5.5 running on winnt4.0 member server
SQL 2000 sp3 running on Windows 2000 member server.
I have SQL server running under domain administrator account (both services)
and Outlook 2000 on the same server profile set with the same account and
Exchange 5.5.
SQL agent is set to use that profile and also SQL mail (under support
services in SQL manager). When I test that profile it works OK. I can send
test mail to the operator and all my alerts can send mail fine.
Problem is, that my new application uses xp_sendmail procedure to send mail,
and it doesn't work. I get this error when running the procedure:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80070005
I found an article Q293422 that descibes this problem but the solution did
not solve the problem. Besides, this article is about Exchange 2000 mailbox
and I'm using 5.5 mailbox.
I just managed to temporary fix this problem. I created new domain user in
AD and it's mailbox in Exchange 5.5. After seting SQL service, SQL agent
service, mail settings in Enterprise manager and new profile in Outlook to
use that new account, everything was working OK. xp_sandmail was working
too. But the next day same problem repaired. xp_sendmail reported same
errors again.
I suspect there are some security isues with SQL service account, but what?
Why is it working OK for one day and then stops the next?
Any ideas would be appreciated! Thanks.
DanSome links to KB articles and other resources helping with config issues, as
well as alternatives to xp_sendmail: http://www.aspfaq.com/2403
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Dan" <mcseman2002@.hotmail.com> wrote in message
news:OT1exV42DHA.2336@.TK2MSFTNGP09.phx.gbl...
services)
mail,
mailbox
what?
Environment:
Windows 2000 domain (2 x win2000 sp4 domain conrollers)
Exchange 5.5 running on winnt4.0 member server
SQL 2000 sp3 running on Windows 2000 member server.
I have SQL server running under domain administrator account (both services)
and Outlook 2000 on the same server profile set with the same account and
Exchange 5.5.
SQL agent is set to use that profile and also SQL mail (under support
services in SQL manager). When I test that profile it works OK. I can send
test mail to the operator and all my alerts can send mail fine.
Problem is, that my new application uses xp_sendmail procedure to send mail,
and it doesn't work. I get this error when running the procedure:
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80070005
I found an article Q293422 that descibes this problem but the solution did
not solve the problem. Besides, this article is about Exchange 2000 mailbox
and I'm using 5.5 mailbox.
I just managed to temporary fix this problem. I created new domain user in
AD and it's mailbox in Exchange 5.5. After seting SQL service, SQL agent
service, mail settings in Enterprise manager and new profile in Outlook to
use that new account, everything was working OK. xp_sandmail was working
too. But the next day same problem repaired. xp_sendmail reported same
errors again.
I suspect there are some security isues with SQL service account, but what?
Why is it working OK for one day and then stops the next?
Any ideas would be appreciated! Thanks.
DanSome links to KB articles and other resources helping with config issues, as
well as alternatives to xp_sendmail: http://www.aspfaq.com/2403
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Dan" <mcseman2002@.hotmail.com> wrote in message
news:OT1exV42DHA.2336@.TK2MSFTNGP09.phx.gbl...
quote:
> Hallo!
> Environment:
> Windows 2000 domain (2 x win2000 sp4 domain conrollers)
> Exchange 5.5 running on winnt4.0 member server
> SQL 2000 sp3 running on Windows 2000 member server.
> I have SQL server running under domain administrator account (both
services)
quote:
> and Outlook 2000 on the same server profile set with the same account and
> Exchange 5.5.
> SQL agent is set to use that profile and also SQL mail (under support
> services in SQL manager). When I test that profile it works OK. I can send
> test mail to the operator and all my alerts can send mail fine.
> Problem is, that my new application uses xp_sendmail procedure to send
mail,
quote:
> and it doesn't work. I get this error when running the procedure:
> Server: Msg 18025, Level 16, State 1, Line 0
> xp_sendmail: failed with mail error 0x80070005
> I found an article Q293422 that descibes this problem but the solution did
> not solve the problem. Besides, this article is about Exchange 2000
mailbox
quote:
> and I'm using 5.5 mailbox.
> I just managed to temporary fix this problem. I created new domain user in
> AD and it's mailbox in Exchange 5.5. After seting SQL service, SQL agent
> service, mail settings in Enterprise manager and new profile in Outlook to
> use that new account, everything was working OK. xp_sandmail was working
> too. But the next day same problem repaired. xp_sendmail reported same
> errors again.
> I suspect there are some security isues with SQL service account, but
what?
quote:
> Why is it working OK for one day and then stops the next?
> Any ideas would be appreciated! Thanks.
> Dan
>
>
Subscribe to:
Posts (Atom)