Is the domain user a local Power User on the machine?
 

Wendy Sporleder
Database Administrator

Saint Louis Art Museum
One Fine Arts Drive, Forest Park
Saint Louis, MO.  63110
314.655.5318
[log in to unmask]

 


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Dana Mock
Sent: Friday, April 25, 2008 12:05 PM
To: [log in to unmask]
Subject: Re: Login Issue

Yes, the network & SQL logins match.  Yes, the person is logging into the machine & TMS as the same domain user account.  Yes, we are able to login as the admin account & ODBC connection is working fine.

 

What is very strange is TMS works fine on my PC with their logins.  We are using the same ODBC version & same installation package for TMS.

 

On the new laptops, we have to change the SQL login in Management Studio to a sysadmin (under Login Properties > Server Roles) to get it to work with the appropriate TMS access.  When this option is unchecked, it doesn’t work.  When we try logging in as DOMAIN\UserName without the sysadmin SQL level, we can login to the application but they have zero TMS access levels.

 

Thank you so much for your assistance.

 


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Wendy Sporleder
Sent: Friday, April 25, 2008 8:35 AM
To: [log in to unmask]
Subject: Re: Login Issue

 

Do the network and SQL logins match?  Is this person logging into the machine as "user" (for instance) and TMS as "user?"   Can you log into TMS when logged into the machine as administrator?  If not, test the odbc connection in Control Panel/Administrative Tools/Data Sources. 

 

Wendy Sporleder
Database Administrator
314.655.5318

 

 


From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Dana Mock
Sent: Friday, April 25, 2008 10:13 AM
To: [log in to unmask]
Subject: Login Issue

We are having some challenges logging into TMS.  Our user received a new computer & hasn’t been able to work on the system since.  I have uninstalled the program & re-installed it with the same results.  We are getting the following error:

 

Cannot login as this user, only System Administrators can emulate other users.

 

Has anyone had this issue before?  If so, any advice on how to get rid of this?

Is there a searchable database available to search for errors or common tech support issues?

Thanks,

Dana Mock

Database Administrator

Museum of Making Music

[log in to unmask]