.:: CODE SNIPPET ::.

"Your time is limited, so don't waste it living someone else's life"

Config to connect to your SQLServer (for java)


Make a connection to database from java with IDE NetBean

  1. Create a new login account to your Sqlserver

Login to SQLServer by the Window Authetication account

Now, you create a account by select Securityà Logins (right click)àNew Login…

 

In the window,you enter a new account (above is “prmhuitedu”), and set the password for it.

Note: In Status tab (of above window) you choose

+ Permission connect to database engin : Grant

+ Login: Enable

Now, you set the security property for your server by opening the properties window

 

You will see this:

 

Choose the properties as the above picture, then select OK button.

You have just finnished establish a new login account

 

  1. Log in to SQLServer with the new log in

Sign out the Window Authentication account and log in  with SQL Server Authentication account

 

  1. Change the TCP/IP Port for the server

Open SQL Server Configuration Manager from your SQLServer Express Edition

 

Select Enabled for TCP/IP, then

 

Select IP Address tab

 

 

Scroll down to find IP All

Set the TCP Port 5530 to make all the TCP Ports to 5530 à OK

Now, you just restart the server by

 

(prmhuitedu)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: