Login form Using SQL Server Authentication

[syntia.wijaya]

Hi,

I want to create login form with SQL Server authentication. I mean users who have access to SQL Server can access the application as well.

I use SqlConnectionStringBuilder like this

[SIZE=2]builder([/SIZE][SIZE=2][COLOR=#800000]"Data Source"[/COLOR][/SIZE][SIZE=2]) = [/SIZE][SIZE=2][COLOR=#800000]server_name
[/COLOR][/SIZE][SIZE=2]builder([/SIZE][SIZE=2][COLOR=#800000]"Integrated Security"[/COLOR][/SIZE][SIZE=2]) = [/SIZE][SIZE=2][COLOR=#0000ff]True
[/COLOR][/SIZE][SIZE=2]builder([/SIZE][SIZE=2][COLOR=#800000]"Initial Catalog"[/COLOR][/SIZE][SIZE=2]) = [/SIZE][SIZE=2][COLOR=#800000]database_name
[/COLOR][/SIZE][SIZE=2]builder([/SIZE][SIZE=2][COLOR=#800000]"User ID"[/COLOR][/SIZE][SIZE=2]) = username
builder([/SIZE][SIZE=2][COLOR=#800000]"Password"[/COLOR][/SIZE][SIZE=2]) = password
[/SIZE]

I use SqlConnection and no exception occurs when the connection is opened, even when I entered non existing username and password

Can anybody give me a hand?

Thanks in advanace..

 

[cjard]

try running a query on that connection.. SELECT NOW() for example

 

[syntia.wijaya]

I run a query and it works, still with a non existing username.. *weird*

 

[cjard]

It's using Windows Authentication then..

 

[syntia.wijaya]

erm... how to use sql server authentication then?

 

[cjard]

Set it to accept SQLS Auth only in the Surface Area Config

 

[syntia.wijaya]

Sorry, urm.. what is "Surface Area Config"?

 

[cjard]

The administrator of your SQL Server will know (it's a configuration/control panel for sql server)

 

[syntia.wijaya]

Solved!!

I just do this:

builder([SIZE=2][COLOR=#800000]"Integrated Security"[/COLOR][/SIZE][SIZE=2]) = [/SIZE][SIZE=2][COLOR=#0000ff]False  'Changed this

[/COLOR][/SIZE]

And it works perfectly..

Thanks for your replies cjard..