database connection problem

[Erdinc27]

hi all i am just beginner in c# and i want to make a PhoneBook project by using ADO.Net.. and i use SQL Server 2005 Express Edition for my database but i have a problem while connecting database..in the error it says: "Cannot database "Kisiler" requested by the login.The login failed.The login failed for user 'Computer\SQLEXPRESS'" my connection string is like that : SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True"); i checked services after that error..everything looks running when i looked at SQL Server Configuration manager what should i do now ?

[lalit14]

SqlConnection con = new SqlConnection("Data source=COMPUTER\\SQLEXPRESS;initial catalog=Kisiler;integrated security=True**; User id=sa; Password=123456**"); Use this. but do remember to type ur userid and password Regards Lalit Manik

[puri keemti]

Problem is with connection string. User name and password credentials are missing there....

[MNantu]

Try changing the Data Source to Data Source=.\\SQLEXPRESS (Assuming you're using the default instance.) You can also check out connectionstrings.com[^] Hope this helps =)

[Erdinc27]

thanks for the reply friend i tried the string u wrote but still i get same error and i didnt use any password while i was creating my table...i mean i use 'Windows Authentication' mode u have any else suggesstion ?

[MNantu]

When connecting to a database with Integrated Security set to true, I don't think you need to specify User ID and Password. :)

[Erdinc27]

hi i checked the site but as i see my connection string is the same in the site i give permission that user to use the database but still i have error :(

[MNantu]

Which OS do you use by the way

[Erdinc27]

i use windows XP

[lalit14]

Try "Integrated Security=false" and the above code i have given... i Hope it will work Regards Lalit Manik

[lalit14]

Temme 1 thing, the account from which u logged in to Ur computer have rights to access the SQl?

[Erdinc27]

yeah i have given permission to that user but still it says it doesnt have to reach the db

[MNantu]

Is database server running on your local machine ?

[Erdinc27]

yeah it works man do you think it happens becuase of installation or some another options ??