Hi

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.

twsted F8



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;"

It would appear to be something regarding security. As the error indicates the user you are running the program under doesn't have access to the database file. I haven't worked with Express much, but I think the problem is related to file access rights for the db file.

-Peter