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. 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 Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • 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)