Home / Q&A / Unable to establish connection to MS SQL express
You can translate the question and the replies:

Unable to establish connection to MS SQL express

Related to: Accessing MS SQL Server using Windows Authentication
Receiving the following error when trying to establish a Denodo 7 connection to MS SQL express (Windows 10, MS SQL version 14.0.2002.14): Unable to establish connection: Cannot open database "MAXXPHASE" requested by the login. The login failed. ClientConnectionId:70f875c2-e30f-418f-9da4-b0a466d5f73f Denodo and MS SQL are running on a laptop to provide a portable demo of the capabilites. Other Info: 1) Port 1433 is enabled on both the server and in Denodo's configuration 2) MS SQL Remote connection is enabled 3) MS SQL Browser is running 4) DB Adapter: Microsoft SQL Server 2016 (MS Driver) 5) Driver class path: 'mssql-jdbc-6.x' 6) Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver 7) Driver URI: jdbc:sqlserver://RAJ-LAPTOP;IntegratedSecurity=true;DatabaseName=MAXXPHASE 8) Transaction isolation: Database default 9) Authentication: User login and password
MSSQL Error
user
01-04-2019 11:18:27 -0400

1 Answer

Hi, I was able to reproduce your scenario. The error **Unable to establish connection: Cannot open database** could have occurred due to various reasons such as: * The database ‘MAXXPHASE’ no longer exists in Microsoft SQL Server. * The user connecting does not have the necessary privileges to connect to the particular database. I’d suggest you to try using the valid database name in the connection URI and provide the correct login details. For more details, you can have a look at a similar Community Q&A [here](https://community.denodo.com/answers/question/details?questionId=9060g00000009zpAAA&title=Unable+to+connect+to+Microsoft+SQL+Server+2012). Hope this helps!
Denodo Team
02-04-2019 01:46:36 -0400
You must sign in to add an answer. If you do not have an account, you can register here