Active Directory....

Is it possible to use active directory to maintain the login activities of
SQL Server 2K?
Thanks,
Jessy
Hi
AD can be used to authenticate the user (NT Integrated Security), but AD
does no logging itself of access.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jessy Martin" <Jessy_Smith79@.hotmail.com> wrote in message
news:uwoIuukZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Is it possible to use active directory to maintain the login activities of
> SQL Server 2K?
> Thanks,
> Jessy
>
>

Active Directory....

Is it possible to use active directory to maintain the login activities of
SQL Server 2K?
Thanks,
JessyHi
AD can be used to authenticate the user (NT Integrated Security), but AD
does no logging itself of access.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jessy Martin" <Jessy_Smith79@.hotmail.com> wrote in message
news:uwoIuukZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Is it possible to use active directory to maintain the login activities of
> SQL Server 2K?
> Thanks,
> Jessy
>
>

Active Directory....

Is it possible to use active directory to maintain the login activities of
SQL Server 2K?
Thanks,
JessyHi
AD can be used to authenticate the user (NT Integrated Security), but AD
does no logging itself of access.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jessy Martin" <Jessy_Smith79@.hotmail.com> wrote in message
news:uwoIuukZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Is it possible to use active directory to maintain the login activities of
> SQL Server 2K?
> Thanks,
> Jessy
>
>

Active Directory Groups Don't Work with Linked Server?

I mapped a login created with an Active Directory Group on server A to a login on server B through a linked server on server A and received a null login error when attempting to connect.

I changed the Active Directory Group login to an individual active directory login and the connection worked fine.

I saw someone post online somewhere that Active Directory Groups don't work with linked server by design--but I wanted to get confirmation on this. Can anyone confirm this, particularly someone from Microsoft?

This might be the dreaded "Double-hop" scenario. There's a great rundown by a Microsoft Protocols Engineer here:

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

That will get you started on learning why this is happening.

Active Directory Groups Don't Work with Linked Server?

I mapped a login created with an Active Directory Group on server A to a login on server B through a linked server on server A and received a null login error when attempting to connect.

I changed the Active Directory Group login to an individual active directory login and the connection worked fine.

I saw someone post online somewhere that Active Directory Groups don't work with linked server by design--but I wanted to get confirmation on this. Can anyone confirm this, particularly someone from Microsoft?

This might be the dreaded "Double-hop" scenario. There's a great rundown by a Microsoft Protocols Engineer here:

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

That will get you started on learning why this is happening.

Active directory + list users

I neet save user login form active direcotry to databases. How I can make that?

If you're using Trusted Security to connect to the database (In other words, every single user is authenticated to the database with their windows logon), you could write code like the following at the database level:

INSERT Users
(Username)
(SUSER_SNAME())

SUSER_SNAME, gives you the current authenticated user to the database.

If you're connecting to the database using a Sql Server Login, but are using windows authentication in your .net application you could write the following code:

Dim _sql as string
_sql = "INSERT Users (USERNAME) VALUES ('" + My.User.Name "')"

And just execute this code against the database.

Hope this helps,

Acessing SQL through a DOS login script

Does anybody know if it is possible to pass an NT Environment variable to an SQL Server and then return the results back to the DOS?

Example: when a user logs in, their username is stored in the environment variable %USERNAME%. I would like to send this to SQL and then look up their department and then depending on what department they are in, different drives are mapped.

I think this would be done with stored procedures, but I am quite new to these.

Many thanks in advance
Matt CottrellYes I believe you can, try this from DOS, substring in your login criteria

isql -Uxx -Pxx -Sxx -n -Q"PRINT '%USERNAME%'"

You can then create a stored procedure that "PRINTS" out the drive mapping

"NET USE D: \\Server\Home "

Have your script file pass the USERNAME in then redirect the output to a file and run the file from the DOS command script

Example
isql -Uxx -Pxx -Sxx -n -Q"sp_MakeMappings '%USERNAME%'" -oC:\temp\mapping.cmd

C:\temp\mapping.cmd

del C:\temp\mapping.cmd

Accidentally disable admin login

Hi, I have accidentally disabled the Administrator account in Sql Server 2005 (Douh!) on my clients server (double Dough!) & now I can login to enable it.

The <BuiltIn\Administartors> account is still active, The accout i disabled was <Domain\Administrator> (forgot I was logined via Terminal server).

Any help/assistance would be much appreciate!!

Cheers,

Nez

HI, i was unable to delte this post so may as well put the answer here.

to enable it again i used the SQLCMD.exe in the ".../90/tools/binn" folder

sp_grantlogin etc...

Cheers

|||Appreciate your solution and feedback here, in this case you can take help of DAC too if there is no other route.

Accessing Reports

My host provides access to Report Manager and Report Server with the same
login and password for my SQL Server. For obvious security reasons, I do
not want to pass these out to my client to access their reports. My host
has mentioned consuming the report and using the "credentials" properties to
pass the login info to the Report Server.
I have not learned enough about .NET to understand how to do this, as I am
still use classic ASP for many applications, so this is Greek to me. I was
hoping
this would be easy to do and if someone could point me in the right
direction.
Thanks so much,
BrianWhat your host is suggesting is very difficult to do. It requires creating
a separate web page that gets a report using SOAP and streams back the
report HTML (and, separately, the images, because the browser will ask for
them separately).
Direct URL access to the ReportServer is the easiest way to handle it, and
yes, it's a good idea to have a different user name and password for that
operation.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"mistybrian" <mistybrian@.discussions.microsoft.com> wrote in message
news:6596972D-86B6-47EB-8B73-535D5BAB50BD@.microsoft.com...
> My host provides access to Report Manager and Report Server with the same
> login and password for my SQL Server. For obvious security reasons, I do
> not want to pass these out to my client to access their reports. My host
> has mentioned consuming the report and using the "credentials" properties
> to
> pass the login info to the Report Server.
> I have not learned enough about .NET to understand how to do this, as I am
> still use classic ASP for many applications, so this is Greek to me. I
> was
> hoping
> this would be easy to do and if someone could point me in the right
> direction.
> Thanks so much,
> Brian
>|||Thanks for that information, Jeff. I hoped there would be a simple solution,
but I suppose my host is assuming that everyone is a .NET developer and could
do this with ease.
Thanks,
Brian
"Jeff A. Stucker" wrote:
> What your host is suggesting is very difficult to do. It requires creating
> a separate web page that gets a report using SOAP and streams back the
> report HTML (and, separately, the images, because the browser will ask for
> them separately).
> Direct URL access to the ReportServer is the easiest way to handle it, and
> yes, it's a good idea to have a different user name and password for that
> operation.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "mistybrian" <mistybrian@.discussions.microsoft.com> wrote in message
> news:6596972D-86B6-47EB-8B73-535D5BAB50BD@.microsoft.com...
> > My host provides access to Report Manager and Report Server with the same
> > login and password for my SQL Server. For obvious security reasons, I do
> > not want to pass these out to my client to access their reports. My host
> > has mentioned consuming the report and using the "credentials" properties
> > to
> > pass the login info to the Report Server.
> >
> > I have not learned enough about .NET to understand how to do this, as I am
> > still use classic ASP for many applications, so this is Greek to me. I
> > was
> > hoping
> > this would be easy to do and if someone could point me in the right
> > direction.
> >
> > Thanks so much,
> >
> > Brian
> >
> >
>
>

accessing problem

I want two things:

- Let the windows account be the login on the SQL server. This is not a problem.

1. But I also want to use the windows login as authentication method for the webpage. The users have to explicitly log-in.
2. Is it a problem to retrieve all users within a windows domain?

Im using .net 2003.Are you getting any errors?|||well the thing is I can only do this one by one. isn't there a way to automize this? And i can link them to the data that is already in the databse. it contains migrated data from an Lotus Notes app.

Greets,
geoff