I am having a problem with HQ Admin after upgrading to SQL Server Express on my HQ Server computer (running 1.3R). HQ Admin works fine in all respects from this computer. However, when I try to run HQ Admin from any other computer on the network I get this error when I try to connect:
To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects(SMO)
I can run HQ manager and enter the configuration fine. However, I am restricted from connecting (so I can't run SQL queries). Any ideas?
Apparently I am not alone... I found this old post on Google Groups, but did not find an answer:
Newsgroups: microsoft.public.pos From: Tad L Date: Thu, 8 Mar 2007 16:37:03 -0800 Local: Thurs, Mar 8 2007 8:37 pm Subject: SQL problems with 2.0 This is a weird database problem that has occured since upgrading to 2.0 -
We have been running 2.0 for a couple weeks now. Today I decided to look more into my backup problem and try some other things. So I open Administrator on my desktop, and try to "connect" to my database - It gives me an error "To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects(SMO)." If I put in the wrong password, it of course says "Login failed for user 'sa'".
Now if I go into "configuration" and click the "test database connection" button, it connects fine. Manager works fine as well. This is true for all my machines -
Now - we did install 2.0 on a test machine for a couple days before doing the whole store - on that machine my partner installed some additional SQL tools, and when I try the above tests there, I can "connect" to the database from Administrator without a problem. But if I try to run the backup utility from Administrator, I get this error message -
"Backup of file or filegroup "sysft_itemlookup" is not permitted because it is not online. BACKUP can be performed using the FILEGROUP or FILE clauses to restrict the selection to include only online data. Backup of file or filegroup "sysft_subitems" is not permitted because it is not online. BACKUP can be performed using the FILEGROUP or FILE clauses to restrict the selection to include only online data. BACKUP DATABASE is terminating abnormally."
This is the same message I get on my other machines when I try to run the Backup from Manager -
The database is running on a SBS2003 server, all machines XP PRo, everything up to date - All I want to do is backup my database simply and cleanly - Any ideas?? Please????