The simple program of fetching the data of table through vb.net program.
I am retrieving the data into DatagridView . I am writing following String str for connection:
Dim str As String = " Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= "
my database name is "Atuldb", I am using SQL SERVER MGT STUDIO.
In that My server name is "COMP1SQLEXPRESS", Authentication is "Windows Authentication", User Name is "COMP1comp11",
& not given any password.
When I compiled program it given " sqlexception was unhandled :
Login failed for user ' COMP1comp11'. The user is not associated with a trusted SQL Server connection."
Software/Hardware used: visual Studio 2008,Sql server mgt studio 2005.