error 15007

I am having some issues with authenticatio in that
sql account exist although the account do not seem to have permission to log on to the server

error 15007

The sets of servers are in 3 domains with a complete trust model
and teg message staes the login does not exist

When i attempt to create the login a separate error states that the user name already existsA few more details would be nice in order to provide a complete answer. You say you have three domains and that trusts have been established among the domains. For the sake of argument, let's call the domains A, B and C. Let's also say that SQL Server is running on a server in domain A. Finally, let's say that you have two users you want to add:

B\UserName
C\UserName

With Windows accounts, you don't create the account. The account already exists in the OS. Instead, you GRANT the windows account access to the appropriate database. See SQL BOL sp_grantlogin.

EXEC sp_grantlogin 'B\UserName'
EXEC sp_grantlogin 'C\UserName'

Note that you would then need to grant access to the appropriate database using sp_grantdbaccess. Example:

Use MyDatabase

EXEC sp_grantdbaccess 'B\UserName'
EXEC sp_grantdbaccess 'C\UserName'

Note that B\UserName and C\UserName are not the same entities; they may share a common UserName, but the are distinct and separate. Pass-through authentication does not apply here since these are domain accounts.

If this does not help you to solve your issue, may I suggest that you post the actual details of your situation so we can understand the issue better?

Regards,

Hugh Scott

Error 1001

Hi,
Is anyone aware when this error comes in sql server?
Error 1001: Cannot start service MSSQLSERVER.An instance of the server is
already running.
regards,
Harshal."harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:%23t%23ufwv9EHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Is anyone aware when this error comes in sql server?
> Error 1001: Cannot start service MSSQLSERVER.An instance of the server is
> already running.
> regards,
> Harshal.
>
This error means that the MSSQLServer service is already running and you are
trying to start it again. What are you doing when this error occurs?
You may have your SQL Server set up to start automatically when the computer
restarts. If you then run a program or a command-line utility that issues
a NET START MSSQLServer command, you will get this error.
HTH
Rick Sawtell
MCT, MCSD, MCDBA|||thanks for the reply... from the error I had guessed it, but since it is
happening at a clients place so I don't have the details yet.
He was trying to start the MSDE setup when the error occured...
thanks
harshal.
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23SE36bx9EHA.220@.TK2MSFTNGP09.phx.gbl...
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:%23t%23ufwv9EHA.3368@.TK2MSFTNGP10.phx.gbl...
is[vbcol=seagreen]
> This error means that the MSSQLServer service is already running and you
are
> trying to start it again. What are you doing when this error occurs?
> You may have your SQL Server set up to start automatically when the
computer
> restarts. If you then run a program or a command-line utility that
issues
> a NET START MSSQLServer command, you will get this error.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

Error 1001

Hi,
Is anyone aware when this error comes in sql server?
Error 1001: Cannot start service MSSQLSERVER.An instance of the server is
already running.
regards,
Harshal.
"harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:%23t%23ufwv9EHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Is anyone aware when this error comes in sql server?
> Error 1001: Cannot start service MSSQLSERVER.An instance of the server is
> already running.
> regards,
> Harshal.
>
This error means that the MSSQLServer service is already running and you are
trying to start it again. What are you doing when this error occurs?
You may have your SQL Server set up to start automatically when the computer
restarts. If you then run a program or a command-line utility that issues
a NET START MSSQLServer command, you will get this error.
HTH
Rick Sawtell
MCT, MCSD, MCDBA
|||thanks for the reply... from the error I had guessed it, but since it is
happening at a clients place so I don't have the details yet.
He was trying to start the MSDE setup when the error occured...
thanks
harshal.
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23SE36bx9EHA.220@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:%23t%23ufwv9EHA.3368@.TK2MSFTNGP10.phx.gbl...
is
> This error means that the MSSQLServer service is already running and you
are
> trying to start it again. What are you doing when this error occurs?
> You may have your SQL Server set up to start automatically when the
computer
> restarts. If you then run a program or a command-line utility that
issues
> a NET START MSSQLServer command, you will get this error.
> HTH
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>