Re: SQL 2005 Express setup

Thanks Ekrem! It works well.

"Ekrem Önsoy" wrote:

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)
  • Re: GRANT CREATE DATABASE versus GRANT ALTER ANY LOGIN
    ... server, and is a member of the sysadmin server role. ... could not grant "alter any login" permission to a domain login. ... server or it has been removed "sysadmin" server role. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • 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)