SQL Server 2012 Express - Login falied for User.. SOLVED
Posted: 10 Oct 2017, 02:04
Greetings,
Getting a little further on using SQL Server to store the essential repository so for the benefit of others trying, wanted to share and start a new topic. I am now getting the following error:
"The Driver was found but it is not possible to create a connection with the driver URL. Perhaps the URL Syntax is wrong or the username/password is invalid.
Login failed for user 'essential' ClientConnectionId:937ce712.58d6-xxxx...."
The URL syntax is: jdbc:sqlserver://localhost:51934;databaseName=essentialdb
When i change the port number to let's say 4133, I get "connection refused" so I am pretty sure I am connecting to the localhost and port. I have given the db user 'essential' full admin authority to the essentialdb and schema I have created and yet still have this issue.
Below are the screenshots I am hoping will help someone help me solve this issue so I can proceed with this multi-user install.
Any help is appreciated. Thanks,
David
Unfortunately my 3mb worth of images are too large to attach.. if there is some other way to share please let me know. Thanks.
Getting a little further on using SQL Server to store the essential repository so for the benefit of others trying, wanted to share and start a new topic. I am now getting the following error:
"The Driver was found but it is not possible to create a connection with the driver URL. Perhaps the URL Syntax is wrong or the username/password is invalid.
Login failed for user 'essential' ClientConnectionId:937ce712.58d6-xxxx...."
The URL syntax is: jdbc:sqlserver://localhost:51934;databaseName=essentialdb
When i change the port number to let's say 4133, I get "connection refused" so I am pretty sure I am connecting to the localhost and port. I have given the db user 'essential' full admin authority to the essentialdb and schema I have created and yet still have this issue.
Below are the screenshots I am hoping will help someone help me solve this issue so I can proceed with this multi-user install.
Any help is appreciated. Thanks,
David
Unfortunately my 3mb worth of images are too large to attach.. if there is some other way to share please let me know. Thanks.