|
| | | Forum Newbie
Group: Forum Members
Last Login: 2/11/2008 8:01:20 AM
Posts: 3, Visits: 11 |
| | Hi I'm running Whatsup Pro 2006 in our school district. Yesterday I stopped getting notification from What's UP. When I got checking I got a database connection error. Database connection error. Error=80004005 ErrorMessage=Unspecified error Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'WhatsUp'. Login fails. Nothing's been changed on the system that I'm aware off. All of sudden I can't open What's UP. I have spent pretty much all day reading the forum here but have yet found a solution to my problem. I have tried to shrink my MSDE database, but this fail. Since I couldn't connect to the database I couldn't shrink it down. I know numerous people have had similiar problem, but the solutions I have tried have been unsuccessful. Thanks for any help. Nhia |
| |
| | | Time Traveler
Group: Ipswitch Employees
Last Login: Today @ 11:59:55 AM
Posts: 171, Visits: 778 |
| | Have you Verified that the MSSQL$WhatsUP service is running? Another thing to check is to check if you can connect from the DSN properties dialog. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/11/2008 8:01:20 AM
Posts: 3, Visits: 11 |
| | Thanks Ambark, I have verified that MSSQL$Whatsup service is running. I can not connect to the whatsup database from the DSN properties. It's saying that the database entered is not valid. Nothing's been change to the database. Only thing I know for sure is that the database has grown beyond the 2GB limit for MSDE. Possible database is corrupt? If so, how do I confirm and know for sure? Nhia |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/28/2008 4:21:20 PM
Posts: 3, Visits: 10 |
| | i've been receiving the same error since i installed the WhatsUp 2006 pro. edition. i checked the 800445 error code. some says it indicates the access error. however, it doesn't make sense since i installed and run the program under domain admin acct. so far, everything seems running OK, however, ism not sure what i miss out with this error.
TIA  |
| |
| | | Time Traveler
Group: Forum Members
Last Login: 10/6/2008 10:25:48 AM
Posts: 534, Visits: 1,880 |
| nly (2/8/2008)
Thanks Ambark, I have verified that MSSQL$Whatsup service is running. I can not connect to the whatsup database from the DSN properties. It's saying that the database entered is not valid. Nothing's been change to the database.
Only thing I know for sure is that the database has grown beyond the 2GB limit for MSDE.Possible database is corrupt? If so, how do I confirm and know for sure?
Nhia
Growing above 2GB is the issue, you have to reduce your DB size or move to SQL Server.
however, it doesn't make sense since i installed and run the program under domain admin acct.
That's very unwise. Why did you decide to run it as a domain admin ? There are very few cases that would require so. |
| |
| | | Time Traveler
Group: Ipswitch Employees
Last Login: Today @ 11:59:55 AM
Posts: 171, Visits: 778 |
| | As MB_NS said, going above 2GB is the real problem. MSDE has a limitation of 2 GB per database and you will have to move to a "full" MS SQL Server in order to go beyond the 2 GB size limit. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/11/2008 8:01:20 AM
Posts: 3, Visits: 11 |
| | I understand about the 2GB. But how do you go about reducing it? I've tried reducing the database using the command line osql -E -D WhatsUp -Q "DBCC SHRINKDATABASE (WhatsUp)" But can't login still. I'm getting an error stating that "cannot open database requested in login 'whatsup'. Login fails. Thanks for looking at this. Nhia |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 2/28/2008 4:21:20 PM
Posts: 3, Visits: 10 |
| | to troubleshoot, I installed and run the program under domain admin since some Google search suggested the error code to access error. I totally agree with you - it's unwise to use DomainAdmin acct.
TIA |
| |
| | | Junior Member
Group: Forum Members
Last Login: 11/11/2008 10:49:21 AM
Posts: 10, Visits: 36 |
| Hi there!
I have the same problem now:
After the database reached the limit of 2GB (full), now I'm getting the error message:
"Cannot open database requested in login 'WhatsUp'. Login fails"
I got the database smaller by copying the MDF file to another SQL Server 2005 instance in another computer, attaching it, and shrinking, and then moving it back to the WUP server...
But no luck, still getting the same error message even though the database size is not the problem now.
Any ideas?
Thanks!
KNX |
| |
| | |
|