Connect Crystal Report to Database via ODBC

Question

I am trying to connect Crystal Report via ODBC; when I am about to create a new DSN source it won't work and below error popped up:

---------------------------

Microsoft SQL Server Login

---------------------------

Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

---------------------------

OK   

---------------------------

Answer 1

SQL Server does not exist or access denied.

I would say: As the message says.
Sure you entered the right SQL Server (instance) name?

Answer 2

Hi @Juliana Zhou ,

＞＞[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

According to the error message, please make sure SQL Server Service is running. If a named instance, make sure SQL Server browser service is running. Make sure the instance name is spelled correct in server box and there is actually such an instance on your machine.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

I don't know why - I tried another SQL account - the connection is complete. However, the both of them can connect the database through SSMS.

Answer 4

This has been addressed;

It's simply the issue of user name's case-sensibilities.