Re: SQL 2005 Express setup

Hi Ekrem,

I try to do it from SSMSE, but I could not find the right place; where is
the "properties of your Login" from the Logins node? I found the Logins node
but not the properties, and the "Server Roles" is the node below the "Login"
node. Do I misunderstand something here?


"Ekrem Önsoy" wrote:

Because SQL Server would create a Login for Local Administrators and add
this Login to the System Administrator "sysadmin" role. So, members of this
role can perform any task against that SQL Server Instance.

You should give Logins \ Users permissions only what they need. However, if
you want your Login to be a System Administrator, then you should log in to
your SQL Server Instance as a System Administrator and add your own Login to
the sysadmin Fixed Server Role.

You can use the following command to add your Login to the "sysadmin" server
role.
EXEC master..sp_addsrvrolemember @loginame = N'Test_Login', @rolename =
N'sysadmin'

Or, you can use SSMSE to perform this. Login to your SQL Server Instance as
a System Administrator. Go to Security node and expand it. Go to properties
of your Login from the Logins node and from the Server Roles, assign your
Login to this role.

P.S.
You should be using a Login which is a member of the sysadmin role to
perform this task.

--
Ekrem Önsoy



"Ac" <Ac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04E3B8DC-2E02-4790-9A8C-AFAFCF49C1E3@xxxxxxxxxxxxxxxx
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: SQL 2005 Express setup
    ... Because SQL Server would create a Login for Local Administrators and add this Login to the System Administrator "sysadmin" role. ... However, if you want your Login to be a System Administrator, then you should log in to your SQL Server Instance as a System Administrator and add your own Login to the sysadmin Fixed Server Role. ...
    (microsoft.public.sqlserver.setup)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
Loading