Re: SQL 2005 Express setup

Thank you very much. It works well!

I installed the Microsoft SQL Server Management Studio Express as an
administrator in my computer. However, I would like to use the SQL Server
2005 Express on my own login. If I used my own login, I could connect to the
database, but could not create a new database (new database for my project),
the system stopped me because I did not have the permission. Then, I login in
as an administrator to my local machine and created a new table, it worked
well.

Which steps I set up wrong that I could not use my own login? Thanks again!







"Ekrem Önsoy" wrote:

There is no a GUI coming with SQL Server 2005 Express Edition. You can check
out if your SQL Server service is running or not by using SQL Server
Configuration Manager or Services MMC.

You can download the GUI' s limited (but for free) version (which is SQL
Server Management Studio Express) from the following link:
http://www.microsoft.com/Downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

--
Ekrem Önsoy



"Ac" <Ac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@xxxxxxxxxxxxxxxx
Hi ,

I am new for SQL 2005 Express version, and I have downloaded the SQL 2005
Express Edition. After the download, I try to open the program, the steps:
Start/All programs/Microsoft SQL Server 2005, after that I only have two
choices (sub menu): Configuration Tools and Documentation and Tutorials,
but
do not have the SQL 2005 Express Edition as a sub menu. What do I do
wrong? I
have a Window 2003. Could you please help me? Thanks!

.

Relevant Pages

  • Re: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: Domain Admin login failure.
    ... specific login in SQL Server. ... Then it won't need it's admin privileges. ... Rick Byham, SQL Server Books Online ... administrator, it will let my domain admin account login. ...
    (microsoft.public.sqlserver.security)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Vista Enterprise and SQL Server 2005 Agent
    ... You just need to make sure that the login that you are using has it's own login in SQL Server, and that the login being used by the SQL Server Agent is a member of the SQL Server sysadmin fixed server role. ... It all seems to be related to security things, even though I am an administrator. ... I loaded SQL Server Management Studio the other day and decided to start the SQL Agent service. ...
    (microsoft.public.sqlserver.security)
  • Re: Back up on remote computer.
    ... Do the Administrator account have the same password on the two machines? ... Tibor Karaszi, SQL Server MVP ... The error says that location of the (backup) file ... Create a login on the SQL host computer. ...
    (microsoft.public.sqlserver.server)
Loading