SQL Server Management Studio Express DB creation

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Server Management Studio Express DB creation

Author

Topic

cseward
Starting Member

24 Posts

Posted - 2011-09-19 : 08:04:12

I'm a new member as of this morning. In my last job, the transaction software that we used had an SQL DB behind it. I used SQL Server Management Studio Express to query the data and create stored procedures, etc.
In my current job, I don't have access to the SQL DB where their data is stored. They're in the process of designing a new DB. For now, the technical consultants will be sending me an CSV file that I can use to build one big table that I can use to report on. I thought I could use the SQL Server Management Studio Express to create an small SQL DB with the one big table. I was only able to create and SDF (Standard database file). I use Crystal Reports to build reports, but Crystal does not support SDF DBs. I imported the CSV data to Access and was able to connect to the Access DB with Crystal Reports.
So, I have a few questions.

1. Is there a difference between SQL Server Express and SQL Server Management Studio Express ? Are they 2 separate tools ? I'm not clear on this.

2. Does anyone know if it's possible to create and SQL DB locally ?

I hope my questions make sense and I hope someone can help.

Thanks !

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-19 : 08:10:27

1. SQL Server EXpress refers to express DB engine whereas SQL Server Management Studio Express is desktop client tool used to connect to DB
2.Its possible to create sql db locally provided you've installed any version of SQL DB engine in your machine.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-09-19 : 08:37:07

So, are you saying that SQL Server Express and SQL Server Management Studio Express are 2 separate programs ?

How do I install some version of SQL DB engine on my machine ? Would this be downloading SQL Server Express ?

Actually, I thought I installed SQL Server Express, but what I have on my machine says SQL Server Management Studio.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-19 : 09:16:54

yep..they're
SQL Server Management Studio Express comes with desktop tools

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-09-19 : 11:01:14

I very much appreciate your replys,however, I'm still a bit confused. Do you think I need to download SQL Server Express ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-19 : 11:17:35

first go to services.msc and check if you've service for MS SQL SERver express running. If it is, then that means you've installed sql express. if not, you need to download and install sql express.
Now go to start-> programs and check if you've SQL Server 2008 -> SQL Management studio available as an option. If yes, no problem. click open and connect to your local server. if not, you need to install SQL Server Express desktop tools and then try to connect to installed (or already present) sql server on local machine (normally name will be yourmachinename\sqlexpress )

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

cseward
Starting Member

24 Posts

Posted - 2011-09-19 : 14:59:39

See the message below when I tried to connect to
Server Type:Database Engine
Server Name:my machine name\SQLEXPRESS
Authentication: Windows Authentication

TITLE: Connect to Server
------------------------------

Cannot connect to OPTI380-10-CS\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-19 : 15:11:28

you tried OPTI380-10-CS\SQLEXPRESS as the name rite?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources