David Webb-200187 (2/25/2013)
What database are you trying to open in the login? I've seen this when the database specified in an ODBC connection doesn't exist on the server or when the default database for the login doesn't exist.
i am trying to log in onto the dbNegin database,
i also provide the default database but there is something weird .first here is the pics :
As you can see when i attached the database , its name and address differs !!!
there is no such a file as :
C:\USERS\FRIEND\DESKTOP\RELEASE\RELEASE\DBNEGIN.MDF
The actual Address is :
C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
I dont know why each time i attach the database it gets the first name !!(I used to attach the database from that address at first then i though mlets move the database to the sql Data sub folder, and test again maybe thats the cause ! thats why i renamed the former path to sth else and moved the database to the DATA subfolder in C:\. yet when ever i attach the database , the former path gets shown as database name !!!maybe thats the problem?causing issues?