newbie helps - but I can not find Management Studio now.

Hot Topic

PDF Output
SQL Express Family CTP Now Available
Attach feature not working right
Aggregation Question
Reporting services presentation problems
FTP Connection Manager: Set FTP password using a variable
SQL Server 2005 Upgrade Advisor not detecting known issues.
CD
Need help to make query
Newbie trying to get specific data from an SSE Database

SQL Server

Urgent need for problem of increase in database size for ntext type fields
Experts required to validate these statements of fact
Code Access Security across multiple assembly security extension
Problems saving edited Functions in SQL server database using Visual Studio .Net 2003
Complicated Query with Subs for Grand Total
Problem with nested try catch blocks in SQL 2005
Passing connection managers to subpackages.
Instert found records into DB
How to tie together all tabs
Management Studio Express CTP update now available

newbie helps - but I can not find Management Studio now.

just finished installing SQL Express, and now, dont know what to do next :)
- I have installed FULL. Does it have any GUI tool for me to create a database
- how can I login into system
- how can I restore a backup file I have a backup file from SQL 2005 standard
- how can I create backup for databases

thanks

Answer this question

newbie helps - but I can not find Management Studio now.

  • Ramskar

    Use the SQL Server Management Studio Express Edition

  • Chike_

    I am also new to the product. I just installed the 2005 Express with Advanced Services and rebooted my machine. Now I am looking to see how I can start the Management Studio Express. I do not see it in my program list and I did not receive any installation errors. Can you help me

    thank you very much

  • lumbus

    Hi Glenn,

    thanks for your help. However, after doing your steps, the error message appears
    "User, group or role "username" already exists in the current database" (Microsoft SQL Server, Error: 15023)

    How can I fix this And I am sure the connection string is good, cause I can use it with another server :(

    thanks

  • Mal Hornsby

    You can download it here http://www.microsoft.com/downloads/details.aspx familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

  • Jason Rockenbach

    Hmm.. How I understand the error message is that the user is already configured to your database. Try to skip #2.

    Sorry for the delay in responding your forum. I only attend it during my free time. ;-)

    Cheers,
    Glenn

  • Nate Heaton

    If you want to use the SQL login, then you must create a new user from Management Studio Express.

    On creating a SQL user, go to Security-->Logins. Then create a new user, In the property page of the user, please set the following:

    1. General Tab--> Default Databse to logon
    2. User Mapping--> Map the databse that will be use
    3. Status --> Have the permsion to login

    Are you using Visual .NET 2005 If yes, use database explorer to help you with the connection string settings.

    Cheers,

    Glenn

  • WernerF

    Thanks. I have installed it. Now, after logging in, I can create new database (db1), create new user (new login ) with default db is the database just created above (db1). But, I cannot use it with my code

    StrDB="DRIVER={SQLServer};Server=localhost;UID=username;PWD=password;Language=us_english;Database=db1"


    What should I do now

    thanks
  • newbie helps - but I can not find Management Studio now.
Answer this question