Problems loggin in to SQL server.

You have to treat me as a novice here.  I went to SSMS Express and expanded the server, dabases, database "Service", Security, Users and I can see user Philip.  I am not sure that is where you suggest I visit.  Are you suggesting a DOS type command.  If so, from what directory?  Or do you mean something else?

I'm sorry RH. Go to SSMS Express, open up a new query window & execute these commands.

go <your database>
exec sp_change_users_login 'update_one', LMG\philip, LMG\philip

Thanks Steve,  I am still doing something wrong.  I attached a screen shot of the error message.  My database name is Service and  I tried the command "go service" and "go <service> and had the same error with both attempts.  What should I change?

No your not, I am a moron. Its "use services" not "go services". I should never take my glasses off.

BTW, the solution I gave you is one that I have used when addressing the error in your popup window reffering to the user already existing in the database. A way to confirm this condition is to go into SSMS, open up databases -> your database -> security -> logins. If you see the login there, then open the server security leaf -> Logins. If you see the login there then right-mouse click the login and select properties. Select User Mapping in the list on the left & check the database. If there is no check next to your database then that will confim the condition and the code should correct it.

Steve, I typed the command as shown below.  I received back the error message that follows.  

use services
exec sp_change_users_login 'update_one', LMG\philip, LMG\philip

Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'services'. No entry found with that name. Make sure that the name is entered correctly.

Some of my tabs may have different names and locations, but I did go to Databases - Service - Security - Users - LMG\Philip and find him.  No database was checked under User Mapping.  I could also go to Security - Logins - LMG\Philip and the properties there were identical.  

I just saw one error with my command.  I put the database as services, not service.  I still have an error, but a different one.  

use service
exec sp_change_users_login 'update_one', LMG\philip, LMG\philip

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '\'.

Hmmm, try enclosing the user names in ex. [LMG\philip]. I will check the syntax as well.

Steve, I just tried again.  It looks like this may be the correct syntax and it is telling me it cannot find the user LMB\philip.  Should I delete him and start again?

use service
exec sp_change_users_login 'update_one', [LMG\philip], [LMG\philip]

Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 108
Terminating this procedure. The User name 'LMG\philip' is absent or invalid.

So did I. I thought that the stored procedure would treat both SQL and Windows logins the same. Apparently I am wrong. Sorry about that.

Try this (its easier if I cut and paste this again): open up databases -> your database -> security -> logins. If you see the login there, then open the server security leaf -> Logins. If you see the login there then right-mouse click the login and select properties. Select User Mapping in the list on the left & check the database. If there is no check next to your database, then delete the user from the database (your database -> security -> LMG\philip [right-mouse-delete] and re-add it at the security->logins Select User Mapping by checking the checkbox next to the database name and applying it.

Sorry for the delay but I had to hurry home and mow my yard before dark.  I beat the dark but finished in a light rain.  Now I am back.  I read your suggestion.  I went into SMSS and went to Databases, Service, Security, Users, Philip.  This did not have anything about mapping.  I then went to Security, Logins, Philip.  There is an option for mapping but it would not permit me to do any mapping.  I opened the database application and went to the user maintenance and deleted user Philip.  I came back to SMSS and in Security, Logins I deleted user Philip.  I then wen to Databases, Service, Security, Users and tried to delete user Philip.  It failed.  The message is attached.  I went back into the application and added Philip back and am back to where I started.  The most puzzling part of this whole situation to me is that from his workstation Philip can log into the database with no problems.  However when he logs in using the Terminal Server he has errors.  But other people, including myself, can log in from the Terminal Server without problems.  I can login from either the Terminal Server or my local workstation.  I do not see anything obvious in his profile, although nothing else works I will deleted it and start again.  

So you have re-added LCM\Philip to the Server logins and wa unable to ddelete the login form the Services database. Is that cortrect? Hmmm, so much for the easy approach. I'll do some snooping & get back to you when I can. I want to aviod trying to change the schema ownership in the database unless we have to.

Try running:

 EXEC sp_change_users_login 'Auto_Fix', 'LCM\Philip'

 BTW, the domain is still valid, no?

I tried running that command as suggested.  I have attached a printout.  It did not seem to make any difference.  Philip still had the same message when he tried to connect on the Terminal Server even though he connected from the workstation.  

I hit a key too fast.  Here is a copy of the screen when Philip attempts to connect.  

Another attempt to show error screen

I assume that you were in the proper database in SSMS. If you run:

EXEC sp_change_users_login 'Report'

 in that dfatabase, does it list 'LCM\Philip'?

I am not finding any users.  My server is LMG01, my application is ESC, the database is Service.  The screen print clearly shows that as being where I ran the query.  The message is that it was successful, but the Results are empty.  I got this after verifying 2 users were actively using the database.  

ESC is the name of the application and the name on the icon.  LMG01\ESC is what I put in the application when I choose the server.  When I ran the command you suggested the result was    LMG01\ESC

I still have no solution to this problem.  Thinking it might be in the Terminal Server profile I deleted Philip's profile from the Terminal Server and had him log in again.  The TS created a new profile, but when he tried to open the database he got the same error as before.  I had another person who only uses the Terminal Server to work come to me with the same problem.  Apparently this does not have anything to do with the user name we are trying to put in to login as it does with the user on the Terminal Server.  I can login as ADMIN from my TS connection, but not from Philip's. I can login to the database as Philip if I am using my TS login.  

I am still looking for a solution.  As I said in my last post I am thinking if it has more to do with the Terminal Server than database administration.  Some uses on the Terminal Server can connect with no problem.  But at least 2 users have told me they cannot connect.  Each user has a folder in Documents and Settings and I went and deleted that folder for one user with the problem logging in to SQL.  That directory was rebuilt, but still the user had the same error.  Does anyone know of any other place where the TS might be keeping settings for users?  

according to the last error message, the login does not have any permissions in the database "service", or the "service" database is single-user/offline.

can you check in the SSMS, while connected to the instance, in the Security folder -> logins -> your login, properties, if that login is mapped (user mappings) to the "service" database ?

I took a look at the mapping today.  Every user that is listed is mapped to "Service" except for Philip.  When I first looked at the properties for Philip and opened up User Mapping, there was no mapping.  I tried to check the map to Service but when I tried to save and exit I got an error message.  That error   message is displayed.  I think this might be the right path to follow.   Should I delete Philip and try to enter system again?   I have another user Rob that is no longer an employee.  Could I delete user Philip and rename user Rob to user Philip?  

please check this query to see if you "see" the user:
select * from  <yourdatabase>.sys.users

also, run this:
select * from master.sys.logins

and paste both relevant records here...

I tried to run the 2 queries you suggested but this is so new to me that I cannot get things correct.  I have included the exact way I typed the 2 queries and the results.  When I open the database using the program it says the server name is lmg01\ESC and the database is Service.  I have tried lmg01, ESC and service and none of them seem to work.  The server machine has a name of LMG01.  I  am working with a program ESC and when we login we login to server "LMG01\ESC" and we choose the database "Service".  How do I properly define that in the query?

let's give this a second try...

and is your database really named LGM01\ESC ? I presume (from the question text) that is the server/instance name. your dbname is "service"

select * from master.sys.syslogins
 
select * from [service].sys.sysusers
                                              

1:
2:
3:

I am still learning, including terminology.  The Server is LMG01 and the instance is ESC and the database is SERVICE.  I ran the 2 queries you suggested.  There are many columns and the logins took 3 screen shots to show all the columns and is attached at Query1-1, Query 1-2 and Query 1-3.  I wanted to show the information for login Philip and his information is at the bottom of the screen.  When I ran the query for users I was able to put his information at the top.  I do not see anything different for him than any other users or logins.  

I did not get all images attached.  Here are the rest

hmmm... I presumed you would limit the output to the logins/users that would be relevant

select * from master.sys.syslogins
where [loginname] like '%philip%' 
 
select * from [service].sys.sysusers
where [name] like '%philip%'
                                              

1:
2:
3:
4:
5:
6:

I am a Newbie when it comes to SQL so I needed that extra coding to know how to restrict output.  Here is the output for those 2 commands for just user Philip.  Due to width I have 2 screen prints for each query.  I  hope it is legible.

this is just fine...

except that, from what I can see, the "sid" column values seem to match.
can you double-check just that 1 column?

they have to match for the link to be done between the login and the user record...

if that is not the case, you should be able to update the sysusers record to update the sid to match the syslogins, either with this (note the case sensitive difference, it should not matter, though):
EXEC sp_change_users_login 'Update_One', 'LMG\Philip', 'LMG\philip';

or a direct update...

Now that I know how important the SID is I went in and compared them.  They are not the same.  I did a copy and paste of the command you suggested and got an error.  Should I enter the actual SID?  You mentioned a direct update.  How do I proceed with it>

you might need to enable catalog updates...

update u
   set u.sid = l.sid
  from [service].sys.sysusers u
  join master.sys.syslogins l
    on l.[loginname] like 'LGM\philip%' 
   and u.[name] like 'LGM\philip%'

                                              

1:
2:
3:
4:
5:
6:

Unfortunately the server does not like that command either.  I will let you know that I will not be able to respond until tomorrow, but I will check this first thing in the morning.  I really appreciate all your efforts to help me get through this problem.

buzzer ...

ok, let's see if this works:
http://msdn.microsoft.com/en-us/library/ms176060.aspx

USE [service]
ALTER USER [LGM\philip]
 WITH LOGIN [LGM\philip]

                                              

1:
2:
3:

I think we are getting closer.  This query is showing a syntax error on line 3.  I have been looking at help files but so far do not see any correction that is obvious.

please try without the [ ]

I already tried that.  The end of the message changed to "Incorrect syntax near 'LMG'.  I have been out looking at the help files and found a command to just this, but it has some variables I am not sure about.  It has a user_name and a new_user_name.  I cannot figure out what changes this would be asking for in my situation.

I have SQL 2005.  The article you found has a link at the bottom to instructions for SQL 2005, and that link is right back to the page I found in the help file.  What goes in the place of <set_item>?  Should I change user Philip to Philip1 and then change it back with this type of command?  Of is there a way to delete both the login Philip and the User Philip and start fresh?  

I actually refered the link, showing that you seem to need SP2 at least in sql 2005 ...
do you have SP2 or higher?

I just ran a query.  I have SQL Express Edition, SP3, SQL_Version 9.00.4053.00.

sorry, I don't know, then. :(