Setup could not connect to the database server

(0) Share

Report

Posted on by Community Member

Hi,

I am currently installing AX 2012 R2 on 1 server and connecting it to a database server when i encounter the error below.

I tried different solution such as:

1. Off firewall of both server

2. Check TCP/IP and Name pipes if enabled

3. Ping both server

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

Did you try to connect SQL server with your used credentials? Make sure you have access to that SQL instance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes Sir, i have checked the credentials and it has the right access.

Was this reply helpful? Yes No
Suggested answer

Nagendra Varma K on at

Like (0)

Report
Copy link

Link copied!

Hi Mari,

Refer here

community.dynamics.com/.../148101

Thanks

Nagendra Varma K

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sir Nagendra i already tried those in the link and it is still not working. it is so weird it has no effect because the server is newly formated.

Was this reply helpful? Yes No
Suggested answer

Nagendra Varma K on at

Like (0)

Report
Copy link

Link copied!

Hi Mari,

Is the name you mentioned server name including domain ?, can you double check re-start both the servers disable both firewall & check the whether you can ping & than try to run .exe files also make sure your login has admin privileges.

Thanks

Nagendra varma K

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes Sir Nagendra, i already restarted both server, my domain account is administrator,, both firewall are already off and both server connects when ping.

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

Also try to create a DSN and see if you can connect. We will figure it out if that is connectivity issue or something wrong with AX setup.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

restart sql server browser services and check again

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sir,

Why only the specific database that i cant connect, some other database can connect and can be seen.

Was this reply helpful? Yes No
Suggested answer

Maciej Krzysztofik 290 on at

Like (0)

Report
Copy link

Link copied!

Sometimes when You use named instance (verify that You used correct instance) instead of Default AOS setup cannot find the database. If You can try to use default instance, if not, please try to input the database server and database name by hand without trying to "find" it.

Also, verify if AX database is installed on that server prior to installation of AOS. You have to first deploy the database, with everything else afterwards. Verify if Your domain user have rights to access this server and database (for test purpose i suggest giving it DBA rights).

Was this reply helpful? Yes No