Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

stsadm migrateuser Error

  Asked By: Bahadur    Date: Nov 01    Category: Sharepoint    Views: 2625

When running the stsadmin migrateuser command we are getting the error "Unable
to connect to database. Check database connection information and make sure the
database server is running". We have been running this command for months
without issues and now it appears it's having a issue with authentication to the
SQL Server. We have verified that the service account has the correct
permissions and can authenticate to SQL Server and all WFEs using the service
account. All sites are running without issues using the service account.

Any ideas what could be causing this issue?



3 Answers Found

Answer #1    Answered By: Abinav Basu     Answered On: Nov 01

"Unable to connect  to database" usually happens for three reasons:
a. The SQL server database  is offline
b. authentication  has failed
c. Network issues

It seems that you have already done the first two; so I would check  to see how
my connection  was to SQL. Try connecting using the SQL client from the machine
you are running  STSADM. Try running the command  from a different server  and see
if you get the same error. Did the SQL server log an authentication failure?
If so, try using a different account  with the appropriate access.

Answer #2    Answered By: Teresa Simpson     Answered On: Nov 01

We've successfully accessed the database  from Enterprise manager using the
service account. We are running  the command  from production, using a different
service account, and don't have any issues. We have two WFE's and have the
issue on both servers.

Could there be an issue  with ports? Does anyone know what port the stsadm  uses?

We will check  with the SQL DBA's and see if any errors are reporting.

Answer #3    Answered By: Robby Barr     Answered On: Nov 01

Any chance that a Microsoft update has made your DB server  too secure? Is
it possible that EM is using one protocol and SP is using the other (which
may be disabled on the server)?

Didn't find what you were looking for? Find more on stsadm migrateuser Error Or get search suggestion and latest updates.