Having trouble with SQL Server connection on WebSphere 8.5 -

-

i'm having kinds of trouble getting ibm websphere 8.5 connect sql server 2012 data source. have url of jdbc:sqlserver://localhost;username=user;password=password. see following error (i know it's kind of long):

the test connection operation failed data source reachingrecovery on server server1 @ node mweiss7x16node01 following exception: java.sql.sqlexception: tcp/ip connection host localhost, port 1433 has failed. error: "connection refused: connect. verify connection properties. make sure instance of sql server running on host , accepting tcp/ip connections @ port. make sure tcp connections port not blocked firewall."

now, sql server , websphere running on same machine, don't think it's firewall issue. i've checked sql server properties under "connections", , indicates fine ("allow remote connections server" checked.)

i'm @ loss understand why happening. suggestions? thx mimi

i found out problem was. using sql server management studio check on whether make tcp/ip connections or not. should have been using sql server configuration manager. had thing on left called "sql server network configuration". clicked on that, , brought "protocols server instance name". had thing on right (tcp/ip), indicated disabled. enabled that, restarted sql server, , worked.


Comments

Post a Comment

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

-
i trying build project, run in debug mode , keep getting "synchronizing output directories" in intellij. takes around 5-10 minutes actual build. project empty , stored on local drive. tried invalidate catche has not worked. out of ideas .. had similar issues? most likely, of data on network drive or in profile being synchronized network drive. if on windows, try moving .ideaxxx/system directory , work directory somewhere else on c: drive.
Read more

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original
Read more