Cannot open database "GADatabase". The login failed. HELP!

Rene Nielsen

Cannot open database "GADatabase" requested by the login. The login failed. HELP!

Hey, i are in the makings of a program C# at my school, and i have a Databae in SQL Server management studios called GADatabase

I have my database class like this

public class Database
{
private static SqlCommand ObjCmd;
static string SqlConn = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=GADatabase;Integrated Security=SSPI;";
private static SqlConnection ObjConn = new SqlConnection(SqlConn);
public Database()
{
}
public void AddStudent(Student Student)
{
ObjConn.Open();
ObjCmd = ObjConn.CreateCommand();
ObjCmd.CommandType = System.Data.CommandType.Text;
int i = 0;
try
{
ObjCmd.CommandText = string.Concat(Student.InsertSqlQuery);
i = ObjCmd.ExecuteNonQuery();
}
catch{ }
ObjConn.Close();
}
}

but if i call the AddStudent and try to acces the ObjConn.Open(); it just returns and gives me the error "Cannot open database "GADatabase" requested by the login. The login failed."

Please if anyone can help me with this error :)
and feel free to ask for more information if that is what u need to help me with my problem

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User16y ago
In your connection string, change "localhost" to the name of your PC. I've encountered that problem, where "localhost" isn't recognized when named SQL instances are involved.
0
Rene Nielsen16y ago
this was already checked :(
but i am gonna paste the whole error, maybe the exact error place is in there

{"Cannot open database \"GADatabase\" requested by the login. The login failed.\r\nLogin failed for user 'Rene-PC\\Rene'."}

System.Data.SqlClient.SqlException was caught
Message=Cannot open
database "GADatabase" requested by the login. The login failed.
Login failed
for user 'Rene-PC\Rene'.
Source=.Net SqlClient Data Provider

ErrorCode=-2146232060
Class=11
LineNumber=65536

Number=4060
Procedure=""

Server=localhost\sqlexpress
State=1

StackTrace:
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj)
at
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer
timeout, SqlConnection owningObject)
at
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, TimeoutTimer
timeout)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions,
String newPassword, Boolean
redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions
options)
at
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory
connectionFactory)
at
System.Data.SqlClient.SqlConnection.Open()

at GA.Database.ExecuteQuery(String SqlQuery) in C:\Users\Rene\Desktop\Skole\2
Semester\Eksamen\GA\GA\Database.cs:line 27
InnerException:
0
Guest User16y ago
Click on Server Roles and add yourself to the sysadmin role.
0
Rene Nielsen16y ago

this is my setting for the user i have added in sql management studios
dont know if it helps u :)
this is the settingds
0
Guest User16y ago
With Integrated Security, you are accessing the database with your Windows login credentials. If your Windows login account isn't set up as a login within SQL Server, you won't be able to access the database.
0
Rene Nielsen16y ago
Hey mate thanks for the answer but i still seem to get the problem :/ i tried uploading the project but dont think it would do you any good when the database is local

0
Arshad16y ago
Hi,

Please make the below changes.
```
Integrated Security=true;
```
Regards,
Arshad
0