Login name column empty when creating new users

Hi, I am creating new users in SQL Server through Enterprise Manager. All my users are remote, so I type the domain\user in the login name, and the name is copied automatically. Some of the users are created correctly, and I can see they have information in the name column and in the login name column. The problem is that for some other users, the login name is empty, and these users can't connect to the server, a system message appears saying the user "domain\user" doesn't have access to the server. I checked all the setting in the active directory, and all the users have the same settings, I can't find any difference between the users that display information in the login name column, and the others that don't. I attached a file where you can see how the screen shows a user that has complete the columns, and other which has missing the information in one of the columns. Could you help me to search what is happening?. Thanks.
Document1.JPG
aviverosAsked:
Who is Participating?
 
aviverosConnect With a Mentor Author Commented:
I reviewed the related case, apparently I also have the problem of orphaned users. I created new the database, so it is not possible the accounts have existed previously. I deleted the users and I checked they don't exist in Enterprise Manager > Database > Security, then I created again the users, and the problem still continue, the login name column is empty. If I run the stored procedure suggested for the other case, I get the following results:  
   sp_change_users_login 'AUTO_FIX','CSERNA'  
   The number of orphaned users fixed by updating users was 0.  
   The number of orphaned users fixed by adding new logins and then updating users was 0.  
I think it is because the user is a domain user, and this procedure only works for repair SQL users.  
Maybe other solution that can solve the problem, is if I modify the VB code in my program to access the database with the "sa" user instead of the domain user. The code in the program to access the db is the following:  
    cnn.Open "Provider=SQLOLEDB; " & _  
             "Initial Catalog=PRODUCCION; " & _  
             "Data Source=CPZZ400KRONOS01; " & _  
             "integrated security=SSPI; persist security info=True;"  
How do I have to change the code to access the db with the "sa" user?. The code is in VB v.6. Thanks.
0
 
dreadyCommented:
Are these maybe users that allready existed in a Database that you restored a Backup from? In that case, have a look here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23001594.html

0
All Courses

From novice to tech pro — start learning today.