I can't open the server - SQL Server Forums

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

Analysis Server and Reporting Services (2005)

I can't open the server

Author

Topic

ndic
Starting Member

5 Posts

Posted - 2010-03-18 : 16:20:14

I've installed Microsoft SQL Server 2005

and I read in (Read me) file that

"After you install SQL Server Express, use the following command
to connect to SQL Server Express by using the command prompt:
sqlcmd -S Server\SQLExpress"

after I entered this command I got error, as shown in the following image

What should I do? I want to create a database for my project

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-18 : 16:59:47

You have to replace "Server" with your actual machine name. Type in hostname at the command prompt to see what it is.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

ndic
Starting Member

5 Posts

Posted - 2010-03-18 : 18:03:22

quote:
Originally posted by tkizer

You have to replace "Server" with your actual machine name. Type in hostname at the command prompt to see what it is.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

The error gone
but at the next line of the command line I get this --> 1>
and whenever I press ENTER the number is increasing
as shown in the following image

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-18 : 18:04:15

That means you are connected and can now start typing in your queries.

If you are new to SQL, you should consider using the GUI tool instead. For Express, it's called SQL Server Management Studio Express.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ndic
Starting Member

5 Posts

Posted - 2010-03-18 : 18:53:37

Thank you so much ^^

I download SSMSE, it's useful ^^

ndic
Starting Member

5 Posts

Posted - 2010-03-18 : 18:56:41

Can you guide me to a website that explain how to use it

Sorry for disturbing you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-18 : 20:44:00

I don't have any links, but I'm sure you can find some with a little googling.