web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / 9829000 Error -3: Alte...
Microsoft Dynamics SL (Archived)

9829000 Error -3: Alter failed for Server '%1'

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

i got this error "9829000 Error -3: Alter failed for Server '%1'" when trying to connect to Dynamics SL 2011 (OS: Windows Server 2012, SQL Server 2012) from Database Maintenance Screen (98.290.00) (Client OS: Windows 7)

Can some1 help me so i can connect to the server??

Thx in advanced for your valuable answer

 

Best Regards,

Darwanto

*This post is locked for comments

I have the same question (0)
  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at

    Hi Darwanto,

    I would first try going to administrative tools > Data Sources (ODBC) and delete any existing ODBC connections for the SL databases.  Also, ensure that if you are using Windows Authentication (this can be determined by going to SQL Server Management studio and running "getauthenticationtype" without quotes against your system DB) that the user you are logged into Windows as is associated to an SL login.

  • Community Member Profile Picture
    Community Member on at

    Hi Adam,

    Thx for your reply.

    I tried to delete all my ODBC connection on the client's pc, but still got the same error.

    I check the Client's windows login is not same as server's windows login, but i still can connect the SQLServer 2012 from Client's SQL Server Management Studio using the SA.

    But the weird thing is, i can connect to SL 2011 Server without open the Database Maintenance Screen (on Find Database screen (98.000.01) i just type the servername and it will get all the SL DB Name). The problem is i can't process the Update Database, Sync Ownership or reset SYSADMIN password from the client side.

     

    Thx & Regards,

    Darwanto

  • Nathan Benedicto Profile Picture
    Nathan Benedicto 115 on at

    Hi Darwanto,

    Were you abel to solve your problem?  I am having the same issue.

    Thanks.

  • Community Member Profile Picture
    Community Member on at

    Hi Nathan,

    The problem unsolved till now.

    I can't connect to server via client's Database Maintenance.

    So, if i want to use Database Maintenance, i will connect it from the server side.

    Regards,

    Darwanto

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans