Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kevin Graves]

?

Good Afternoon,
We are having problems to connecting to the SQL Server through the Dynamics NAV 2018 Development Environment. We have Dynamics NAV 2018 running and able to change different companies. I can even make an ODBC user DSN connection the NAV server. In Dynamics NAV Development I can input the Server Name and username and password with Database server Authentication but it still will not show the Database name.
Is anyone experience this same problem? Thanks for your help.

——————————
Kevin Graves
Benada Aluminum Products LLC
Sanford FL
——————————

[Cynthia Priebe]

Check SQL user permission.  To work with a particular Microsoft Dynamics NAV database through development environment, grant the user db_owner role on the database in SQL Server Management Studio. 

Please let me know if this resolves the issue.

——————————
Cynthia Priebe, MCTS, DCP
Senior Business Analyst and Project Manager
Liberty Grove Software
——————————
——————————————-

[Kevin Graves]

Hello Cynthia,
Thanks for getting back so soon. I try the grant the user db_owner role but still nothing. There is one thing when I open the Dynamics NAV Development then open Database and when I enter the name of the Server that is has the database on. I click on the up arrow in the box it comes up blank under the Available Microsoft SQL Server. Is there something we miss when install the Dynamics NAV? Thanks again for your help.

——————————
Kevin Graves
Benada Aluminum Products LLC
Sanford FL
——————————
——————————————-

[Suresh Kulla]

Is this a demo database? Have you tried using Windows Authentication when connecting?

——————————
Thanks
Suresh Kulla
NAV Technical Architect
ArcherPoint Inc.
Atlanta GA
——————————
——————————————-

[Kevin Graves]

Suresh,
It is the live database. I have try both the windows authentication and database server authentication. Is there another connection we are missing? Thanks for your help.

——————————
Kevin Graves
Benada Aluminum Products LLC
Sanford FL
——————————
——————————————-

[Suresh Kulla]

Kevin,

Verify your DB information by opening you NAV Administration Tool and select the Instance which you are connected and view the Database Server, Instance, and Name. 
Are you connecting to the same DB server, Instance?

——————————
Thanks
Suresh Kulla
NAV Technical Architect
ArcherPoint Inc.
Atlanta GA
——————————
——————————————-

[Geovanny Fuentes]

I agree with Suresh Kulla, make sure several factors.
Is the Windows machine visible to the Domain.
Is SQL visible to other apps (Jet report), etc.
Have you tried running it from the Server where the SERVICE is installed?
Last make sure you are connecting to the right SQL box, use the full name \DomainSQLbox.
Last try accessing via a SQL Admin to see if you can actually have accessibility (Log into windows with this account) and confirm. 
Does the Server Name appear when you do a lookup (Open Database)?

Good luck, 

——————————
Geovanny Fuentes
San Diego CA
——————————
——————————————-

[Alex Chow]

Can you post a picture of the screenshot in the Dev. Environment on how you’re trying to connect?

——————————
Alex Chow
Dynamics NAV MVP
AP Commerce
Los Angeles CA
Blog: http://www.dynamicsnavconsultant.com
——————————
——————————————-

[Gino Pack]

Kevin – 

I had the same issue when attempting to connect to my new NAV2016 database. It was one of these two resolutions:

• Make sure that Windows Firewall (if turned on) is configured to let the proper SQL and NAV server ports through.

• Make sure your SQL Server Browser service is running. 

Below is a link to a help document from MSDN:
https://msdn.microsoft.com/en-us/library/dd983822(v=nav.90).aspx

Let us know if either of these help!

Gino

——————————
Gino Pack
Director of Information Systems
Modern Optical International
ROSELLE IL
——————————
——————————————-