Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Unanswered: MSDE - ADP Question

    Hi,

    After upsizing on MSDE, I created ADP on my terminal.

    When the created ADP I need to copy to another user to get connected to MSDE hosted on my pc I followed these steps.

    First I copied ADP to the user's pc and

    1. Opened Administration Tools on user's pc
    2. Clicked twice Data Source (ODBC) icon
    3. Selected System DSN and clicked Add
    4. Selected SQL Server (Last item) and Finish
    5. Given new connection name (any name) in the field 'Name'. Description left empty. In Servaer, typed server name.
    6. In the next page, I selected SQL Server Authentication and....

    Here is my question:

    Should I use at this step System Administrator's login id and password ?

    OR

    Should I use user's pc id and password ?

    I tried both way. But login fails.

    Where might have gone wrong? BTW, this the first user I trying on.

    Any help would be highly appreviated.

    With kind regards,

    Ashfaque

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    create a sql login in our MSDE using sp_addlogin and then use sp_adduser to grant them specific db access. see details in BOL. if you are using Wndows XP SP2 you may have to create an exception in the personal firewall r drop it altogether.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Thanks Thrasymachus,

    I would appreciate it very much if you could little bit in detail as I am new bee for this area.

    With kind regards,

    Ashfaque

  4. #4
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Do you have Books Online? If so (it's included free with SQL Server), open it up and go to the Index tab. Type in "logins-SQL Server" and start reading. It will give you more than enough information to accomplish this task. You can also type in the stored procedures he gave you to get syntax and usage information.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    oh why use the reference material. I drove for a couple of years without a license when I was a kid.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  6. #6
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Hi Guys,

    No, I don't have Books Online..

    Justi moving around with the help of you people...

    I attached jpg image to give you a clear pic to know whats wrong..

    With kind regards,

    Ashfaque
    Attached Thumbnails Attached Thumbnails MSDE_ConnectionError.JPG  

  7. #7
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397
    Hello Gentlemen,

    I am still waiting for your valuable response..

    With kind regards,

    Ashfaque

Posting Permissions

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