Post reply

Visual Studio 2005's quiet install of SQL Express 2005

  • October 19, 2007 at 12:28 pm

    #120806

    Rant Mode On...

    OK So I Installed Visual Studio 2005 on my development machine, and it installed SQL Express without any user interface prompts....

    That's a little annoying because I didn't get to assign the sa password, nor was I prompted for the Authentication mode...windows Auth only or mixed mode....all our apps use mixed mode, so that would be important to me.

    after installation I find that the Management Studio is not installed either, so I don't have an easy interface to fix those kinds of items.

    Running the Add/Remove programs for SQL Server 2005 /Modify doesn't bring up those options during a re-install either... now I'm a bit irked.

    Ok fine...i can change the sa password with sp_password, since I'm a local admin.

    Change the Authentication mode? As far as I could tell after a bit of research, it's not a server option or db option. you cannot do it via TSQL.

    One solution I saw was a regedit to change a key, but that key for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\LoginMode did not exist,a nd adding it had no effect, even after a start/stop of the service.

    I ended up reading this article, and downloading the 264 meg version of SQL Server 2005 Express Edition with Advanced Services SP1

    http://articles.techrepublic.com.com/5100-9592-6102265.html

    Installing THAT gave me the control I needed. Basically i'm whining because Studio didn't prompt me for these kinds of items, and running the reinstall doesn't let you do it either.

    ..Rant Mode Off

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 19, 2007 at 1:06 pm

    #743767

    I realize it's a tad bit late since you've already downloaded the 268MB version...but there was a standalone SSMS Express (just SSMS, not the whole thing) download out there. About 20MB as I recall.;)

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • October 30, 2007 at 2:49 pm

    #746874

    I was wondering the same thing and it turns out that once you install management studio express you can change the authentication mode by right clicking on the root server in the studio after you login via your windows account, then select security and change it under Server authentication. It worked for me, I didn't want to install it again or have multiple sqlexpresses running.

    I had to update the sa password and enable the account to use sa.

    Hope that helps.

    Kevin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply