1

Topic: Re: Login failed for user

..;
Here only 2 variants: or the required basis on this server simply is not present (variants: it in an offline, is restoring and , not in online, is shorter), or login SERVER\usr1c in it not

2

Re: Re: Login failed for user

.. wrote:

On MSSQL it is a lot of bases some platforms 1 also are twisted. Could add a DB or a platform to add/update. But here traces are already lost, who and that did.
In what direction to look?

it was necessary to do separate login for each platform. Same at setting it is adjusted in 1?
And so it is clear that to do - to search, who it there addresses to nonexistent basis. For example,  to look at attempts of login with errors, can, on what that to the data in  will be clear.

3

Re: Re: Login failed for user

alexeyvg wrote:

For example,  to look at attempts of login with errors, can, on what that to the data in  will be clear.

Try to specify in a line of connection basis which is not present;
Also look thus in .
You do not see this basis all the same
---
Companion, this error something hinders you?
Well someone did not get to that basis;
To see, not painfully and it was necessary;
Otherwise to you would come running with complaints.
---
The garbage in  is not pleasant - remove audit login failed

4

Re: Re: Login failed for user

.. wrote:

And that means "to look at login attempts". In Windows as I understood all works and does not log in anywhere. It is possible to include audit of attempts of login in SQL the server?

Yes, I speak "", this means of a sequel, instead of Windows.

Yasha123 wrote:

try to specify in a line of connection basis which is not present;
Also look thus in .
This basis you do not see all the same

It clearly, I meant still what that the data, type host name, application name.
Certainly, there can anything useful not be. host name probably 1 if applications on 1 server, and in application name I do not know, what 1 vanities (though can writes there a title of a copy of application?)

5

Re: Re: Login failed for user

.. wrote:

it is passed...
Check up for this user, what basis is specified as default, it can not be or it is inaccessible.
Install, for example, the master

6

Re: Re: Login failed for user

Hupin wrote:

it is passed...
These are 2 different errors:
Failed to open the explicitly specified database
Cannot open user default database
Here at the HARDWARE the first

Posts [ 6 ]

Pages 1

You must login or register to post a reply



Random topics