Home Page link  

Error #-2147217843 Login Failed for user 'sa'

  
Groups | Search | About
User Password
Register Now! Lost Password?

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

 Post an article  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  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Error #-2147217843 Login Failed for user 'sa' Vince 12-22-2005
Posted by Vince on December 22, 2005, 1:23 am
Please log in for more thread options
 (Source: Microsoft OLE DB Provider for SQL Server)
(SQL State: 4200)
(NativeError: 18456)
No help file available.
What the heck is going on? I have installed RMS on my personal computer,
and I have been using that for a couple of weeks just to see if there were
going to be any problems in regards to installing 1.3 and this is what is
comming up all of a sudden, WHY???
--
Thank You,;
Vince

Posted by Jeff on December 22, 2005, 2:23 am
Please log in for more thread options
 Vince,

When are you getting this message?

Sounds like you've entered the wrong password for the database.

Go to SO Administrator | File | Connect | make sure that server says
(local), use SQL Auth is checked, user name is sa, put your password in, put
in your database name, OK.

Now go to File | Configuration | make sure everything is set the way the
Connect tab was and click Test Database Connection. If OK, File | Exit

--
=

> (Source: Microsoft OLE DB Provider for SQL Server)
> (SQL State: 4200)
> (NativeError: 18456)
> No help file available.
> What the heck is going on? I have installed RMS on my personal computer,
> and I have been using that for a couple of weeks just to see if there were
> going to be any problems in regards to installing 1.3 and this is what is
> comming up all of a sudden, WHY???
> --
> Thank You,;
> Vince



Posted by Vince on December 23, 2005, 12:13 pm
Please log in for more thread options
Jeff,
Thank you I think I got it.
--
Thank You,;
Vince


"Jeff" wrote:

> Vince,
>
> When are you getting this message?
>
> Sounds like you've entered the wrong password for the database.
>
> Go to SO Administrator | File | Connect | make sure that server says
> (local), use SQL Auth is checked, user name is sa, put your password in, put
> in your database name, OK.
>
> Now go to File | Configuration | make sure everything is set the way the
> Connect tab was and click Test Database Connection. If OK, File | Exit
>
> --
> =
>
> > (Source: Microsoft OLE DB Provider for SQL Server)
> > (SQL State: 4200)
> > (NativeError: 18456)
> > No help file available.
> > What the heck is going on? I have installed RMS on my personal computer,
> > and I have been using that for a couple of weeks just to see if there were
> > going to be any problems in regards to installing 1.3 and this is what is
> > comming up all of a sudden, WHY???
> > --
> > Thank You,;
> > Vince
>
>
>

Posted by Cliff on January 11, 2006, 9:57 am
Please log in for more thread options
Hi All,

i have been trying to restore a .bck file on my laptop (as a backup). I have
loaded the .bck by going to the SO Administrator - database | create and
selecting the .bck file. After loading, i try to connect and i get the error
mentioned above "Login failed for user 'sa'

I have double checked the password but it still gives this error when trying
to connect with sql authentication. The server name is (local)

Does anybody have any suggestions?

Tjanks
LY

"Vince" wrote:

> (Source: Microsoft OLE DB Provider for SQL Server)
> (SQL State: 4200)
> (NativeError: 18456)
> No help file available.
> What the heck is going on? I have installed RMS on my personal computer,
> and I have been using that for a couple of weeks just to see if there were
> going to be any problems in regards to installing 1.3 and this is what is
> comming up all of a sudden, WHY???
> --
> Thank You,;
> Vince

Posted by Jeff on January 11, 2006, 3:06 pm
Please log in for more thread options
Cliff,

Look at the thread Administrator / database password. I just posted a way
to change the password.

--
*
Hi All,

i have been trying to restore a .bck file on my laptop (as a backup). I have
loaded the .bck by going to the SO Administrator - database | create and
selecting the .bck file. After loading, i try to connect and i get the error
mentioned above "Login failed for user 'sa'

I have double checked the password but it still gives this error when trying
to connect with sql authentication. The server name is (local)

Does anybody have any suggestions?

Tjanks
LY

"Vince" wrote:

> (Source: Microsoft OLE DB Provider for SQL Server)
> (SQL State: 4200)
> (NativeError: 18456)
> No help file available.
> What the heck is going on? I have installed RMS on my personal computer,
> and I have been using that for a couple of weeks just to see if there were
> going to be any problems in regards to installing 1.3 and this is what is
> comming up all of a sudden, WHY???
> --
> Thank You,;
> Vince



Similar ThreadsPosted
Login Failed(Help me Please) October 25, 2007, 2:22 am
need info on failed login attempts January 30, 2006, 3:32 pm
error message "your windows user account does not......" December 19, 2008, 1:51 pm
Failed:06 Error 0062 December 14, 2005, 2:50 pm
error on database login December 15, 2005, 7:35 pm
error 2147024769 method of object failed July 25, 2007, 4:48 pm
Error: failed to create windows users/groups or add the sql loggin October 24, 2007, 7:40 pm
Cashier Time Clock Report error ( -2147467259 )Conversion failed February 20, 2008, 1:16 pm
Microsoft Store Operations POS: Attempt to process COM object 'ObjectName' failed. An unknown error ocurred. June 11, 2008, 5:01 pm
RMS User Manual January 18, 2006, 1:31 am

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 SitemapXML Sitemap