Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161

    Unanswered: MS SQL Server 2005

    Im trying to get started on MS SQL Server 2005 Express Edition - is there any interface where I can create databases, tables etc ? Im used to MySQL and phpMyAdmin.

    I cant get to decide between Windows authentication and SQL Server authentication when logging in - is there no root kinda login ?

    Thanks
    MySQL 5.1

  2. #2
    Join Date
    Apr 2006
    Posts
    33
    Download Management Studio Express:
    http://msdn.microsoft.com/vstudio/express/sql/download/

    Use Windows Authentication unless you have a reason to use mixed (SQL Server + Windows). Admins on the local computer will be members of the sysadmin role - can perform any operation (e.g. root access).
    There is also a sa SQL Server logon that is a member of the sysadmin role - this is created regardless of the authentication type, but you can only use it if mixed mode authentication is enabled.

    Windows - You are authenticated automatically based on your Windows/Domain user account.
    SQL Server - You have to supply a username and password.
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

  3. #3
    Join Date
    Apr 2006
    Posts
    33
    Sorry, forgot to mention - it's possible to change the authentication mode after you have installed SQL Server. If you use mixed, be sure to use a strong password for the sa account - if you are developing applications, don't use the sa account in you application. Create another account with just enough permissions to perform its functions.
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

  4. #4
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    Oh..it seems a new version of SQL Exp 2005 is out - with SP1 and with advanced services.

    Im going to uninstall the current MS SQL Server 2005 Exp and install the one with advanced services.

    Will SQL Server Management Studio Express work with the Advanced Services version ?
    MySQL 5.1

  5. #5
    Join Date
    Apr 2006
    Posts
    33
    I've not tried the advanced services version, but the management studio express is almost certain to work with it. Also, I suspect the install might include managment studio express rather than a seperate install - just a speculation...
    David Wiseman
    MCSE, MCSA, MCDBA

    www.wisesoft.co.uk

Posting Permissions

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