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 me? Thanks!

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/d...displaylang=en

--
Ekrem Önsoy



"Ac" <Ac@discussions.microsoft.com> wrote in message
news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
> 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 me? Thanks!

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/d...displaylang=en
>
> --
> Ekrem Önsoy
>
>
>
> "Ac" <Ac@discussions.microsoft.com> wrote in message
> news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
> > 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 me? Thanks!
>

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@discussions.microsoft.com> wrote in message
news:04E3B8DC-2E02-4790-9A8C-AFAFCF49C1E3@microsoft.com...
> 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/d...displaylang=en
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Ac" <Ac@discussions.microsoft.com> wrote in message
>> news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
>> > 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 me? Thanks!
>>

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@discussions.microsoft.com> wrote in message
> news:04E3B8DC-2E02-4790-9A8C-AFAFCF49C1E3@microsoft.com...
> > 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/d...displaylang=en
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Ac" <Ac@discussions.microsoft.com> wrote in message
> >> news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
> >> > 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 me? Thanks!
> >>
>

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@discussions.microsoft.com> wrote in message
news:245508BC-6CC1-499D-9DA1-781FC98287ED@microsoft.com...
> 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@discussions.microsoft.com> wrote in message
>> news:04E3B8DC-2E02-4790-9A8C-AFAFCF49C1E3@microsoft.com...
>> > 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/d...displaylang=en
>> >>
>> >> --
>> >> Ekrem Önsoy
>> >>
>> >>
>> >>
>> >> "Ac" <Ac@discussions.microsoft.com> wrote in message
>> >> news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
>> >> > 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 me? Thanks!
>> >>
>>

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@discussions.microsoft.com> wrote in message
> news:245508BC-6CC1-499D-9DA1-781FC98287ED@microsoft.com...
> > 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@discussions.microsoft.com> wrote in message
> >> news:04E3B8DC-2E02-4790-9A8C-AFAFCF49C1E3@microsoft.com...
> >> > 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/d...displaylang=en
> >> >>
> >> >> --
> >> >> Ekrem Önsoy
> >> >>
> >> >>
> >> >>
> >> >> "Ac" <Ac@discussions.microsoft.com> wrote in message
> >> >> news:F72D38A4-A9AE-470A-96BB-417AC26D3E75@microsoft.com...
> >> >> > 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 me? Thanks!
> >> >>
> >>
>
>