Can't get a connection to my SQL Server instance

Submitted by Diamans on Thu, 08/15/2013 - 15:23
It seems, that WebMaker is looking for port 1434 on the server.
However, it listens on port 1433 and I can't seem to change that in WebMaker?

I have connections running from other software with the used credentials, so I am sure that the credentials are correct and the database server is running. However, the connection string might not be correct:

jdbc :s qlserver://DELL1\SQLEXPRESS\;databaseName=AHUren;

DELL1 is our database server on the network.

Any suggestions?

Hi There

The following link might help:
http://technet.microsoft.com/en-us/library/ms378428.aspx

I think the syntax is:
jdbc :s qlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

In your case you can try:
jdbc :s qlserver://DELL1\SQLEXPRESS:1443;databaseName=AHUren

or just this:
jdbc :s qlserver://DELL1:1443;databaseName=AHUren

Regards
Abdul


Hi There

The following link might help:
http://technet.microsoft.com/en-us/library/ms378428.aspx

I think the syntax is:
jdbc :s qlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]

In your case you can try:
jdbc :s qlserver://DELL1\SQLEXPRESS:1443;databaseName=AHUren

or just this:
jdbc :s qlserver://DELL1:1443;databaseName=AHUren

Regards
Abdul


A few things to this:

[1] This surely was the FASTEST response I have EVER seen on ANY support forum! Compliments! I am impressed...

[2] I have the connection running using the port parameter as suggested (and after modifying some stuff on the server).

Thank you very much Abdul. I suppose we will need to bother you quite a few times in the near future...... :D

We use cookies and analytics on our website to support technical features that enhance your user experience.

-