newbie question

Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
Nico
Yes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico
|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

newbie question

Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

newbie question

Hello,
I am studying for my exam and I have a question. I have a sql server
in a domain and when the domain administrator tries to access it, he
has no problems!! But in the literature it says that a domain
administrator must be in a group that has access to the sql server in
order to connect to that server, which is not the case? Does it have
somehing to do with the builtin\administrator account?
Kind regards,
NicoYes. By default, a domain admin will get added to the local admin group when
the box joins the domain. That means a domain admin is part of the
builtin\admin group. Thus, he/she has full access to sqlserver.
"Nico" <nico.barbe@.mobiusREMOVEFORSPAM.be> wrote in message
news:eZXCly2jEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I am studying for my exam and I have a question. I have a sql server
> in a domain and when the domain administrator tries to access it, he
> has no problems!! But in the literature it says that a domain
> administrator must be in a group that has access to the sql server in
> order to connect to that server, which is not the case? Does it have
> somehing to do with the builtin\administrator account?
> Kind regards,
> Nico|||By default, domain admin will be a member of local Administrators group
which essentially maps to BUILTIN\ADMIN account on SQL Server. However if
for some reason, someone has disabled or removed the builtin\admin account
from SQL, if the domain admin is part of another group on the server, and
if that other group is a registered user within SQL Server, then the domain
admin will have access to SQL through this other group even if
builtin\admin is disabled or removed.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

NewBie Here: Need Help Please (SQLCommand)

Hi Guyz, im currently studying asp.net, i need a code that retrive data from SQL database and post it using Label (web from), i dont know how to do it, need help... Thanks in advance !!!!

Hi There,

First of all import sqlclient namespace

using System.Data.SqlClient;

Read data from sql database and set value to Label1 and Label2

protectedvoid Page_Load(object sender,EventArgs e)

{

// Create database connection

SqlConnection connection =newSqlConnection("YourConnectionString");

// Create instance of command

SqlCommand command =newSqlCommand("Select Field1, Fields2 From TableName", connection);

// Open database connection

command.Connection.Open();

// Execute command and get datareader

System.Data.SqlClient.SqlDataReader datareader = command.ExecuteReader();

// Check whether or not datareader has soemthing

if (datareader.Read())

{

Label1.Text = datareader.GetString(0);// get Field1

Label2.Text = datareader.GetString(1);// get Field2

}

// Close database connection

command.Connection.Close();

}