Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 Web Query for IBM i  >  developerWorks

MS SQL Authentication - Must be Mixed Mode    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 3 - Pages: 1 - Last Post: Nov 9, 2009 6:28 PM Last Post By: rdandrew
daveo

Posts: 29
Registered: Aug 28, 2009 09:53:05 PM
MS SQL Authentication - Must be Mixed Mode
Posted: Nov 08, 2009 11:10:22 PM
 
Click to report abuse...   Click to reply to this thread Reply
There appears to be no method by which a connection can be made to a MS SQL instance that is configured for Windows Authentication only.

Can you please confirm.
IBM employee or contractor rdandrew

Posts: 139
Registered: Jul 19, 2007 10:01:44 PM
Re: MS SQL Authentication - Must be Mixed Mode
Posted: Nov 09, 2009 09:35:20 AM   in response to: daveo in response to: daveo's post
 
Click to report abuse...   Click to reply to this thread Reply
That is correct. You must pass a user id and password for authentication.

Robert Andrews
Advisory Software Engineer
IBM Systems & Technology Group, Rochester
daveo

Posts: 29
Registered: Aug 28, 2009 09:53:05 PM
Re: MS SQL Authentication - Must be Mixed Mode
Posted: Nov 09, 2009 06:06:18 PM   in response to: rdandrew in response to: rdandrew's post
 
Click to report abuse...   Click to reply to this thread Reply
So, to further clarify ... that user ID cannot be a Windows domain user. Is that correct ?
IBM employee or contractor rdandrew

Posts: 139
Registered: Jul 19, 2007 10:01:44 PM
Re: MS SQL Authentication - Must be Mixed Mode
Posted: Nov 09, 2009 06:28:45 PM   in response to: daveo in response to: daveo's post
 
Click to report abuse...   Click to reply to this thread Reply
Yes, you must select "SQL Server and Windows Authentication mode".

Robert Andrews
Advisory Software Engineer
IBM Systems & Technology Group, Rochester
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums