|
Posted by Jason on June 21, 2007, 10:34 am
Please log in for more thread options
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
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????
|
|
Posted by Jeff @ Check Point Software on June 21, 2007, 11:58 pm
Please log in for more thread options
: quoted-printable
Jason,
Download and install the Backward Compatibility Component and the SQL =
Native Client from here; http://tinyurl.com/yumpyp
Follow the steps in this KB to correctly setup SQL2k5 =
http://tinyurl.com/2wk3ro
Must have access to CustomerSource
--=20
Regards,
Jeff Hobbs
Check Point Software
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your newsreader so =
that others may learn and benefit from your issue.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
I am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects=20
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=20
Server Management Objects(SMO)
I can run HQ manager and enter the configuration fine. However, I am=20
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=20
not find an answer:
Newsgroups: microsoft.public.pos
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=20
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=20
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 =
-=20
Any
ideas?? Please????
------=_NextPart_000_0562_01C7B446.F8D97620
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3DWindows-1252>
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Calibri"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true" =
acc_role=3D"text"=20
name=3D"Compose message area">
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Download and install the Backward Compatibility Component and the =
SQL=20
Native Client from here; <STRONG><A title=3Dhttp://tinyurl.com/yumpyp=20
href=3D"http://tinyurl.com/yumpyp">http://tinyurl.com/yumpyp</A></STRONG>=
</DIV>
<DIV> </DIV>
<DIV>Follow the steps in this KB to correctly setup SQL2k5 <A=20
title=3Dhttp://tinyurl.com/2wk3ro=20
href=3D"http://tinyurl.com/2wk3ro">http://tinyurl.com/2wk3ro</A></DIV>
<DIV> </DIV>
<DIV>Must have access to CustomerSource<BR>-- <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader so=20
that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the=20
file attachment(s). If you are not using a reader, follow the link =
below=20
to setup the above programs. Click on "Open with newsreader" under =
the MS=20
Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A title=3Dmailto:microsoft.public.pos@natureisle.com =
=
natureisle.com</A>>=20
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
<BR>my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects=20
<BR>from this computer. However, when I try to run HQ Admin from any =
other=20
<BR>computer on the network I get this error when I try to =
connect:<BR><BR>To=20
connect to this server you must use SQL Server Management Studio or =
SQL=20
<BR>Server Management Objects(SMO)<BR><BR>I can run HQ manager and =
enter the=20
configuration fine. However, I am <BR>restricted from connecting (so I =
can't=20
run SQL queries). Any ideas?<BR><BR><BR>Apparently I am not alone... I =
found=20
this old post on Google Groups, but did <BR>not find an=20
answer:<BR><BR><BR>Newsgroups: microsoft.public.pos<BR>From: Tad L =
<<A=20
title=3Dmailto:T...@discussions.microsoft.com=20
=
.com</A>><BR>Date:=20
Thu, 8 Mar 2007 16:37:03 -0800<BR>Local: Thurs, Mar 8 2007 8:37 =
pm<BR>Subject:=20
SQL problems with 2.0<BR>This is a weird database problem that has =
occured=20
since upgrading to 2.0 -<BR><BR>We have been running 2.0 for a couple =
weeks=20
now. Today I decided to look<BR>more into my backup problem and try =
some other=20
things. So I open<BR>Administrator on my desktop, and try to "connect" =
to my=20
database - It gives<BR>me an error "To connect to this server you must =
use SQL=20
Server Management<BR>Studio or SQL Server Management =
Objects(SMO)." If I=20
put in the wrong<BR>password, it of course says "Login failed for user =
'sa'".<BR><BR><BR>Now if I go into "configuration" and click the "test =
database connection"<BR>button, it connects fine. Manager works fine =
as well.=20
This is true for all <BR>my<BR>machines -<BR><BR><BR>Now - we did =
install 2.0=20
on a test machine for a couple days before doing<BR>the whole store - =
on that=20
machine my partner installed some additional SQL<BR>tools, and when I =
try the=20
above tests there, I can "connect" to the database<BR>from =
Administrator=20
without a problem. But if I try to run the backup utility<BR>from=20
Administrator, I get this error message -<BR><BR><BR>"Backup of file =
or=20
filegroup "sysft_itemlookup" is not permitted because it<BR>is not =
online.=20
BACKUP can be performed using the FILEGROUP or FILE clauses =
<BR>to<BR>restrict=20
the selection to include only online data.<BR>Backup of file or =
filegroup=20
"sysft_subitems" is not permitted because it is<BR>not online. BACKUP =
can be=20
performed using the FILEGROUP or FILE clauses to<BR>restrict the =
selection to=20
include only online data.<BR>BACKUP DATABASE is terminating=20
abnormally."<BR><BR><BR>This is the same message I get on my other =
machines=20
when I try to run the<BR>Backup from Manager -<BR><BR><BR>The database =
is=20
running on a SBS2003 server, all machines XP PRo, everything<BR>up to =
date -=20
All I want to do is backup my database simply and cleanly - =
<BR>Any<BR>ideas??=20
Please????<BR><BR><BR></BLOCKQUOTE></BODY></HTML>
------=
|
|
Posted by Jason on June 24, 2007, 10:35 am
Please log in for more thread options : quoted-printable
To clarify, I did this on the client computer (not the HQ Server). It =
worked perfectly. Thank you.
Regarding the KB article... Who has that kind of time? The average store =
owner would not have the time or patience to read that...
Anyone have an opinion on the "next best thing" to RMS? I am really =
getting tired of having to become a computer tech to run a three store =
POS system. It shouldn't bee this hard.
Jason,
Download and install the Backward Compatibility Component and the SQL =
Native Client from here; http://tinyurl.com/yumpyp
Follow the steps in this KB to correctly setup SQL2k5 =
http://tinyurl.com/2wk3ro
Must have access to CustomerSource
--=20
Regards,
Jeff Hobbs
Check Point Software
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your newsreader =
so that others may learn and benefit from your issue.
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
I am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects=20
from this computer. However, when I try to run HQ Admin from any =
other=20
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=20
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=20
not find an answer:
Newsgroups: microsoft.public.pos
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=20
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=20
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 -=20
Any
ideas?? Please????
------=_NextPart_000_0016_01C7B64B.5F4924E0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3DWindows-1252>
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Calibri"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 name=3D"Compose message =
area"=20
acc_role=3D"text" CanvasTabStop=3D"true">
<DIV><FONT face=3DArial color=3D#000000 size=3D2>To clarify, I did this =
on the client=20
computer (not the HQ Server). It worked perfectly. Thank =
you.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Regarding the KB =
article... Who has=20
that kind of time? The average store owner would not have the time or =
patience=20
to read that...</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Anyone have an opinion =
on the "next=20
best thing" to RMS? I am really getting tired of having to become a =
computer=20
tech to run a three store POS system. It shouldn't bee this =
hard.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeff @ Check Point Software" <<A=20
in message=20
<A=20
=
094B5-B2E8-483F-99A2-6A494E491944@microsoft.com</A>...</DIV>
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Download and install the Backward Compatibility Component and the =
SQL=20
Native Client from here; <STRONG><A title=3Dhttp://tinyurl.com/yumpyp=20
=
href=3D"http://tinyurl.com/yumpyp">http://tinyurl.com/yumpyp</A></STRONG>=
</DIV>
<DIV> </DIV>
<DIV>Follow the steps in this KB to correctly setup SQL2k5 <A=20
title=3Dhttp://tinyurl.com/2wk3ro=20
href=3D"http://tinyurl.com/2wk3ro">http://tinyurl.com/2wk3ro</A></DIV>
<DIV> </DIV>
<DIV>Must have access to CustomerSource<BR>-- <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader so=20
that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download=20
the file attachment(s). If you are not using a reader, follow =
the link=20
below to setup the above programs. Click on "Open with =
newsreader" under=20
the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A =
title=3Dmailto:microsoft.public.pos@natureisle.com=20
=
natureisle.com</A>>=20
wrote in message <A =
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
<BR>my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects <BR>from this computer. However, when I try to run HQ Admin =
from=20
any other <BR>computer on the network I get this error when I try to =
connect:<BR><BR>To connect to this server you must use SQL Server =
Management=20
Studio or SQL <BR>Server Management Objects(SMO)<BR><BR>I can run HQ =
manager=20
and enter the configuration fine. However, I am <BR>restricted from=20
connecting (so I can't run SQL queries). Any =
ideas?<BR><BR><BR>Apparently I=20
am not alone... I found this old post on Google Groups, but did =
<BR>not find=20
an answer:<BR><BR><BR>Newsgroups: microsoft.public.pos<BR>From: Tad =
L <<A=20
title=3Dmailto:T...@discussions.microsoft.com=20
=
.com</A>><BR>Date:=20
Thu, 8 Mar 2007 16:37:03 -0800<BR>Local: Thurs, Mar 8 2007 8:37=20
pm<BR>Subject: SQL problems with 2.0<BR>This is a weird database =
problem=20
that has occured since upgrading to 2.0 -<BR><BR>We have been =
running 2.0=20
for a couple weeks now. Today I decided to look<BR>more into my =
backup=20
problem and try some other things. So I open<BR>Administrator on my =
desktop,=20
and try to "connect" to my database - It gives<BR>me an error "To =
connect to=20
this server you must use SQL Server Management<BR>Studio or SQL =
Server=20
Management Objects(SMO)." If I put in the wrong<BR>password, =
it of=20
course says "Login failed for user 'sa'".<BR><BR><BR>Now if I go =
into=20
"configuration" and click the "test database connection"<BR>button, =
it=20
connects fine. Manager works fine as well. This is true for all=20
<BR>my<BR>machines -<BR><BR><BR>Now - we did install 2.0 on a test =
machine=20
for a couple days before doing<BR>the whole store - on that machine =
my=20
partner installed some additional SQL<BR>tools, and when I try the =
above=20
tests there, I can "connect" to the database<BR>from Administrator =
without a=20
problem. But if I try to run the backup utility<BR>from =
Administrator, I get=20
this error message -<BR><BR><BR>"Backup of file or filegroup=20
"sysft_itemlookup" is not permitted because it<BR>is not online. =
BACKUP can=20
be performed using the FILEGROUP or FILE clauses <BR>to<BR>restrict =
the=20
selection to include only online data.<BR>Backup of file or =
filegroup=20
"sysft_subitems" is not permitted because it is<BR>not online. =
BACKUP can be=20
performed using the FILEGROUP or FILE clauses to<BR>restrict the =
selection=20
to include only online data.<BR>BACKUP DATABASE is terminating=20
abnormally."<BR><BR><BR>This is the same message I get on my other =
machines=20
when I try to run the<BR>Backup from Manager -<BR><BR><BR>The =
database is=20
running on a SBS2003 server, all machines XP PRo, everything<BR>up =
to date -=20
All I want to do is backup my database simply and cleanly -=20
<BR>Any<BR>ideas??=20
Please????<BR><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=
|
|
Posted by Jeff @ Check Point Software on June 29, 2007, 3:20 am
Please log in for more thread options : quoted-printable
Jason,
Part of your problem is that you are trying to save money by becoming a =
computer tech instead of paying the computer techs to do a proper, =
competent job.
This is a known issue since before the KB was written. We, along with =
MBS and other resellers, helped create it and a competent RMS reseller =
would have known about and advised you how and when to do it or would =
have done it for you. Sure it would have cost you some money, but it =
would have been faster and maybe cheaper (how much do you make an hour) =
to do.
--=20
Regards,
Jeff Hobbs
Check Point Software
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your newsreader so =
that others may learn and benefit from your issue.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
To clarify, I did this on the client computer (not the HQ Server). It =
worked perfectly. Thank you.
Regarding the KB article... Who has that kind of time? The average =
store owner would not have the time or patience to read that...
Anyone have an opinion on the "next best thing" to RMS? I am really =
getting tired of having to become a computer tech to run a three store =
POS system. It shouldn't bee this hard.
Jason,
Download and install the Backward Compatibility Component and the =
SQL Native Client from here; http://tinyurl.com/yumpyp
Follow the steps in this KB to correctly setup SQL2k5 =
http://tinyurl.com/2wk3ro
Must have access to CustomerSource
--=20
Regards,
Jeff Hobbs
Check Point Software
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your =
newsreader so that others may learn and benefit from your issue.
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
I am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects=20
from this computer. However, when I try to run HQ Admin from any =
other=20
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=20
Server Management Objects(SMO)
I can run HQ manager and enter the configuration fine. However, I =
am=20
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=20
not find an answer:
Newsgroups: microsoft.public.pos
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=20
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=20
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 -=20
Any
ideas?? Please????
------=_NextPart_000_0483_01C7B9E3.3C438080
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3DWindows-1252>
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Calibri"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 acc_role=3D"text" =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Part of your problem is that you are trying to save money by =
becoming a=20
computer tech instead of paying the computer techs to do a proper,=20
competent job.</DIV>
<DIV> </DIV>
<DIV>This is a known issue since before the KB was written. We, =
along with=20
MBS and other resellers, helped create it and a competent RMS =
reseller=20
would have known about and advised you how and when to do it or would =
have done=20
it for you. Sure it would have cost you some money, but it would =
have been=20
faster and maybe cheaper (how much do you make an hour) to do.</DIV>
<DIV> </DIV>
<DIV>-- <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader so=20
that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the=20
file attachment(s). If you are not using a reader, follow the link =
below=20
to setup the above programs. Click on "Open with newsreader" under =
the MS=20
Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A title=3Dmailto:microsoft.public.pos@natureisle.com =
=
natureisle.com</A>>=20
=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>To clarify, I did =
this on the=20
client computer (not the HQ Server). It worked perfectly. Thank=20
you.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Regarding the KB =
article... Who has=20
that kind of time? The average store owner would not have the time or =
patience=20
to read that...</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Anyone have an =
opinion on the "next=20
best thing" to RMS? I am really getting tired of having to become a =
computer=20
tech to run a three store POS system. It shouldn't bee this =
hard.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeff @ Check Point Software" <<A =
title=3Dmailto:CptSoft@Hotmail.com=20
wrote in=20
message <A =
=
094B5-B2E8-483F-99A2-6A494E491944@microsoft.com</A>...</DIV>
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Download and install the Backward Compatibility Component and =
the SQL=20
Native Client from here; <STRONG><A =
title=3Dhttp://tinyurl.com/yumpyp=20
=
href=3D"http://tinyurl.com/yumpyp">http://tinyurl.com/yumpyp</A></STRONG>=
</DIV>
<DIV> </DIV>
<DIV>Follow the steps in this KB to correctly setup SQL2k5 <A=20
title=3Dhttp://tinyurl.com/2wk3ro=20
=
href=3D"http://tinyurl.com/2wk3ro">http://tinyurl.com/2wk3ro</A></DIV>
<DIV> </DIV>
<DIV>Must have access to CustomerSource<BR>-- <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader=20
so that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download=20
the file attachment(s). If you are not using a reader, follow =
the link=20
below to setup the above programs. Click on "Open with =
newsreader"=20
under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A =
title=3Dmailto:microsoft.public.pos@natureisle.com=20
=
natureisle.com</A>>=20
wrote in message <A =
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
am having a problem with HQ Admin after upgrading to SQL Server =
Express on=20
<BR>my HQ Server computer (running 1.3R). HQ Admin works fine in =
all=20
respects <BR>from this computer. However, when I try to run HQ =
Admin from=20
any other <BR>computer on the network I get this error when I try =
to=20
connect:<BR><BR>To connect to this server you must use SQL Server=20
Management Studio or SQL <BR>Server Management =
Objects(SMO)<BR><BR>I can=20
run HQ manager and enter the configuration fine. However, I am=20
<BR>restricted from connecting (so I can't run SQL queries). Any=20
ideas?<BR><BR><BR>Apparently I am not alone... I found this old =
post on=20
Google Groups, but did <BR>not find an =
answer:<BR><BR><BR>Newsgroups:=20
microsoft.public.pos<BR>From: Tad L <<A=20
title=3Dmailto:T...@discussions.microsoft.com=20
=
.com</A>><BR>Date:=20
Thu, 8 Mar 2007 16:37:03 -0800<BR>Local: Thurs, Mar 8 2007 8:37=20
pm<BR>Subject: SQL problems with 2.0<BR>This is a weird database =
problem=20
that has occured since upgrading to 2.0 -<BR><BR>We have been =
running 2.0=20
for a couple weeks now. Today I decided to look<BR>more into my =
backup=20
problem and try some other things. So I open<BR>Administrator on =
my=20
desktop, and try to "connect" to my database - It gives<BR>me an =
error "To=20
connect to this server you must use SQL Server =
Management<BR>Studio or SQL=20
Server Management Objects(SMO)." If I put in the =
wrong<BR>password,=20
it of course says "Login failed for user 'sa'".<BR><BR><BR>Now if =
I go=20
into "configuration" and click the "test database =
connection"<BR>button,=20
it connects fine. Manager works fine as well. This is true for all =
<BR>my<BR>machines -<BR><BR><BR>Now - we did install 2.0 on a test =
machine=20
for a couple days before doing<BR>the whole store - on that =
machine my=20
partner installed some additional SQL<BR>tools, and when I try the =
above=20
tests there, I can "connect" to the database<BR>from Administrator =
without=20
a problem. But if I try to run the backup utility<BR>from =
Administrator, I=20
get this error message -<BR><BR><BR>"Backup of file or filegroup=20
"sysft_itemlookup" is not permitted because it<BR>is not online. =
BACKUP=20
can be performed using the FILEGROUP or FILE clauses =
<BR>to<BR>restrict=20
the selection to include only online data.<BR>Backup of file or =
filegroup=20
"sysft_subitems" is not permitted because it is<BR>not online. =
BACKUP can=20
be performed using the FILEGROUP or FILE clauses to<BR>restrict =
the=20
selection to include only online data.<BR>BACKUP DATABASE is =
terminating=20
abnormally."<BR><BR><BR>This is the same message I get on my other =
machines when I try to run the<BR>Backup from Manager =
-<BR><BR><BR>The=20
database is running on a SBS2003 server, all machines XP PRo,=20
everything<BR>up to date - All I want to do is backup my database =
simply=20
and cleanly - <BR>Any<BR>ideas??=20
=
Please????<BR><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTM=
L>
------=
|
|
Posted by Jason on June 29, 2007, 1:34 pm
Please log in for more thread options : quoted-printable
If I wanted to save money, I woudn't have purchased RMS in the first =
place. The problem is that the software is designed to create ongoing =
expenses without an end in sight. There will never be a point that I can =
just stop expending money, even if my business is not growing. If i want =
to add lanes or stores now, I am FORCED to upgrade. Ig my database grows =
too large, there is nothing I can do except call my reseller (unless I =
become a tech myself). Other POS packages are far less expensive in the =
long run.
Bottom Line: If RMS requires the Backward Compatibility Client and SQL =
Native Client to run on SQL Server Express or SQL server, then it should =
be installed automatically or it should be documented. And how hard can =
it be to alert the user that the database limit is approaching?!
When I pop an Intuit disk into my drive to upgrade Quickbooks, i just =
hit the next button a few times. I am willing to bet QB POS is the same. =
My experience with several other POS packages (some more expensive, some =
less) has been that upgrades WORK without having to do a bunch of =
underlying technical stuff. Pop the disk in - voila - upgraded!
And FYI, I have been through 6 resellers, and all were useless. I have =
tried the maintenance plan route (where I rarely had issues resolved) =
and the ala carte route where I rarely paid anything because issues were =
apparently too hard for them to tackle (but easy enough for me to figure =
out using some persistence and research). I am far off the beaten path, =
where physical visits from a reseller are virtually impossible. All =
attempts to do things via phone or Internet were fruitless. You can see =
why I am hesitant to pay a dime to a reseller, be it ala carte or on a =
maintenance plan. Is my reseller going to check my database regularly to =
see if I am approaching the size limit? Is that something you do for =
your customers?
I have gained light-years more distance in this forum than with all =
resellers combined, and I am fully capable of accomplishing the tasks =
requierd to maintain my software... If Microsoft would just document =
their products properly and make them work as expected, there would be =
no problem.=20
So don't fault me for "trying to save money." I am indeed saving money, =
but more importantly I am getting the job DONE... That's less than I can =
say for some of the "professionals." Care to elaborate on the other =
"parts of my problem," Jeff?
Jason,
Part of your problem is that you are trying to save money by becoming =
a computer tech instead of paying the computer techs to do a proper, =
competent job.
This is a known issue since before the KB was written. We, along with =
MBS and other resellers, helped create it and a competent RMS reseller =
would have known about and advised you how and when to do it or would =
have done it for you. Sure it would have cost you some money, but it =
would have been faster and maybe cheaper (how much do you make an hour) =
to do.
--=20
Regards,
Jeff Hobbs
Check Point Software
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your newsreader =
so that others may learn and benefit from your issue.
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
To clarify, I did this on the client computer (not the HQ Server). =
It worked perfectly. Thank you.
Regarding the KB article... Who has that kind of time? The average =
store owner would not have the time or patience to read that...
Anyone have an opinion on the "next best thing" to RMS? I am really =
getting tired of having to become a computer tech to run a three store =
POS system. It shouldn't bee this hard.
Jason,
Download and install the Backward Compatibility Component and the =
SQL Native Client from here; http://tinyurl.com/yumpyp
Follow the steps in this KB to correctly setup SQL2k5 =
http://tinyurl.com/2wk3ro
Must have access to CustomerSource
--=20
Regards,
Jeff Hobbs
Check Point Software
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
When responding to posts, please "Reply to Group" via your =
newsreader so that others may learn and benefit from your issue.
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
You must be using Outlook Express/Windows Mail/Windows Live =
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a reader, follow =
the link below to setup the above programs. Click on "Open with =
newsreader" under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D
I am having a problem with HQ Admin after upgrading to SQL =
Server Express on=20
my HQ Server computer (running 1.3R). HQ Admin works fine in all =
respects=20
from this computer. However, when I try to run HQ Admin from any =
other=20
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=20
Server Management Objects(SMO)
I can run HQ manager and enter the configuration fine. However, =
I am=20
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=20
not find an answer:
Newsgroups: microsoft.public.pos
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=20
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=20
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 -=20
Any
ideas?? Please????
------=_NextPart_000_000E_01C7BA52.29B1EF00
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3DWindows-1252>
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12pt; =
COLOR: #008000; PADDING-TOP: 15px; FONT-FAMILY: Calibri"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 name=3D"Compose message =
area"=20
CanvasTabStop=3D"true" acc_role=3D"text">
<DIV><FONT face=3DArial color=3D#000000 size=3D2>If I wanted to save =
money, I woudn't=20
have purchased RMS in the first place. The problem is that the software =
is=20
designed to create ongoing expenses without an end in sight. There will =
never be=20
a point that I can just stop expending money, even if my business is not =
growing. If i want to add lanes or stores now, I am FORCED to upgrade. =
Ig my=20
database grows too large, there is nothing I can do except call my =
reseller=20
(unless I become a tech myself). Other POS packages are far less =
expensive=20
in the long run.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Bottom Line: If RMS =
requires the=20
Backward Compatibility Client and SQL Native Client to run on SQL Server =
Express=20
or SQL server, then it should be installed automatically or it should be =
documented. And how hard can it be to alert the user that the database =
limit is=20
approaching?!</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>When I pop an Intuit =
disk into my=20
drive to upgrade Quickbooks, i just hit the next button a few times. I =
am=20
willing to bet QB POS is the same. My experience with several other POS =
packages=20
(some more expensive, some less) has been that upgrades WORK =
without having=20
to do a bunch of underlying technical stuff. Pop the disk in - =
voila -=20
upgraded!</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>And FYI, I have been =
through 6=20
resellers, and all were useless. I have tried the maintenance plan route =
(where=20
I rarely had issues resolved) and the ala carte route where I =
rarely paid=20
anything because issues were apparently too hard for them to tackle (but =
easy=20
enough for me to figure out using some persistence and research). I am =
far off=20
the beaten path, where physical visits from a reseller are virtually =
impossible.=20
All attempts to do things via phone or Internet were fruitless. You can =
see why=20
I am hesitant to pay a dime to a reseller, be it ala carte or on a =
maintenance=20
plan. Is my reseller going to check my database regularly to see if I am =
approaching the size limit? Is that something you do for your=20
customers?</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>I have gained =
light-years more=20
distance in this forum than with all resellers combined, and I am fully =
capable=20
of accomplishing the tasks requierd to maintain my software... If =
Microsoft=20
would just document their products properly and make them work as =
expected,=20
there would be no problem. </FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>So don't fault me for =
"trying to save=20
money." I am indeed saving money, but more importantly I am getting the =
job=20
DONE... That's less than I can say for some of the "professionals." Care =
to=20
elaborate on the other "parts of my problem," Jeff?</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV>"Jeff @ Check Point Software" <<A=20
message=20
<A=20
3EB22-DBFC-4932-A94B-A0E6F99FC00C@microsoft.com</A>...</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Part of your problem is that you are trying to save money by =
becoming a=20
computer tech instead of paying the computer techs to do a proper,=20
competent job.</DIV>
<DIV> </DIV>
<DIV>This is a known issue since before the KB was written. We, =
along=20
with MBS and other resellers, helped create it and a competent =
RMS=20
reseller would have known about and advised you how and when to do it =
or would=20
have done it for you. Sure it would have cost you some money, =
but it=20
would have been faster and maybe cheaper (how much do you make an =
hour) to=20
do.</DIV>
<DIV> </DIV>
<DIV>-- <BR>Regards,</DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader so=20
that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download=20
the file attachment(s). If you are not using a reader, follow =
the link=20
below to setup the above programs. Click on "Open with =
newsreader" under=20
the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A =
title=3Dmailto:microsoft.public.pos@natureisle.com=20
=
natureisle.com</A>>=20
wrote in message <A =
=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>To clarify, I did =
this on the=20
client computer (not the HQ Server). It worked perfectly. Thank=20
you.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Regarding the KB =
article... Who=20
has that kind of time? The average store owner would not have the =
time or=20
patience to read that...</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2>Anyone have an =
opinion on the=20
"next best thing" to RMS? I am really getting tired of having to =
become a=20
computer tech to run a three store POS system. It shouldn't bee this =
hard.</FONT></DIV>
<DIV><FONT face=3DArial color=3D#000000 size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jeff @ Check Point Software" <<A =
title=3Dmailto:CptSoft@Hotmail.com=20
wrote in=20
message <A =
=
094B5-B2E8-483F-99A2-6A494E491944@microsoft.com</A>...</DIV>
<DIV>Jason,</DIV>
<DIV> </DIV>
<DIV>Download and install the Backward Compatibility Component and =
the SQL=20
Native Client from here; <STRONG><A =
title=3Dhttp://tinyurl.com/yumpyp=20
=
href=3D"http://tinyurl.com/yumpyp">http://tinyurl.com/yumpyp</A></STRONG>=
</DIV>
<DIV> </DIV>
<DIV>Follow the steps in this KB to correctly setup SQL2k5 <A=20
title=3Dhttp://tinyurl.com/2wk3ro=20
=
href=3D"http://tinyurl.com/2wk3ro">http://tinyurl.com/2wk3ro</A></DIV>
<DIV> </DIV>
<DIV>Must have access to CustomerSource<BR>-- <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Jeff Hobbs<BR>Check Point Software</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>When responding to posts, please "Reply to Group" via your =
newsreader=20
so that others may learn and benefit from your issue.</DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail/Windows Live=20
Mail/Thunderbird or some other type of newsgroup reader to see and =
download the file attachment(s). If you are not using a =
reader,=20
follow the link below to setup the above programs. Click on =
"Open=20
with newsreader" under the MS Retail Management System on the =
right.</DIV>
<DIV> </DIV>
<DIV><A title=3Dhttp://tinyurl.com/75bgz=20
=
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV> </DIV>
=
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Jason" <<A =
title=3Dmailto:microsoft.public.pos@natureisle.com=20
=
natureisle.com</A>>=20
wrote in message <A =
=
@TK2MSFTNGP04.phx.gbl</A>...</DIV>I=20
am having a problem with HQ Admin after upgrading to SQL Server =
Express=20
on <BR>my HQ Server computer (running 1.3R). HQ Admin works fine =
in all=20
respects <BR>from this computer. However, when I try to run HQ =
Admin=20
from any other <BR>computer on the network I get this error when =
I try=20
to connect:<BR><BR>To connect to this server you must use SQL =
Server=20
Management Studio or SQL <BR>Server Management =
Objects(SMO)<BR><BR>I can=20
run HQ manager and enter the configuration fine. However, I am=20
<BR>restricted from connecting (so I can't run SQL queries). Any =
ideas?<BR><BR><BR>Apparently I am not alone... I found this old =
post on=20
Google Groups, but did <BR>not find an =
answer:<BR><BR><BR>Newsgroups:=20
microsoft.public.pos<BR>From: Tad L <<A=20
title=3Dmailto:T...@discussions.microsoft.com=20
=
.com</A>><BR>Date:=20
Thu, 8 Mar 2007 16:37:03 -0800<BR>Local: Thurs, Mar 8 2007 8:37=20
pm<BR>Subject: SQL problems with 2.0<BR>This is a weird database =
problem=20
that has occured since upgrading to 2.0 -<BR><BR>We have been =
running=20
2.0 for a couple weeks now. Today I decided to look<BR>more into =
my=20
backup problem and try some other things. So I =
open<BR>Administrator on=20
my desktop, and try to "connect" to my database - It gives<BR>me =
an=20
error "To connect to this server you must use SQL Server=20
Management<BR>Studio or SQL Server Management =
Objects(SMO)." If I=20
put in the wrong<BR>password, it of course says "Login failed =
for user=20
'sa'".<BR><BR><BR>Now if I go into "configuration" and click the =
"test=20
database connection"<BR>button, it connects fine. Manager works =
fine as=20
well. This is true for all <BR>my<BR>machines -<BR><BR><BR>Now - =
we did=20
install 2.0 on a test machine for a couple days before =
doing<BR>the=20
whole store - on that machine my partner installed some =
additional=20
SQL<BR>tools, and when I try the above tests there, I can =
"connect" to=20
the database<BR>from Administrator without a problem. But if I =
try to=20
run the backup utility<BR>from Administrator, I get this error =
message=20
-<BR><BR><BR>"Backup of file or filegroup "sysft_itemlookup" is =
not=20
permitted because it<BR>is not online. BACKUP can be performed =
using the=20
FILEGROUP or FILE clauses <BR>to<BR>restrict the selection to =
include=20
only online data.<BR>Backup of file or filegroup =
"sysft_subitems" is not=20
permitted because it is<BR>not online. BACKUP can be performed =
using the=20
FILEGROUP or FILE clauses to<BR>restrict the selection to =
include only=20
online data.<BR>BACKUP DATABASE is terminating=20
abnormally."<BR><BR><BR>This is the same message I get on my =
other=20
machines when I try to run the<BR>Backup from Manager =
-<BR><BR><BR>The=20
database is running on a SBS2003 server, all machines XP PRo,=20
everything<BR>up to date - All I want to do is backup my =
database simply=20
and cleanly - <BR>Any<BR>ideas??=20
=
Please????<BR><BR><BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE=
></BODY></HTML>
------=
|
| Similar Threads | Posted | | HQ Admin/Manager connect to SQL Server | November 22, 2005, 10:05 pm |
| cannot connect to server, can't find server | February 8, 2006, 3:57 am |
| HQ Server error when trying to connect. | August 18, 2005, 11:04 am |
| Windows Server 2003 X64 and SQL Server 2005 Standard (X64) | October 24, 2005, 7:11 am |
| Connect to Server | January 13, 2006, 4:22 pm |
| POS cannot connect to server | April 24, 2006, 10:34 pm |
| Microsoft RMS and SQL Server 2000 (MSDE) or Server | October 23, 2005, 6:43 pm |
| HQ Client unable to connect to HQ Server | July 15, 2006, 9:16 pm |
| Server error 131 | November 3, 2006, 11:33 am |
| "Server not connected" error | February 17, 2006, 10:56 am |
|
|
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap