The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Preloaded SQL Server on Z46

    Discussion in 'VAIO / Sony' started by ivanng, Jul 29, 2009.

  1. ivanng

    ivanng Newbie

    Reputations:
    0
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    5
    Hi Guys, I dont know how to use this SQL Server. No tools to create/modify table.

    I think it is better to install SQL Server Management Studio 2005. But I cannot install it.

    Not sure which version of SSMS is suitable for the Pre loaded SQL server.

    Hope someone can help.
     
    ivanng, Jul 29, 2009
    #1
  2. chong67

    chong67 Notebook Deity

    Reputations:
    6
    Messages:
    1,170
    Likes Received:
    0
    Trophy Points:
    55
    Maybe you didnt install everything. Try doing that.
     
    chong67, Jul 29, 2009
    #2
  3. ivanng

    ivanng Newbie

    Reputations:
    0
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    5
    install like what????

    Thanks...
     
    ivanng, Jul 29, 2009
    #3
  4. chong67

    chong67 Notebook Deity

    Reputations:
    6
    Messages:
    1,170
    Likes Received:
    0
    Trophy Points:
    55
    Install everything, include the docs.

    I install the regular SQL Server on my desktop. It should work on the Z.
     
    chong67, Jul 29, 2009
    #4
  5. ScuderiaConchiglia

    ScuderiaConchiglia NBR Vaio Team Curmudgeon

    Reputations:
    2,674
    Messages:
    6,039
    Likes Received:
    0
    Trophy Points:
    205
    But the OP is not talking about installing SQL Server. He is talking about using the instance that came pre-installed on his machine.

    The problem with the pre-installed instance is it is not installed in a fashion that will easily allow you to use it for anything else except for the purpose it was put there by Sony. That purpose is in support of the Vaio Entertainment Platform. This is a media player system for VAIO machines and SQL server is used as a database for metadata about your media files.

    The problem with the installation being used for other purposes is that Sony chose to install it as what is called a "named instance" rather than a "default instance". This makes it more difficult to use with the management tools etc.

    The OP would be better off installing a default instance and the management tools so they easily create and use their own databases. It CAN be done with a named instance but it is a hassle.

    Look up SQL SERVER 2005 NAMED INSTANCE on Google for more details.

    Gary
     
    ScuderiaConchiglia, Jul 29, 2009
    #5