Cannot open database "UserTable" requested by the login. The login failed.

jlandan2 · August 11th, 2013, 09:31 PM

[QUOTE][QUOTE][QUOTE]Hi there.. IS there anyone can help me with this problem?

I am using Visual Studio 2008 with VB coding. I have this Login page which connect to a table called UserTable.

The odd thing is, yesterday I managed to do the login successfully. But today I tried to login, and it says cannot opened the database UserTable (where I store password & Username)

The codes is still the same.

P/S: I am not using the login control which is provided by Visual Studio.

Code:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "UserTable" requested by the login. The login failed.
Login failed for user 'AspireV5-471\Acer'.

Source Error:


Line 15: 
Line 16:         comm = New SqlCommand(UserLogin, connect)
Line 17:         connect.Open()
Line 18:         Dim check As String = comm.ExecuteScalar()
Line 19:

jlandan2 · August 11th, 2013, 10:19 PM

Well, apparently I had figured where my mistakes is.

It's actually comes from my connection string which I had copied from web.config. Something which had connection string in it.

My mistakes is accidentally add something called initial catalog which the machines cannot read. This is my wrong connection string example:

Code:

Dim connect As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True; Initial Catalog=UserTable;")

So, I delete Initial Catalog=UserTable and it work fine :).. I don't know why I put Initial catalog here.

But I found my mistakes once the error keep saying it cannot open UserTable.