Re: Add new users to SQL Server mdf



"weird0" <amirediwan@xxxxxxxxx> wrote in message news:1174760383.999458.112800@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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?


First, although this is homework, I don't imagine solving this particular problem is part of the assignment.

What version of SQL Server are you using? What version of Windows?

Is the instance of SQL Server on your local computer?

Do you have another local administrator account that you can try to connect from?

David



.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)
Loading