Am new to vb
.net 2005 and of late i have been trying to connect to sql server 2005 express edition. I have been getting the following error and I have tried changing my connection string, but this has been to no avail. I am receiving this error.
I have also tried connecting to a sql 2000 database and I am still getting the same problem. How can I fix this. I have also included my connections string below, maybe there is something wrong with it.
I hope u will be able to help me.
Cannot open database "C:\Documents and Settings\chiko-shumba\My Documents\Visual Studio 2005\Projects\YMCA\YMCA" requested by the login. The login failed.
Login failed for user 'CHIKO\chiko-shumba'.
Data Source= .\SQLEXPRESS;Initial Catalog = C:\Documents and Settings\chiko-shumba\My Documents\Visual Studio 2005\Projects\YMCA\YMCA;Integrated Security=True;User Instance=True;"