Showing posts with label correctly. Show all posts
Showing posts with label correctly. Show all posts

Wednesday, March 21, 2012

Help on #911 Cant locate entry in sysdatabases...

Could not locate entry in sysdatabases for database 'TEST'. No entry found with that name. Make sure that the name is entered correctly.

I got the above error from time to time and like to do some troubleshooting and in vain...hope I can get some help or hints here...
Thanks a lot.

WDid you rename the database ? Which version of sql server are you using ? Is it your login that receives this error or other logins ?|||I have a new database and use it for a library server and through the installation program, it will create admin account on sql server for that database...at this point, I got the above error. I didn't do anything to the new database...

Can't see anything strange in Profiler...anyone out there can help?|||What are the details of the installation program/process ?

Sunday, February 19, 2012

Help me get MSDE SP3a installed on Win Server 2003

I've tried every which way I can from the docs and but I can't seem to get MSDE to install correctly. Found out that Win2003 only runs SP3a, downloaded and tried it.
tried these different commands from the prompt:
setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only)
setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first)
setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a)
Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager eithe
r.
What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up...
Thanks...
PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
addition: This is Win 2003 Server Standard Edition...