SQL Server Management Studio Express

[Michael]

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!

[SYNACK]

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.

[Michael]

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

[SYNACK]

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.

[Michael]

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.