Showing posts with label nt5. Show all posts
Showing posts with label nt5. Show all posts

Monday, March 12, 2012

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> > background: sql2k on nt5.
> >
> >
> >
> > Can someone tell me a secured way to set up a secured linked server?
> >
> > In the past, I have been using sa account and its password to set up a
> > linked server, but a regular user with limited permissions on ServerA
can
> > issue any commands to a linked ServerB as sa account, right?
> >
> >
> >
> > Is there a way to limit the use of a linked server to a NT group with
sql
> > admins role?
> >
> >
> >
> > Thank you.
> >
> >
> >
> >
>

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.
You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>
|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"[vbcol=seagreen]
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
can[vbcol=seagreen]
sql
>

How to use linked server securely?

background: sql2k on nt5.
Can someone tell me a secured way to set up a secured linked server?
In the past, I have been using sa account and its password to set up a
linked server, but a regular user with limited permissions on ServerA can
issue any commands to a linked ServerB as sa account, right?
Is there a way to limit the use of a linked server to a NT group with sql
admins role?
Thank you.You probably ought to read Books Online subject: "linked servers, security"
This is potentially a big subject that can't be effectively dealt with via
message boards...
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
> background: sql2k on nt5.
>
> Can someone tell me a secured way to set up a secured linked server?
> In the past, I have been using sa account and its password to set up a
> linked server, but a regular user with limited permissions on ServerA can
> issue any commands to a linked ServerB as sa account, right?
>
> Is there a way to limit the use of a linked server to a NT group with sql
> admins role?
>
> Thank you.
>
>|||I have read that subject i BOL.
it doesn't make much sense to me.
If I were to have a NT group called sqladmins, and i assign Bob, Chris, and
Doug to that group.
I have 2 servers, ServerA and Server B. I want sqladmis to be able to query
ServerB (any database, such as sysobjects in master database) from ServerA,
but not for other users not belong to that group.
What should I do?
Pls help! Thank you
"Don Peterson" <no1@.nunya.com> wrote in message
news:eYOCHX6NEHA.3744@.TK2MSFTNGP11.phx.gbl...
> You probably ought to read Books Online subject: "linked servers,
security"
> This is potentially a big subject that can't be effectively dealt with via
> message boards...
> "== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
> news:ehtZt75NEHA.1396@.TK2MSFTNGP10.phx.gbl...
can[vbcol=seagreen]
sql[vbcol=seagreen]
>

Friday, February 24, 2012

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
--
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.
BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>
|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

how to use bcp utility..

sql2k on nt5.
i'd like to learn how to use bcp utility like bringing a Access mdb file
(just a table) into northwind database on sql server.
where should i run it and what the sytax should be like? (use trust
connection)
thank you.BCP is not the tool for bringing in a mdf. Take a look at DTS in
BooksOnLine for that.
Andrew J. Kelly SQL MVP
"== Steve Pdx==" <lins@.nospam.portptld.com> wrote in message
news:eR2K5K8MEHA.3636@.TK2MSFTNGP09.phx.gbl...
> sql2k on nt5.
> i'd like to learn how to use bcp utility like bringing a Access mdb file
> (just a table) into northwind database on sql server.
> where should i run it and what the sytax should be like? (use trust
> connection)
> thank you.
>|||BCP is just for importing text files. It is documented in Books on Line as
well.
Rand
This posting is provided "as is" with no warranties and confers no rights.