Database login failure

Warning: iconv_mime_decode() [function.iconv-mime-decode]: Malformed string in /home/rockryno/public_html/lib/standard.lib.php on line 2258
Database login failure


Database login failure

Groups | Search | About

User Password

Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

get this group's latest topics as an RSS feed

add this group's latest topics to your My MSN content

add this group's latest topics to your My Yahoo content

add this group's latest topics to your Google content

Yahoo!

Google

Windows Live

del.icio.us digg

digg

Netscape

Subject

Author

Date

Database login failure

Ron

06-13-2007

RE: Database login failure

Akb

06-14-2007

RE: Database login failure

06-14-2007

Re: Database login failure

Jeff @ Check Po...

06-14-2007

Posted by Ron on June 13, 2007, 10:02 pm

Please log in for more thread options

I am running RMS 1.2. My pos was running as normal.

Microsoft automatically updated XP on 6/13/07 and after the reboot, I get an
error that the application cannot connect to the database.

When I use Admin to test the connection, I receive the error message,

"OLE DB provider error -2147467259 login failed"

Any idea how to fix this? We're dead in the water without support on this
one...

Thanks for your help.

Posted by Akber Alwani on June 14, 2007, 1:11 am

Please log in for more thread options

Hi Ron,
Make sure the server database name and passwords are correct. Second check
the Database services is running SQL server Service. first things you do
this. The next thing if the above are not in correct situtation then try to
look at your ODBC drivers and I would suggst you to download or may be in RMS
cd there are drivers of MDAC microsoft data acesss components it seems that
drivers crouptted for OLE db.

But all these first you need to confirm db server services , user id and
password and then MDAC.

"Ron" wrote:

> I am running RMS 1.2. My pos was running as normal.

> Microsoft automatically updated XP on 6/13/07 and after the reboot, I get an

> error that the application cannot connect to the database.

> When I use Admin to test the connection, I receive the error message,

> "OLE DB provider error -2147467259 login failed"

> Any idea how to fix this? We're dead in the water without support on this

> one...

> Thanks for your help.

Posted by Ron on June 14, 2007, 2:15 pm

Please log in for more thread options

The database name and password are correct. I think the database may have
encountered an error when the system update automatically ran.

I was looking to do a dbcc checkdb, but I may not have this option with the
desktop SQL. Unless there's another suggestion, I'm forced to go back to a
backup, which unfortunately, is a few weeks old.

Thanks for your suggestion. If anyone knows if a standalone RMS system can
run this database check, DBCC CHECKDB, I'd love to hear about it. I was not
able to run this command from the command prompt.

"Akber Alwani" wrote:

> Hi Ron,

> Make sure the server database name and passwords are correct. Second check

> the Database services is running SQL server Service. first things you do

> this. The next thing if the above are not in correct situtation then try to

> look at your ODBC drivers and I would suggst you to download or may be in RMS

> cd there are drivers of MDAC microsoft data acesss components it seems that

> drivers crouptted for OLE db.

> But all these first you need to confirm db server services , user id and

> password and then MDAC.

> "Ron" wrote:

> > I am running RMS 1.2. My pos was running as normal.

> >

> > Microsoft automatically updated XP on 6/13/07 and after the reboot, I get an

> > error that the application cannot connect to the database.

> >

> > When I use Admin to test the connection, I receive the error message,

> >

> > "OLE DB provider error -2147467259 login failed"

> >

> > Any idea how to fix this? We're dead in the water without support on this

> > one...

> >

> > Thanks for your help.

Posted by Jeff @ Check Point Software on June 14, 2007, 5:04 pm

Please log in for more thread options

: quoted-printable

Ron,

SO Admin | Database | Check runs the DBCC CHECKDB command or you could =
just enter it as a Query in Admin too.

I'd be looking for firewall issues myself. Turn them off on both =
ends/machines and see what happens.

--=20

Jeff=20
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

You must be using Outlook Express/Windows Mail 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 Outlook Express. 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

The database name and password are correct. I think the database may =
have=20
encountered an error when the system update automatically ran.

I was looking to do a dbcc checkdb, but I may not have this option =
with the=20
desktop SQL. Unless there's another suggestion, I'm forced to go back =
to a=20
backup, which unfortunately, is a few weeks old.

Thanks for your suggestion. If anyone knows if a standalone RMS system =
can=20
run this database check, DBCC CHECKDB, I'd love to hear about it. I =
was not=20
able to run this command from the command prompt.

"Akber Alwani" wrote:

> Hi Ron,
> Make sure the server database name and passwords are correct. Second =
check=20
> the Database services is running SQL server Service. first things =
you do=20
> this. The next thing if the above are not in correct situtation then =
try to=20
> look at your ODBC drivers and I would suggst you to download or may =
be in RMS=20
> cd there are drivers of MDAC microsoft data acesss components it =
seems that=20
> drivers crouptted for OLE db.
>=20
> But all these first you need to confirm db server services , user =
id and=20
> password and then MDAC.
>=20
> "Ron" wrote:
>=20
> > I am running RMS 1.2. My pos was running as normal.
> >=20
> > Microsoft automatically updated XP on 6/13/07 and after the =
reboot, I get an=20
> > error that the application cannot connect to the database.
> >=20
> > When I use Admin to test the connection, I receive the error =
message,
> >=20
> > "OLE DB provider error -2147467259 login failed"
> >=20
> > Any idea how to fix this? We're dead in the water without support =
on this=20
> > one...
> >=20
> > Thanks for your help.
------=_NextPart_000_00A7_01C7AE8C.F8032A80
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Ron,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>SO Admin | Database | Check  runs the =
DBCC CHECKDB=20
command or you could just enter it as a Query in Admin too.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>I'd be looking for firewall issues =
myself.  Turn=20
them off on both ends/machines and see what happens.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <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</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=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>"Ron" <<A=20
=
om</A>>=20
wrote in message <A=20
=
AFECA-DDF4-48AE-908B-EAAA250A8725@microsoft.com</A>...</DIV>The=20
database name and password are correct. I think the database may have=20
<BR>encountered an error when the system update automatically =
ran.<BR><BR>I=20
was looking to do a dbcc checkdb, but I may not have this option with =
the=20
<BR>desktop SQL. Unless there's another suggestion, I'm forced to go =
back to a=20
<BR>backup, which unfortunately, is a few weeks old.<BR><BR>Thanks for =
your=20
suggestion. If anyone knows if a standalone RMS system can <BR>run =
this=20
database check, DBCC CHECKDB, I'd love to hear about it. I was not =
<BR>able to=20
run this command from the command prompt.<BR><BR><BR>"Akber Alwani"=20
wrote:<BR><BR>> Hi Ron,<BR>> Make sure the server database name =
and=20
passwords are correct. Second check <BR>> the Database services is =
running=20
SQL server Service. first things you do <BR>> this. The next thing =
if the=20
above are not in correct situtation then try to <BR>> look at your =
ODBC=20
drivers and I would suggst you to download or may be in RMS <BR>> =
cd there=20
are drivers of MDAC microsoft data acesss components it seems that =
<BR>>=20
drivers crouptted for OLE db.<BR>> <BR>> But all these first you =
need to=20
confirm db  server services , user id and <BR>> password and =
then=20
MDAC.<BR>> <BR>> "Ron" wrote:<BR>> <BR>> > I am running =
RMS=20
1.2. My pos was running as normal.<BR>> > <BR>> > =
Microsoft=20
automatically updated XP on 6/13/07 and after the reboot, I get an =
<BR>>=20
> error that the application cannot connect to the =
database.<BR>> >=20
<BR>> > When I use Admin to test the connection, I receive the =
error=20
message,<BR>> > <BR>> > "OLE DB provider error -2147467259 =
login=20
failed"<BR>> > <BR>> > Any idea how to fix this? We're =
dead in the=20
water without support on this <BR>> > one...<BR>> > =
<BR>> >=20
Thanks for your help.</BLOCKQUOTE></BODY></HTML>

------=

Similar Threads	Posted
Impersonation Context Login Failure	April 10, 2007, 9:32 pm
Login Failure: Point of Sale	May 16, 2007, 6:10 pm
error on database login	December 15, 2005, 7:35 pm
Server Failure 131: A server failure occurred while attempting to.	July 19, 2005, 12:54 am
Server Failure 131	November 29, 2005, 7:19 pm
Server Failure 138	January 1, 2006, 4:04 pm
RMS 1.3 Server Failure 138	April 11, 2007, 12:54 pm
Re: server failure	January 17, 2008, 10:14 am
server failure	January 17, 2008, 7:35 am
Returns Failure	October 15, 2008, 7:43 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software

XML Sitemap