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
[1038 byte] By [
Aiby] at [2008-2-7]
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
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?
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
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
