SQL Viewer: MSSQL Connection Error

Post your questions and problem reports here

Moderator: kfury77

Forum rules
Please try to follow these guidelines. This will help to receive faster and more accurate response.

  • Check the Support section of the corresponding product first. Chances are you will find your answer there;
  • Do not create new topics for already reported problems. Add your comments to the existing topics instead;
  • Create separate topic for each problem request. Do NOT post a number of non-related problem reports in a single topic;
  • Give your topic a meaningful title. Titles such as "A question," "Bug report" and "Help!" provide others no clue what your message is about;
  • Include the version number of the software you are using;
  • This is not an official customer support helpdesk. If you need a prompt and official response, please contact our support team directly instead. It may take a while until you receive a reply in the forum;

SQL Viewer: MSSQL Connection Error

Postby jcapp » Wed Sep 24, 2014 6:32 pm

I get the error:

"SQL Error: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request."

when trying to view, or run queries against server in SQL Viewer.

I have no error when connecting normally through web page but through the SQL Viewer I get the error. Any ideas why?

Using WeBuilder v12.3.0.152

MS SQL Server version 2008 (with direct access allowed)
jcapp
 
Posts: 2
Joined: Wed Sep 24, 2014 6:25 pm

Re: SQL Viewer: MSSQL Connection Error

Postby Aivars » Wed Sep 24, 2014 9:17 pm

I don't have MS SQL Server 2008 installed currently but make sure that all connection parameters are correct. If you think it might be a problem in WeBuilder try another SQL client (besides PHP) and see if that works, to make sure and let us know.
Blumentals Software Programmer
User avatar
Aivars
Blumentals Software Developer
 
Posts: 2456
Joined: Thu Aug 22, 2002 1:40 pm
Location: Latvia

Re: SQL Viewer: MSSQL Connection Error

Postby jcapp » Wed Sep 24, 2014 10:02 pm

I tried using the same credentials with Microsoft Server Configuration Manager Express 2008, and worked fine. It seems like it is getting the credentials because when i don't have the right information, it says "SQL Error: could not connect to the server: Connection timed out."
jcapp
 
Posts: 2
Joined: Wed Sep 24, 2014 6:25 pm

Re: SQL Viewer: MSSQL Connection Error

Postby Aivars » Thu Sep 25, 2014 10:16 am

I'll add this to bug reports but I'm not sure when it will be verified and fixed if needed because we don't have a test SQL Server available currently.
Blumentals Software Programmer
User avatar
Aivars
Blumentals Software Developer
 
Posts: 2456
Joined: Thu Aug 22, 2002 1:40 pm
Location: Latvia


Return to HTMLPad / Rapid CSS / Rapid PHP / WeBuilder Support

Who is online

Users browsing this forum: No registered users and 29 guests

cron