Add new users to SQL Server mdf

How can i add new users to the sql server mdf. Since, when i try to
access the mdf it gives me
the following error under the setting "Windows Authentication":

" Could not open default database.Login failed for user AMIRDIWAN
\Administrator"

Alternatively, i tried the other way by keeping "SQL SERVER
Authentication":

" Login failed for user 'amirdiwan'.The user is not associated with a
trusted SQL Server connection."


How can i fix this. Please let me know, as i have to do it for my
final year project?

.

Relevant Pages

  • Re: Problem with one table - Connection Timeout
    ... If you don't know what the problem is you can't fix it. ... You don't know what the problem is because you can't get on the server to ... We were using linked tables and ODBC connection ... worst is that I don't have the admin access to the SQL Server to run ...
    (comp.databases.ms-access)
  • Re: Funny Error
    ... >An error has occurred while establishing a connection to the server. ... this failure may be caused by the fact that ... >under the default settings SQL Server does not allow remote connections. ... >How do I fix this. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: BCP Error 08001, Nativeerror 2
    ... I don't know how to fix it. ... Is your SQL Server instance a Named Instance or a Default Instance? ... I am trying to import the data in a csv file into my data using the code ... establishing a connection to the server. ...
    (microsoft.public.sqlserver.tools)
  • DB Connection
    ... has a suggestion for a fix. ... SQL Server 2000 SP3a ... Now when I create a small Winforms app as a test, ... same connection string and open a connection to SQL Server just fine. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Slow Connection using IP Address
    ... FIX: Connection to SQL Server Database Using IP Address Is ...
    (microsoft.public.sqlserver.connect)