Connection String with Windows Authentication Mode

Question

I'm trying to test a simple connection to my database with VB.NET on my SQL Server 2008. The problem is my login is with Windows Authentication mode and I enter no password for it to connect to my SQL server.

How will a connection string in this case look like? This has blocked my progress for the whole day.

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim connetionString As String
        Dim connection As SqlConnection
        Dim i As Integer
        connetionString = "Data Source=PEDRAM-PC\PEDRAM;Initial Catalog=Test;User ID=Pedram-PC\Pedram;Password=bro"
        connection = New SqlConnection(connetionString)
        Try
            connection.Open()
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub
End Class

SLaks · Accepted Answer · 2012-10-19 12:11:16Z

11

Add Integrated Security=SSPI instead of the username and password.

answered Oct 19, 2012 at 12:11

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

disasterkid Over a year ago

ArgumentException:Keyword not supported: 'use integrated security'. I get it on connection = New SqlConnection(connetionString)

Collectives™ on Stack Overflow

Connection String with Windows Authentication Mode

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related