Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Clients Accessing SQL

    Hello everyone I have one of our sql server databases on a test server, but they cant seem to access it. Can anyone give me some suggestion I'm sure its something I am obviously missing
    Last edited by desireemm; 12-20-13 at 13:38.

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by desireemm View Post
    Hello everyone I have one of your sql server databases on a test server, but they cant seem to access it. Can anyone give me some suggestion I'm sure its something I am obviously missing
    Why do you have one of my databases on your server?

    There are a couple ways to grant access. One is to use a SQL Login with a password, but this isn't the recommended method because everyone will have to know the password. Create a AD domain account and add members. Use this account as a login in SQL with windows authentication.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    sorry I mean our

  4. #4
    Join Date
    Dec 2013
    Posts
    43
    Provided Answers: 1
    Desiree,

    How are they trying to access it?
    Are they using DSN (or DSN-Less) connections.

    Are they valid users on the Test Server?
    Can they connect with SSMS?

    Wayne

Posting Permissions

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