How to determine if a Windows Auth ID is no longer valid in SQL?

How can we proactively find out when a Windows Authentication ID in SQL
Server is no longer valid, i.e. an employee is no longer with the company so
we should delete their related Windows Authentication user IDs from our SQL
Server databases?Don't you have an employee table that lists the AD login and whether the
employee is active or not? Some companies store this data directly in AD.
You need to find out where the information is stored though, before we can
tell you how to fix your issue.
Another question...are they disabling the AD account? If you were using AD
groups, instead of individual logins, you would no longer have to worry abou
t
an individuals access. It's also easier to manage and delegate management
responsibility to the business and HR.
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"Stephanie" wrote:

> How can we proactively find out when a Windows Authentication ID in SQL
> Server is no longer valid, i.e. an employee is no longer with the company
so
> we should delete their related Windows Authentication user IDs from our SQ
L
> Server databases?
>|||I found the sp_ValidateLogins very helpful.
To quote the BOL - "Reports information about orphaned Microsoft? Windows
NT? users and groups that no longer exist in the Windows NT environment but
still have entries in the Microsoft SQL Server? system tables."
Randy
"Stephanie" wrote:

> How can we proactively find out when a Windows Authentication ID in SQL
> Server is no longer valid, i.e. an employee is no longer with the company
so
> we should delete their related Windows Authentication user IDs from our SQ
L
> Server databases?
>

How to determine Authentication Mode?

Given a server name, and before logging on to the server - how can I tell if
it's using Windows Authentication Mode or SQL Server Authentication?
I'm retreiving a list of servers as follows:
Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
As String
dmoApp = New SQLDMO.Application
dmoServerList = dmoApp.ListAvailableSQLServers
For i As Integer = 1 To dmoServerList.Count
srvrNm = dmoServerList.Item(i)
Next i
Thanks in advance for your help,
Hal Heinrich
VP Technology
Aralan Solutions Inc.Hal,
SQL Server always defaults to using Windows Authentication; it is up to the
developer to determine which authentication method to use.
And if you use some tool to generate the connection string for you, the
default will be to use Windows Authentication. This can be seen in the
connection string by the following line:
Integrated Security=SSPI
If that data|value pair is present, then your connection will use the
Windows Authentication mode. Simply remove this data|value pair from your
connection string and then you will be using the SQL Server Authentication
and be required to include user and password values.
Hope that helps.
Richard
"Hal Heinrich" wrote:

> Given a server name, and before logging on to the server - how can I tell
if
> it's using Windows Authentication Mode or SQL Server Authentication?
> I'm retreiving a list of servers as follows:
> Dim dmoApp As SQLDMO.Application, dmoServerList As SQLDMO.NameList, srvrNm
> As String
> dmoApp = New SQLDMO.Application
> dmoServerList = dmoApp.ListAvailableSQLServers
> For i As Integer = 1 To dmoServerList.Count
> srvrNm = dmoServerList.Item(i)
> Next i
> Thanks in advance for your help,
> Hal Heinrich
> VP Technology
> Aralan Solutions Inc.
>

How to deplory reports using visual studio and Forms Authentication?

Hi,
i successfully installed the forms authentication example on my report
server.
The problem i am facing now is that i am no longer able to deploy my
reports using visual studio to the report server as i did before. Is
there a possibility to still use visual studio for deploying?
If not, is there an alternative for deploying? How can i transfer my
reports, data-sources and models to the server?Have you removed Windows Authentication as an option in IIS? My VS prompts
me when LogonUser fails.
"Patrick Dinger" <paxos2k@.gmail.com> wrote in message
news:1142000029.874965.138750@.u72g2000cwu.googlegroups.com...
> Hi,
> i successfully installed the forms authentication example on my report
> server.
> The problem i am facing now is that i am no longer able to deploy my
> reports using visual studio to the report server as i did before. Is
> there a possibility to still use visual studio for deploying?
> If not, is there an alternative for deploying? How can i transfer my
> reports, data-sources and models to the server?
>