Adding Win 2000 account to SQL Server database role

According to SQL Server 2000 Books online:
"When you add a Windows NT 4.0 or Windows 2000 login without a user account
in the database to a SQL Server database role, SQL Server creates a user
account in the database automatically, even if that Windows NT 4.0 or Window
s
2000 login cannot otherwise access the database".
My Questions: How can you add a login to a role without a user account (with
that login) in the database? So, I don't understand the above comments. I wa
s
unable to create the above example since I had to create a win 2000 login as
a user in the database first before adding that login to a role. Can someone
please explain the above comments?
Thanks,
KevMaybe you were trying it just through Enterprise Manager?
You need to use the system stored procedure to do this. Try
the following:
Create a new user on the machine.
In Query Analyzer, execute the following:
use northwind
go
sp_addrolemember 'db_datareader', 'YourMachine\YourUser'
The windows account will show up a user in the database with
access via group membership. You don't have to first add the
login or add the user to the database.
-Sue
On Wed, 21 Sep 2005 08:06:04 -0700, Nam
<Nam@.discussions.microsoft.com> wrote:

>According to SQL Server 2000 Books online:
>"When you add a Windows NT 4.0 or Windows 2000 login without a user account
>in the database to a SQL Server database role, SQL Server creates a user
>account in the database automatically, even if that Windows NT 4.0 or Windo
ws
>2000 login cannot otherwise access the database".
>My Questions: How can you add a login to a role without a user account (wit
h
>that login) in the database? So, I don't understand the above comments. I w
as
>unable to create the above example since I had to create a win 2000 login a
s
>a user in the database first before adding that login to a role. Can someon
e
>please explain the above comments?
>Thanks,
>Kev

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan
|||There it is. Thank you!
|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad

Adding Integration Services Node in Server Management Studio

Hi,
Am just getting started with SSIS. Based on an article I saw online, I would expect to find an "Integration Services" node in Server Management Studio, but I don't see this node. I'm trying to create and execute a simple package.
Running...
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
...on a named instance.
Thanks,
krog
Have you tried in Object Explorer

Connect | Integration Services

Allan|||There it is. Thank you!|||I am testing this on Windows XP and when I run SSIS, I can connect to server but I don't see a way to connect to Integration Services. I see in the Providers folder DTSPackage but how do I execute this assuming this is what I need. I am new to SQL Express and I am trying to import a DBF file and create a database.

Neil|||I am trying to connnect through Object Browser, but I am getting Access Denied error. Please note I am not the Admin on the box. What kind of permission I need to register Integration Services connection on my Management studio? Finally I want to import some packages I developed on msdb.

Thanks|||Hi,

I am also experiencing Access Denied errors when using object explorer (on my workstation) to connect to SSIS.

I have searched and tried some tips but I am still not able to connect. I am a local administrator on the sql server, i have added myself to db_dtsadmin role in the msdb database.

Can anyone please shed some light on how to connect remotely to SSIS.

Thanks,
Jason|||SSIS only comes with Standard edition and above. SQL Express does not include SSIS.|||

Any additional information about this?

I also recieve "Access denied" when attempting to add an Integration Service connection through the object browser. It works fine on a co-worker's workstation. I have disabled my firewall. I'm on the same subnet as my co-worker who is able to connect.

Best regards,

Shad