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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!