https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 11:59:43 +0000 Wed, 21 Nov 2007 15:43:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24860 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sql-error_topic24860_post129526.html#129526 Author: Flapjack
Subject: 24860
Posted: 21 November 2007 at 3:43pm

Sure enough, the box was checked.  I unchecked it. 

Hopefully this thread will help someone else in the future.  Thanks for all the help.
]]> Wed, 21 Nov 2007 15:43:32 +0000 https://forums.webwiz.net/sql-error_topic24860_post129526.html#129526 https://forums.webwiz.net/sql-error_topic24860_post129522.html#129522 Author: WebWiz-Bruce
Subject: 24860
Posted: 21 November 2007 at 8:23am

Sounds like then the password expired.

In SQL Server Management Studio right click on the user and select 'Properties'., then in the 'General' sreen make sure that 'Enforce Password Expiration' is not checked, as for some reason this is checked by default if you do not uncheck it when creating a user in SQL Server.

If you do not do this then I would imagine you will have the same issue again in a month or so when the password expires again.
]]> Wed, 21 Nov 2007 08:23:02 +0000 https://forums.webwiz.net/sql-error_topic24860_post129522.html#129522 https://forums.webwiz.net/sql-error_topic24860_post129520.html#129520 Author: Flapjack
Subject: 24860
Posted: 20 November 2007 at 7:44pm

Fixed it.  I checked under Database_connection.asp and made note of the password for the SQL user running the db.  The password had not changed, but I re-entered the user password in the SQL management console, just in case.  That did the trick.

Now to figure out how that password got changed, and to make sure it doesn't happen again. 
]]> Tue, 20 Nov 2007 19:44:22 +0000 https://forums.webwiz.net/sql-error_topic24860_post129520.html#129520 https://forums.webwiz.net/sql-error_topic24860_post129518.html#129518 Author: Flapjack
Subject: 24860
Posted: 20 November 2007 at 7:35pm

Argh... the MDAC reinstallation didn't help, either.  I'm starting to be really irritated here.

I keep coming back to what could've broken it in the first place.  The only thing that changed on the server was MSFTP being installed.  We've uninstalled it (not that we should need to), and restarted the box.  Still no change.

Is there anywhere else I should be looking besides SQL?  Are you 100% that is the issue?  
]]> Tue, 20 Nov 2007 19:35:14 +0000 https://forums.webwiz.net/sql-error_topic24860_post129518.html#129518 https://forums.webwiz.net/sql-error_topic24860_post129517.html#129517 Author: Flapjack
Subject: 24860
Posted: 20 November 2007 at 7:16pm

Ok, just tried that, but it didn't make a difference.  Also, SQL Server is running, but SQL Server Browser is not.  Actually, I'm not sure if it ever has.  Should I have that running also?

Gonna try reinstalling MDAC database drivers right now.  Do you know if adding an FTP site to IIS could have caused this issue?  

-boRg- wrote: 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.

]]> Tue, 20 Nov 2007 19:16:07 +0000 https://forums.webwiz.net/sql-error_topic24860_post129517.html#129517 https://forums.webwiz.net/sql-error_topic24860_post129516.html#129516 Author: WebWiz-Bruce
Subject: 24860
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.
]]> Tue, 20 Nov 2007 19:06:29 +0000 https://forums.webwiz.net/sql-error_topic24860_post129516.html#129516 https://forums.webwiz.net/sql-error_topic24860_post129514.html#129514 Author: Flapjack
Subject: 24860
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?  

-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.

]]> Tue, 20 Nov 2007 19:00:14 +0000 https://forums.webwiz.net/sql-error_topic24860_post129514.html#129514 https://forums.webwiz.net/sql-error_topic24860_post129513.html#129513 Author: WebWiz-Bruce
Subject: 24860
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.]]> Tue, 20 Nov 2007 18:50:21 +0000 https://forums.webwiz.net/sql-error_topic24860_post129513.html#129513 https://forums.webwiz.net/sql-error_topic24860_post129511.html#129511 Author: Flapjack
Subject: 24860
Posted: 20 November 2007 at 6:33pm

-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?  
]]> Tue, 20 Nov 2007 18:33:33 +0000 https://forums.webwiz.net/sql-error_topic24860_post129511.html#129511 https://forums.webwiz.net/sql-error_topic24860_post129510.html#129510 Author: Flapjack
Subject: 24860
Posted: 20 November 2007 at 6:25pm

-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.  
]]> Tue, 20 Nov 2007 18:25:30 +0000 https://forums.webwiz.net/sql-error_topic24860_post129510.html#129510