Getting started with SQL Server Express Edition - total newbie
This is a discussion on Getting started with SQL Server Express Edition - total newbie within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello I installed SQL Server Express Edition on my computer but I can't figure out how to get into ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-04-2008, 07:23 AM
| ||||
| ||||
 Getting started with SQL Server Express Edition - total newbie Hello I installed SQL Server Express Edition on my computer but I can't figure out how to get into the Enterprise Manager to create a database. When in click on SQL Server in programs I get Configuration Tools. When I click on Configuration Tools I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Surface Area Configuration. That's all. How to go to the screen to create a database? Roibert      |
|
03-04-2008, 07:23 AM
| |||
| |||
| Re: Getting started with SQL Server Express Edition - total newbie On Mar 2, 7:50 am, "Robert" <cpq1bcle[REMOVE]@verizon.net> wrote: > Hello > > I installed SQL Server Express Edition on my computer but I can't figure > out how to get into the Enterprise Manager to create a database. When in > click on SQL Server in programs I get Configuration Tools. When I click on > Configuration Tools I get SQL Server Configuration Manager, SQL Server Error > and Usage Reporting, and SQL Server Surface Area Configuration. That's all. > How to go to the screen to create a database? > > Roibert You'll have to download and install SQL Server Management Studio from Microsoft's web site and to install it unto your computer. It is the sam tool like Enterprise Manager for SQL Server 2000. After it, when you start the Studio, you'll have to connect to your Server, default instance is (LocalMachine)\SQLEXPRESS. After it, it's all the same like SQL Server 2000. Good luck. Ivan Delic, Serbia |
|
03-04-2008, 07:23 AM
| |||
| |||
| Re: Getting started with SQL Server Express Edition - total newbie Robert (cpq1bcle[REMOVE]@verizon.net) writes: > I installed SQL Server Express Edition on my computer but I can't > figure out how to get into the Enterprise Manager to create a database. > When in click on SQL Server in programs I get Configuration Tools. When > I click on Configuration Tools I get SQL Server Configuration Manager, > SQL Server Error and Usage Reporting, and SQL Server Surface Area > Configuration. That's all. How to go to the screen to create a > database? The plain download of SQL Express comes only with the command-line tools SQLCMD and OSQL. Which certainly are sufficient to create databases, but not very fun to work with in the long run. So you certainly want SQL Server Management Studio Express, which is available for free from http://www.microsoft.com/downloads/d...displaylang=en -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
03-04-2008, 07:23 AM
| |||
| |||
| Re: Getting started with SQL Server Express Edition - total newbie Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 and I got this error message: Installation of MSXML 6.0 Parser failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run MSXML 6.0 Parser Setup again. Why would I want to replace something with a lower version? Robert "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns9A559B74830B7Yazorman@127.0.0.1... > Robert (cpq1bcle[REMOVE]@verizon.net) writes: >> I installed SQL Server Express Edition on my computer but I can't >> figure out how to get into the Enterprise Manager to create a database. >> When in click on SQL Server in programs I get Configuration Tools. When >> I click on Configuration Tools I get SQL Server Configuration Manager, >> SQL Server Error and Usage Reporting, and SQL Server Surface Area >> Configuration. That's all. How to go to the screen to create a >> database? > > The plain download of SQL Express comes only with the command-line tools > SQLCMD and OSQL. Which certainly are sufficient to create databases, but > not very fun to work with in the long run. > > So you certainly want SQL Server Management Studio Express, which is > available for free from > http://www.microsoft.com/downloads/d...displaylang=en > > > -- > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/pro...ads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
03-04-2008, 07:23 AM
| |||
| |||
| Re: Getting started with SQL Server Express Edition - total newbie Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 and I got this error message: Installation of MSXML 6.0 Parser failed because a higher version already exists on the machine. To proceed, uninstall the higher version and then run MSXML 6.0 Parser Setup again. Why would I want to replace something with a lower version? Robert "Ivan Delic" <ivce970@gmail.com> wrote in message news:cf8c701c-deee-46f5-abbd-8dfa105c85de@64g2000hsw.googlegroups.com... > On Mar 2, 7:50 am, "Robert" <cpq1bcle[REMOVE]@verizon.net> wrote: >> Hello >> >> I installed SQL Server Express Edition on my computer but I can't figure >> out how to get into the Enterprise Manager to create a database. When in >> click on SQL Server in programs I get Configuration Tools. When I click >> on >> Configuration Tools I get SQL Server Configuration Manager, SQL Server >> Error >> and Usage Reporting, and SQL Server Surface Area Configuration. That's >> all. >> How to go to the screen to create a database? >> >> Roibert > > You'll have to download and install SQL Server Management Studio from > Microsoft's web site and to install it unto your computer. > > It is the sam tool like Enterprise Manager for SQL Server 2000. > > After it, when you start the Studio, you'll have to connect to your > Server, default instance is (LocalMachine)\SQLEXPRESS. After it, it's > all the same like SQL Server 2000. Good luck. > > Ivan Delic, Serbia |
|
03-04-2008, 07:23 AM
| |||
| |||
| Re: Getting started with SQL Server Express Edition - total newbie Robert (cpq1bcle[REMOVE]@verizon.net) writes: > Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 > and I got this error message: > > Installation of MSXML 6.0 Parser failed because a higher version already > exists on the machine. To proceed, uninstall the higher version and then > run MSXML 6.0 Parser Setup again. > > Why would I want to replace something with a lower version? Did you get this error when you tried to install SSMS Express? Or else why did you try to install MSXML? -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
03-04-2008, 07:23 AM
| ||||
| ||||
| Re: Getting started with SQL Server Express Edition - total newbie Oh, I see there's another message below step 2 telling you not to do the step as in step 1. It's working now. Thanks. "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns9A55F002A7A05Yazorman@127.0.0.1... > Robert (cpq1bcle[REMOVE]@verizon.net) writes: >> Thank you. I tried to install Microsoft Core SML Services (MSXML) 6.0 >> and I got this error message: >> >> Installation of MSXML 6.0 Parser failed because a higher version already >> exists on the machine. To proceed, uninstall the higher version and then >> run MSXML 6.0 Parser Setup again. >> >> Why would I want to replace something with a lower version? > > Did you get this error when you tried to install SSMS Express? Or else why > did you try to install MSXML? > > -- > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se > > Books Online for SQL Server 2005 at > http://www.microsoft.com/technet/pro...ads/books.mspx > Books Online for SQL Server 2000 at > http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
