How do I log into the MSSQL Express database

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

Express Edition and Compact Edition (2005)

How do I log into the MSSQL Express database

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-25 : 10:33:58

David writes "Dear sir,
I've installed VS.NET 2005 Professional many times and find that the MS SQL Express 2005 is running.
My ambition is to log into this server so that I can convert my MySQL database into it. What is the default;
Hostname
Port
Username
Password

What tool is provided so that I might execute my schema to create a database in this server. This 'schema' will obviously have many tables inside. Most SQL products provide some type of utility program where one can create, edit, delete databases and an adminstration program. I see nothing of yours in my Programs -> MS SQL Server 2005 -> SQL Computer Manager.
Thank you,
David Kennedy"

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-08-25 : 11:04:15

"My ambition is to log into this server ...."
too ambitious !!!

You can log into SQL Express either using SQLCMD command line utility or thru VS.Net 2005 GUI directly. You can create/design/drop database from any of them !

Harsh Athalye
India.
"Nothing is Impossible"

richnl
Starting Member

1 Post

Posted - 2006-10-02 : 04:49:47

I'am trying to install de sample files for databases .

Y use "sqlcmd -S .\SQLEXPRESS -i instpubs.sql "
from de commandline like y read everywhere else but the databases don't
show up in the dropdownbox or anywhere else in vb.net 2005

I did get a whole rundown in de command prompt and in the last line it says
changed database context Master
ending instpubs

What am I missing here??
And what is the -E and the -S stand for??

thanks in advance,
Richard

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-10-02 : 06:09:48

-E -stands for Trusted connection. It means you don't have provide user name and password. It logs on using Windows authentication

-S - stands for SQL Server name to which you are logging on.

BTW, In my case it is working fine. Use following command and post here what you get:

sqlcmd -S .\SQLEXPRESS
1> use pubs
2> go

you should get message which says "Changed database context to 'pubs'" which means you have successfully created the database.

Harsh Athalye
India.
"Nothing is Impossible"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources