MIS Systems Thread, SIMS SQL users problem in Technical; Hello, I have a weird problem with our SQL 2008 server that hosts SIMS (it was SQL 2005 before, but ...
25th January 2010, 02:06 PM #1
SIMS SQL users problem
Hello, I have a weird problem with our SQL 2008 server that hosts SIMS (it was SQL 2005 before, but we migrated it to try and solve this problem, it didn't)
We had Capita remote-in to install hosted SIMS Learning Gateway. They ran a tool to create a new user in SIMS to allow ADP to work. However, after creating it, we couldn't login. We went into SQL Management Studio to try and change the password, but when we tried to get into the properties for the newly created account we got this message:
This was connecting logged on as administrator with a trusted connection. If we tried to login as sa, we got this:
Cannot show requested dialog. (SqlMgmt)
Property IsLocked is not available for Login '[CGSadp.client]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)
If we tried to go into properties for sa, it gave the same message as above.
Login failed for user 'sa'. (Microsoft SQL Error: 18456)
26th January 2010, 12:40 PM #2
Weird is right!
Have you had a look through the event log? In particular you should be able to get some extra info about the login error there:
For the login failure message, have a look here and see if it helps:
Last edited by theriver; 26th January 2010 at 12:43 PM.
Reason: Pasted wrong draft!
By localzuk in forum Windows Server 2000/2003
Last Post: 30th September 2009, 11:40 AM
By enjay in forum MIS Systems
Last Post: 27th February 2008, 02:55 PM
By interele in forum MIS Systems
Last Post: 2nd February 2008, 06:43 PM
By steve in forum MIS Systems
Last Post: 20th August 2007, 02:35 PM
By Norphy in forum MIS Systems
Last Post: 5th April 2007, 11:20 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread