Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    HongKong
    Posts
    3

    Question Unanswered: how about the performance about "sa" a/c?

    any consideration of performance issue when i use "sa" a/c to connect SQL SERVER in java program? will be faster or slower?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Why do you want/need to use the sa account in your application ? This is a big security issue. This account should only be used in a dba capacity situation - outside of an application.

  3. #3
    Join Date
    Jul 2002
    Location
    HongKong
    Posts
    3

    Cool thx

    my connection string is : xxxxx:1433;DatabaseName=rims;User=sa;Password=xxxx

    in my JAVA program, is it wrong? should i use another a/c?

    Originally posted by rnealejr
    Why do you want/need to use the sa account in your application ? This is a big security issue. This account should only be used in a dba capacity situation - outside of an application.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Yes. What are you using the connection for ?

Posting Permissions

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