+ Post New Thread
Results 1 to 5 of 5
Windows Thread, SQL Server Management Studio Express in Technical; Hello all, I've installed SQL Server Management Studio Express onto my local workstation and can successfully connect to my hosted ...
  1. #1

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340

    SQL Server Management Studio Express

    Hello all,

    I've installed SQL Server Management Studio Express onto my local workstation and can successfully connect to my hosted database, specifying:

    Database Engine
    my IP
    SQL Server Authentication
    Username
    Password


    By expanding databases, I can see my database in the list. My host tells me I need to create a local database (on my workstation), but how do I do that?

    A step by step procedure how to create a local database would be much appreciated!

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,143
    Thank Post
    863
    Thanked 2,695 Times in 2,285 Posts
    Blog Entries
    9
    Rep Power
    772
    You will need to connect to your local instance of SQL2k5 by connecting to:
    {your pc network name}\SQLEXPRESS
    in the logon box ans specifying windows authentication

    You should then be able to expend the databases folder on you local system database engine and simply right click on the Databases folder then select New Database.

  3. Thanks to SYNACK from:

    Michael (21st May 2008)

  4. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    After looking into the problem further, here’s what I found out. Installing just SQL Server Management Studio Express is a waste of time. It lacks a lot of the other components used with SQL server. Downloading SQL Server 2005 Express Edition with Advanced Services SP2 weighing in at 234MB is more appropriate. The information from my host to use just SQL Server Management Studio Express is incorrect.

    When installing SQL Server 2005 Express Edition with Advanced Services SP2, you need to enable all optional components throughout the installation.

    Navigate to Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration

    Click the Surface Area Configuration for Services and Connections link

    Enable Remote Connections for Local and Remote Connections, Using both TCP/IP and named pipes. You also need to enable the SQL Server Browser service. Apply all changes.

    Then choose:

    Database Engine
    WorkstationName\SQLExpress
    Windows Authentication


    Create the new Database

  5. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,143
    Thank Post
    863
    Thanked 2,695 Times in 2,285 Posts
    Blog Entries
    9
    Rep Power
    772
    Oh you just had the Management Studio installed, I assumed that you had the whole lot, my bad. Anyway if you are just using the database locally you should be able to get away with just enabling shared memory, you only need the TCP if you are accessing from a remote PC. Good to hear that you got it sorted.

  6. #5

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    I've also found out that the Import/Export feature in SQL 2000 has been removed from SQL 2005 Express. Fortunately I remembered I had SQL Server 2005 Standard on DVD, which does allow the Importing/Exporting of databases to and from my host.

    I now have two files located in: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

    FILE.mdf
    FILE_log.ldf

    I presume these are essentially my database which I should backup? It's especially important as SQL Injection attacks are on the rise Even Edugeek could be at risk as it uses MYSQL too.

SHARE:
+ Post New Thread

Similar Threads

  1. Setting Up An Exchange Server On Outlook Express 6
    By My220x in forum How do you do....it?
    Replies: 1
    Last Post: 16th May 2008, 01:32 PM
  2. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM
  3. Search Server 2008 Express
    By cookie_monster in forum Windows
    Replies: 7
    Last Post: 9th March 2008, 11:37 AM
  4. SIMS SQL upgrade. To Express or not to Express?
    By woody in forum MIS Systems
    Replies: 5
    Last Post: 16th October 2007, 04:34 PM
  5. Visual Studio Express edition
    By GrumbleDook in forum Educational Software
    Replies: 6
    Last Post: 21st April 2006, 07:54 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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