Problems with SQL communications over ISDN
We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a significant increase [...]

Answer Question   |  March 24, 2010  11:39 AM
ISDN, MSDE, SQL Server, Windows NT, Windows XP Professional

MSDE for adminDB
Ever since I installed Diskeeper Administrator 2009 on my PC (it runs XP Pro, svc pk 3), every time I print something, I get some “MSDE for AdminDB” pop-up that says “Setup has detected that your current SA password is set to blank. Please use sp_password to set a strong SA password and restart setup [...]

Answer Question   |  March 1, 2010  8:27 PM
BLANKSAPWD, Diskeeper, Diskeeper Administrator 2009, MSDE, MSDE for AdminDB, SA password

MSSQL service SQL service icon in the system tray does not have a green arrow on it
I know Windows Sharepoint services with Windows Server 2000 installs SQL MSDE by default and the installation of same occurred successfully but how come afterwards the SQL service icon in the system tray does not have a green arrow on it instead it has a white filled-in circle and when I launch it the server [...]

Answer Question   |  July 24, 2008  5:30 AM
MSDE, SharePoint, SQL Server installation, Windows 2000 Server

SQL Server 2000 backup failed
can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database ‘CP2005′. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N’C:fjs1education_db_200801080954.BAK’ WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 2008-01-08 10:19:18.34 backup BACKUP failed to complete the command [...]

Answer Question   |  February 22, 2008  6:51 PM
MSDE, SQL Server 2000, SQL Server 2000 Desktop Engine