I am using a demo for RMS 2.0 and installed MS SQL Server 2008 Express. Using the Store Operations Administrator Configuration screen I am getting the following listed below when trying to connect. Any clues as to my problem would be greatly appreciated... Error #-2147217843 Login failed for user 'Mike' (Source: Microsoft OLE DB Providor for SQL Server) (SQL State: 42000) (NativeError: 18456) No Help file avaialbe
Connecting to MS SQL Server 2008 Express
Dec 27, 2009
1 Replies
You are tring to log into an SQL server with the SQL Authentication and the username Mike. This error would indicate the user Mike does not exist, does not have access to the database you are trying to connect to, or the password was entered correctly. I would double-check your settings on SQL. Typically most users use the SA username with it's password while setting up RMS.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required