You’re offline. This is a read only version of the page.
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
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
Hi Darwanto,
Were you abel to solve your problem? I am having the same issue.
Thanks.
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
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.
Share
Report
All responses (
Answers (
115