Error #-2147217843 Login Failed for user 'sa'

(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???

Reply to
Vince
Loading thread data ...

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

Reply to
Jeff

Jeff, Thank you I think I got it.

Reply to
Vince

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

"V> (Source: Microsoft OLE DB Provider for SQL Server)

Reply to
Cliff

Cliff,

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

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.