Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-02 : 13:16:26
|
| andy writes "i have a number of prototype web projects at work on an NT4 sp5 server running iis4 and connecting to SQL server 6.5. each of these uses a DSN-less connection to connect the asp pages to their respective databases they have been working fine for weeks, and in some cases months - and then i had a week off i came back today to find that none of them connect correctly some just report 8004005 unspecified error others report Login failed- User: Reason: Not defined as a valid user of a trusted SQL Server connection also, i have been looking in the application event log and have found that SQLServer keeps reporting that the parameter the number of open objects / open databases is set too low... i have used sp_configure (tho' i'm not sure correctly) as the event warnings suggested to up the parameter values, the warnings have stopped in the app log, but it has made no difference why would they suddenly stop working??!another wierd tho' possibly unrelated occurance is that other users (who don't have administrative permissions) have found themselves locked out of areas of the intranet they could previously access. i suspect tampering with permissions... any advice greatly appreciated" |
|
|
|
|
|
connections suddenly not working