Results 1 to 2 of 2

Thread: Sql 2005

  1. Jun 13th, 2007, 03:39 AM #1
    basti42
    basti42 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Location
    /root/usr/local/bin
    Posts
    476

    Sql 2005

    hello there!
    i have a question regarding authentication in SQL2005
    i am using MS SQL Server Management Studio Express
    and also created a username same privelege as "sa"

    why is it when logging in to the database there are "Windows Authentication" and "SQL Server Authentication" i need only the SQL Server Authentication because it requires password but in Windows Authentication it will automatically connect to the dataabase, my worry is that what if the user change the value of the database?

    and when deploying sthe program since i have created a new username do i still to install MS SQL Server Management Studio Express? just to create the the new username on the client?(client means it will be the server in deployment not my PC)

    unlike in MS access just set the password nobody will open the database.

    tnx.-
    Reply With Quote Reply With Quote
  2. Jun 15th, 2007, 04:30 AM #2
    ComputerJy
    ComputerJy is offline
    Arabic Poster ComputerJy's Avatar
    Join Date
    Nov 2005
    Location
    Happily misplaced
    Posts
    2,513

    Re: Sql 2005

    Please DO NOT re-post your questions. You can pump the question to the top of the list if you don't get any answers within a couple of days
    "I'm not normally a praying man, but if you're up there, save me... Superman!" - Homer Simpson
    My Blog
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width