+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Jan 2008
    Location
    Kingston Upon Thames
    Posts
    102
    Thank Post
    11
    Thanked 22 Times in 20 Posts
    Rep Power
    17

    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:

    Code:
    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)
    This was connecting logged on as administrator with a trusted connection. If we tried to login as sa, we got this:
    Code:
    Login failed for user 'sa'. (Microsoft SQL Error: 18456)
    If we tried to go into properties for sa, it gave the same message as above.

    Thanks,
    David

  2. #2

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    45
    Hello

    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:

    http://blogs.msdn.com/sql_protocols/...21/536201.aspx
    Last edited by theriver; 26th January 2010 at 11:43 AM. Reason: Pasted wrong draft!

SHARE:
+ Post New Thread

Similar Threads

  1. MS SQL server database permissions and users
    By localzuk in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 30th September 2009, 10:40 AM
  2. Old SIMS SQL Services
    By enjay in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 01:55 PM
  3. SIMS and SQL Express
    By interele in forum MIS Systems
    Replies: 3
    Last Post: 2nd February 2008, 05:43 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •