How to force usage on NTLM

Hi,
By default Windows authentication will use Kerberos to do the
authentication. Is there a way to force a SQL Server instance to use
NTLM rather than Kerberos - as a server setting?
Thanks,
-RonHi Ron,
No unfortunately, there isn't . I have filed a "Design Change Request"
on this though.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I found this question interesting and wanted to know the pros and cons of
one method over another
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:91hgbFXMFHA.560@.TK2MSFTNGXA03.phx.gbl...
> Hi Ron,
> No unfortunately, there isn't . I have filed a "Design Change Request"
> on this though.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||Hi Kevin,
Thanks for the reply - and the change request is a good thing to look
forward to.
In the interim, I'm wondering whether you can shed some light on what
would be needed to build a "quick-and-dirty" workaround. What I'm
trying to understand is what the fall-back looks like. For example,
what does SQLServer look for in determining whether or not it has
access to kerberos authentication? Does it send something ove rthe
network? If I were to stop it using a firewall on a certain port would
I eventually get it to use NTLM? Any reference to what actually goes on
under the covers in Kerberos authentication that can help me work
something out?
Thanks for the help,
-Ron|||Well, one thing you could try is to force the connection to use Named
Pipes. I believe the last time I tested this, Named Pipes would always
authenticate via NTLM. Whereas with TCP to make a Trusted Connection we
rely on SSPI and always try Kerberos first. Named Pipes can impersonate
the client natively, and don't need to go thru the SSPI api. Essentially,
there should be less overhead with Trusted Connections using Pipes that
Sockets in this regard.
Hope this helps,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks again Kevin - great idea - I'll try that.
One more question if you don't mind. I inderstand (kind of) the use of
the Windows services for the authentication and authorization piece.
However, I noticed that even when this is used the sysprocesses table
always has teh right information - e.g. PROGRAM_NAME. That means that
eventually the information is being decrypted by SQL Server itself from
the TCP/IP handshake. Is this true or is this also a service provided
by SSPI? Is there anywhere to read up on this - the more I think I
understand the mechanism the less I really do.
Thanks,
-Ron|||The Program Name is being passed from the connection parameters I believe.
Example:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=;Initial Catalog=Idea;Data Source=TestSQL;Application
Name=My Application Name Here
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

How to find the Row Number Transformation

I need help on how to find the Row Number Transformation,

I have followed this link http://www.sqlis.com/default.aspx?93

but I cannot find the Trash Destination. Could someone please tell me where I can download it?

Thanks

thanks|||

http://www.sqlis.com/default.aspx?56

|||You have posted the link to the Trash Destination page, just scroll down for the link to the download, Version 1.0.1.1.

How to find out the Default Sort Option.

How can I find out and change the Default sort option in the Server for SQL
2K?
Thanks in advance.
Perayusp_helpsort shows you the current sort order. You may need to rebuild master
to change it.
"Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
> How can I find out and change the Default sort option in the Server for
> SQL 2K?
> Thanks in advance.
> Perayu
>|||Also DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default collation for a database
can differ from the default for the instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kalyan Yella" <kyella@.comcast.net> wrote in message news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild master to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>> How can I find out and change the Default sort option in the Server for SQL 2K?
>> Thanks in advance.
>> Perayu
>|||Many Thanks!
Perayu
"Kalyan Yella" <kyella@.comcast.net> wrote in message
news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild
> master to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>> How can I find out and change the Default sort option in the Server for
>> SQL 2K?
>> Thanks in advance.
>> Perayu
>

How to find out the Default Sort Option.

How can I find out and change the Default sort option in the Server for SQL
2K?
Thanks in advance.
Perayusp_helpsort shows you the current sort order. You may need to rebuild master
to change it.
"Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
> How can I find out and change the Default sort option in the Server for
> SQL 2K?
> Thanks in advance.
> Perayu
>|||Also DATABASEPROPERTYEX and SERVERPROPERTY can show this. Note that default
collation for a database
can differ from the default for the instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kalyan Yella" <kyella@.comcast.net> wrote in message news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.
gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild mast
er to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>|||Many Thanks!
Perayu
"Kalyan Yella" <kyella@.comcast.net> wrote in message
news:uqhkAaIwGHA.5084@.TK2MSFTNGP04.phx.gbl...
> sp_helpsort shows you the current sort order. You may need to rebuild
> master to change it.
> "Perayu" <yu.he@.state.mn.us.Remove4Replay> wrote in message
> news:u7$m9vHwGHA.4216@.TK2MSFTNGP06.phx.gbl...
>

how to find out if a column has a default (sp_bindefault)

How do I find out if a column has a default bound to it (created with
sp_bindefault)?See if you can massage the query below:
SELECT c.name, OBJECT_NAME(c.cdefault)
FROM syscolumns c
WHERE OBJECTPROPERTY(c.cdefault, 'IsConstraint') = 1 ;
Anith|||Jacobus Terhorst wrote:
> How do I find out if a column has a default bound to it (created with
> sp_bindefault)?
It's undocumented and not supported, but you can use sp_MShelpcolumns.
Have a look at the text column.
create table A12345 (
col1 int not null default 5,
col2 nvarchar(10) not null default N'ABC')
exec sp_MShelpcolumns N'[dbo].[A12345]', @.orderby = 'id'
go
Drop Table A12345
Go
David Gugick
Imceda Software
www.imceda.com|||Thank you!
Jacobus Terhorst
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uMDkACpJFHA.1172@.TK2MSFTNGP12.phx.gbl...
> See if you can massage the query below:
> SELECT c.name, OBJECT_NAME(c.cdefault)
> FROM syscolumns c
> WHERE OBJECTPROPERTY(c.cdefault, 'IsConstraint') = 1 ;
> --
> Anith
>

How to Find Out Check Columns?

Hi,
I'm working on a database having default constraint names created by SQL
Server 2000. Is it possible to find out which columns the check works on or
even to see the check code?
TIA,
Axel DahmenScript the constraints from the Object Browser in Query Analyzer.
OR:
SELECT * FROM information_schema.check_constraints
David Portas
SQL Server MVP
--|||Try,
use northwind
go
select
object_name(so.parent_obj),
col_name(so.parent_obj, so.info),
sc.text
from
sysobjects as so
inner join
syscomments as sc
on so.[id] = sc.[id]
where
so.xtype = 'C'
and so.parent_obj = object_id('dbo.Products')
go
Microsoft said:
"Querying the system tables directly may not provide accurate information if
system tables are changed in future releases."
AMB
"Axel Dahmen" wrote:

> Hi,
> I'm working on a database having default constraint names created by SQL
> Server 2000. Is it possible to find out which columns the check works on o
r
> even to see the check code?
> TIA,
> Axel Dahmen
>
>|||Great! Thanks a lot!
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> schrieb im
Newsbeitrag news:1108664961.589752.136520@.l41g2000cwc.googlegroups.com...
> Script the constraints from the Object Browser in Query Analyzer.
> OR:
> SELECT * FROM information_schema.check_constraints
> --
> David Portas
> SQL Server MVP
> --
>

How to find a running application in SQL Server?

How to find a running application in SQL Server?

Hi

In SQL Server (7.0, 2000), we know HOST_NAME() in a DEFAULT definition is used to record the workstation name of computers. But I need to find the name of the application which interacts my DB from the workstations. Is it possible? Please help me

Regards

Ahmed Sahib

ibnukuraish@.gmail.com

Hi Ahmed,

You can get this info from the following:

Code Snippet

Select * from master..sysprocesses

--or

SP_WHO2

Jag

|||

The equivalent to the host_name function for the application name is the app_name() function. The application name may or may not be set - it depends on the connection properties used by the application.

-Sue

How to Finalize my SSIS project

Do I need to convert my SSIS project in VS and deploy it first somehow on my server?

I know that an SSIS project creates a package.dtsx by default so do I need to publish this so that I can see it in SQL Server Management Studio under my Integration Services section? I do not see any packages and get an error when trying to click on the folders "filesystem" or "MDSB" under my SSIS connection in Server Management Studio....likewise when I try creating a job, I try to browse to packages and get a cryptic error, probably because my package isn't showing up in Server Management Studio yet.

The error I get while trying to import packages is saying it can't enumerate or something when I try to browse to my package location. I also get an error saying "encryption not supported on SQL Server (Microsoft Native client) when trying to browse to my package location when trying to import my package in SSIS in Server Management Studio.

Two (different) answers:

1) You don't have to do anything, you can just copy .dtsx file to the server and run it using DTEXEC command line, or schedule it using Agent directly from the file system. While running, it will appear in SSMS 'Running Packages' node, but it will not be in 'Stored Packages' node since it is not stored in SSIS Server.

2) If you want package to appear in 'Stored Packages' in SSMS, you do need to deploy them to the server. Several options exists how to do this: Save Copy As.. command in VS, deployment wizard, dtutil.exe tool. See BOL for more info.

|||Thanks a lot!