How do i Create DataBase in SQL Server Express Edition

I have installed SQL Server Express Edition - ( Down Loaded )

There I found only three entries such as

SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration

Express Managment tool also i down loaded and installed seperatly..
Exp.Management on start asking ServerInstance Name and Authentication

I tried with (Local) and Windows Authentication - I triend with alternative ways such SQL Server Authentication with default sa user name and pass word.. I didnt able to connect through this tool - show a time out error - says Server is not responding. I am checed SQL server, SQL Browser are running..
All its services are enabled.

I dont have any clue what next...

Is there any alternative tool exists I am using earlier edition of dot net.

So any body can help me to find a proper tool to manage and create databases in SQL server Express Edition.. it will be thankfull
Tongue Tied

Answer this question

How do i Create DataBase in SQL Server Express Edition

Hamid.M
hi Euan,

I can't login with SQL Server authentication thru ExpressManager
user: sa
but it ok with windows authentication.

Express manager doesn't come with GUI to create new database and others
thanks

MM
Mortify
Hi,

I used ID:SA and password:SAPWD.
Error message:
login failed for user 'sa'. Theuser is not associated with trused SQL Server connection.

by the way, im trying a MDI winApp with access SQL2005EE, i could access and add data to database but not other user in the LAN, may i know how do allow winApp access by multi-user over the LAN

thanks
Roger Tan - MS
Express Manager allows you to create databases and run queries right now. In the long run it will allow more, but not right now.

As far as SQL login are you sure you have the right password What error are you getting
yasht
Amazing..it works..

But what is the logic behind this ./ thing.. seems to be a classpath setting like java
souma
Oh man its works....

Euan Garden - where you found this.. I checked all its documentations,nothing i found i suppose to me Remove that from my System.. Oh thank you so much

:)
Gcannar
Are you sure the server supports SQL Server Auth
Ekrem Önsoy
It comes from a concept in SQL Server called Multi Instance. You can have multiple copies of SQL Server on a machine at a time, each one needs a name, but its name is qualified by the machine name. ".", "local" and "localhost" are all shortcuts to machine name. When SQLExpress is installed it is installed into what is called a named instance ie an instance with a specific name, the name of the instance is "SQLEXPRESS",

Hence .\sqlexpress translates to, connect to the local machines sql server instance called sqlexpress.

When you install SQLEXPRESS there is a command switch to let you change the name.

-Euan
help_m_with_extern_linkage
Hi Euan,

I am trying to create sql authorization i SQL Server Express . Windows auhtorization works fine but i am having problems in adding SQL user. After adding user and password when i try to login i get the error:

Error message:
login failed for user 'ab'. The user is not associated with trused SQL Server connection.

Is there any way to add user.

Thanks,

abbi
Jakob Ehn
Your SQL Server does not support sql serevr auth, it supports windows only. Change the connection string to reference SSPI (See BOL for an example) and all will be fine.
郭??
Have you tried connecting with .\sqlexpress
How do i Create DataBase in SQL Server Express Edition

Answer this question