Re: SQL 2005 Express setup

Step by step:

- Open SSMSE,
- Connect to your SQL Server Instance,
- Expand the "Security" node,
- Expand the "Logins" node,
- Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu,
- "Login Properties" window will pop up,
- Go to "Server Roles" from the list at the left side of the window,
- Mark the "sysadmin" checkbox to make this Login a member of this Server Fixed role,
- Click OK.

Login is a member of the "sysadmin" fixed server role now.

--
Ekrem Önsoy



"Ac" <Ac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:245508BC-6CC1-499D-9DA1-781FC98287ED@xxxxxxxxxxxxxxxx
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: SQL2005: Cannot connect error 11001
    ... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
    (microsoft.public.sqlserver.connect)
  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)
  • Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
    ... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL 2005 Express setup
    ... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
    (microsoft.public.sqlserver.setup)