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;
Post Reply
jcapp
Posts: 2
Joined: Wed Sep 24, 2014 6:25 pm

SQL Viewer: MSSQL Connection Error

Post by jcapp »

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)
User avatar
Aivars
Blumentals Software Developer
Posts: 2462
Joined: Thu Aug 22, 2002 1:40 pm
Location: Latvia

Re: SQL Viewer: MSSQL Connection Error

Post by Aivars »

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
jcapp
Posts: 2
Joined: Wed Sep 24, 2014 6:25 pm

Re: SQL Viewer: MSSQL Connection Error

Post by jcapp »

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."
User avatar
Aivars
Blumentals Software Developer
Posts: 2462
Joined: Thu Aug 22, 2002 1:40 pm
Location: Latvia

Re: SQL Viewer: MSSQL Connection Error

Post by Aivars »

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
Post Reply