Quantcast

FW: JDBC connection issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

FW: JDBC connection issue

gandhiatish7791

Hi,

Also if there is a facility of online chat please let me know.

Thank You.

 

Sent from Mail for Windows 10

 

From: [hidden email]
Sent: 30 April 2017 05:38 PM
To: [hidden email]
Subject: JDBC connection issue

 

Hi,

I am Atish Gandhi. I currently stay in Mumbai, India. I am currently working as SSIS package developer and am totally new to Java.

 

I am trying to connect to SQL server 2016 through Netbeans but am getting following error :

 

Cannot establish a connection to jdbc:sqlserver://GANDHI-HP-LAPTO\PRACTICESERVER;databaseName=PRACTICEDB using com.microsoft.sqlserver.jdbc.SQLServerDriver (The server practiceserver is not configured to listen with TCP/IP.)

 

The details are as follows :

The server name is GANDHI-HP-LAPTO\PRACTICESERVER. I have made 2 logins :

 

1. Using Windows Authentication :The database PracticeDB was created through this login - GANDHI-HP-LAPTO\Atish

cid:image001.png@01D2C1D6.EE0569E0

 

2. Using SQL server authentication : The database JavaDB was created through this login - JavaConnectionLogin

cid:image001.png@01D2C1D6.EE0569E0

 

But when I tried connecting to SQL server through Netbeans I get following error :

1. Through Windows authentication :

 

Cannot establish a connection to jdbc:sqlserver://GANDHI-HP-LAPTO\PRACTICESERVER:1433;databaseName=PracticeDB using com.microsoft.sqlserver.jdbc.SQLServerDriver (Login failed for user ''. ClientConnectionId:63cd9533-d701-4d29-8653-ed6dcfcd872d)

 

cid:image002.png@01D2C1D6.EE0569E0

 

2. Through SQL server authentication :

 

Cannot establish a connection to jdbc:sqlserver://GANDHI-HP-LAPTO\PRACTICESERVER:1433;databaseName=JavaDB using com.microsoft.sqlserver.jdbc.SQLServerDriver (Login failed for user 'JavaConnectionLogin'. ClientConnectionId:9fae90fa-4a0e-43ed-8578-5ffcf860b0c4)

 

cid:image003.png@01D2C1D6.EE0569E0

 

Now I have tried all possible solutions available on Google like

1. Writing . or localhost or 127.0.0.1 (instead of GANDHI-HP-LAPTO) in host field.

2. Writing dynamic port number instead of 1433 or leaving the Database field blank

3. Writing sqlexpress instead of PRACTICESERVER in Instance name field

4. Adding (or editing) path and classpath variables in environment variables.

5. Changing default values for TCP/IP properties in Protocols at several places for PRACTICESERVER and SQLEXPRESS in SQL server configuration manager

6. Changing login properties (as shown in 1st 2 images) and database properties

 

I am also attaching all types of errors that I have got by trying different solutions. I am currently stuck at the last error in the file. Now if I change the listen all value to yes then the service does not start :

cid:image004.png@01D2C1D8.6777D910

 

I am stuck at this point for 3 days. Can you please help me out. If possible could we connect through TeamViewer or Anydesk.

     Thanks & Regards,

                Atish Gandhi.

 

Sent from Mail for Windows 10

 

 

https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif

Virus-free. www.avast.com

 

 

Loading...