Re: Windows Authentication Question

From: G. Dean Blake (Dean_at_nospam.com)
Date: 08/11/04 

Date: Wed, 11 Aug 2004 16:23:12 -0700

"Grant a login at SQL Server on machine 2" could you elaborate on how to do
that?

In E.M. the Secruity tab on the SQL Server Properties Dialog box has a
"Startup service Account" section. Do I put my UID and Password in there?

thanks,
G

"Rand Boyd [MSFT]" <rboyd@onlinemicrosoft.com> wrote in message
news:nMSBd$7fEHA.1600@cpmsftngxa06.phx.gbl...
> Here is how you can do it.
>
> Create a NT account on both machines with the same name and password. Log
> in to machine 1 with this account. Grant a login at SQL Server on machine
2
> using the NT account (should be the same name ans the account you loggged
> into machine 1 as) you created on machine 2. You should now be able to
make
> an NT authenticated connection to the SQL Server from machine 1.
>
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

Relevant Pages

  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MSSQL$SBSMONITORING Login to Disabled Account?
    ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
    (microsoft.public.windows.server.sbs)
  • Re: xp_cmdshell issue, local system
    ... So initially I tried to change the login using EM, ... account to the localsystem for SQL Server and the same for agent which worked ... Now when I go and try the same for the agent startup account it ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
    (microsoft.public.sqlserver.security)