Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - SQL Error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL Error
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Flapjack View Drop Down
Newbie
Newbie


Joined: 07 September 2007
Location: United States
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Flapjack Quote  Post ReplyReply Direct Link To This Post Topic: SQL Error
    Posted: 20 November 2007 at 6:03pm
Not sure what happened.... but when I went to log onto our forum today, I got the following error message.  I tried restarting all IIS servers, and SQLEXPRESS, but no change...


Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 6:14pm
This is a problem with the connection to the database.

Check that the database connection details are correct and check that your SQL Server is allowing TCP/IP connections.

If it is running on a non local server, check that you have enabled remote connections as SQL Server Express has these disabled by default.

You should also note that SQL Express installs with the default instance 'SQLEXPRESS' which needs to be included in the connection string.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Flapjack View Drop Down
Newbie
Newbie


Joined: 07 September 2007
Location: United States
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Flapjack Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 6:15pm
The SQL server is on the same box as the forums.  It is internal only.  This is the first time we've had any issues. 

I'll look at the connection details now, though I'm not 100% sure what I'm looking for....  

Back to Top
Flapjack View Drop Down
Newbie
Newbie


Joined: 07 September 2007
Location: United States
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Flapjack Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 6:25pm
Originally posted by -boRg- -boRg- wrote:

You should also note that SQL Express installs with the default instance 'SQLEXPRESS' which needs to be included in the connection string.

Forgot to mention, this was exactly how it was set up.  There has been no issue until now.  
Back to Top
Flapjack View Drop Down
Newbie
Newbie


Joined: 07 September 2007
Location: United States
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Flapjack Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 6:33pm
Originally posted by -boRg- -boRg- wrote:

Check that the database connection details are correct and check that your SQL Server is allowing TCP/IP connections.

Am I doing this in the forums, or in the SQL Config Manager?  In SQL, TPC/IP connections are unchanged from the time I set it up (allowed).

As for the forums, I am unable to get into any page on them.  Is there a specific address I should use to check the SQL settings there, or do I have to manually edit a file in the directory?  
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 6:50pm
This is done in SQL Server. If as you mentioned earlier you reinstalled SQL Server you would need to enable TCP/IP connections in SQL Server, as they will go back to their default of not allowing these types of connections.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Flapjack View Drop Down
Newbie
Newbie


Joined: 07 September 2007
Location: United States
Status: Offline
Points: 32 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Flapjack Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 7:00pm
Not sure from where you thought I reinstalled SQL from, sorry if I wasn't clear.  The only thing that has been done to this server since the install of WWF/SQL/ASP is yesterday, our IT director installed MS FTP Server.  Not sure how that could've changed anything, but could it have affected IIS in some way??

Under SQL Server Configuration Manager, there is the following structure.  I tried enabling TCP/IP under SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS, but the message stayed the same.

Also, there are two areas where TCP/IP is defined:

SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS > TCP/IP  > Enabled

and...

SQL Native Client Configuration > Client Protocols > TCP/IP > Order 2, Enabled

Which connection are you referring to?  


Originally posted by -boRg- -boRg- wrote:

This is done in SQL Server. If as you mentioned earlier you reinstalled SQL Server you would need to enable TCP/IP connections in SQL Server, as they will go back to their default of not allowing these types of connections.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2007 at 7:06pm
Both should be enabled for 127.0.0.1 if SQL Server Express is installed on the localhost, at least thats how I always run it.

One option I don't know if you have tried yet is reinstalling the MDAC database drivers.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.