+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, CMIS and SQL 2008 install in Technical; Hi I have installed SQL 2008 onto our 2003 server, and created a datbase following the Serco instructions. I have ...
  1. #1

    Join Date
    Jul 2009
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    CMIS and SQL 2008 install

    Hi I have installed SQL 2008 onto our 2003 server, and created a datbase following the Serco instructions. I have created a new connection/ODBC I have tested it on the server and it works fine but when I try to connect from a client pc it says "connection failed sqlstate 28000" it looks like its trying to use the domain user account instead of the STUD_ADMIN I think. Serco dont have info on the sql install so I may be missing something on that part. Any help would be great.

    Thanks

    Ste

  2. #2

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    634
    Thank Post
    99
    Thanked 134 Times in 104 Posts
    Rep Power
    68
    Sounds to me like in the connection from the client, you've used Windows Authentication rather than SQL authentication.
    Create a new connection, make sure you use SQL Authentication.

    Mic @ Serco

  3. #3

    Join Date
    Jul 2009
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks that worked.

    Ste



SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 07:03 AM
  2. CMiS/ePortal and Server 2008
    By TronXP in forum MIS Systems
    Replies: 0
    Last Post: 29th April 2008, 04:07 PM
  3. CMIS/SQL Reinstall
    By SpuffMonkey in forum How do you do....it?
    Replies: 2
    Last Post: 1st August 2007, 12:06 AM
  4. CMIS SQL server upgrade.
    By dave-a in forum MIS Systems
    Replies: 3
    Last Post: 10th July 2007, 11:16 AM
  5. Refreshing MS Access linked tables to CMIS MS SQL
    By dickyfinn02 in forum MIS Systems
    Replies: 0
    Last Post: 23rd April 2007, 05:33 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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