connection to Sql Server

• Shital P

  SSC Enthusiast

  Points: 109

  More actions

  April 5, 2005 at 4:08 am

  #67378

   

  hi !!

  I am trying to connect to Sql Server using VB .Net,

  1 >

  Dim SqlConn As New System.Data.SqlClient.SqlConnection

          SqlConn.ConnectionString

  ="server=localhot;uid=sa;pwd=;database=Northwind" 

  SqlConn.Open()

  I am getting an error

  "Login failed for user 'sa'. Reason: Not associated

  with a trusted SQL Server connection"

  2>

  Dim

  SqlConn As New ADODB.Connection

  Dim str1 As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=RISDatabase;Data Source=SHITAL-20"

  SqlConn.Open(str1)

   I am getting an error

  Login failed for user 'SHITAL-20\ASPNET'

  Pl. Help me out

  Shital

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  April 5, 2005 at 5:48 am

  #550482

  see same post http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=171994 for reply

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net