jump to navigation

Login failed for user ‘NT AUTHORITY\SYSTEM’. Reason: Failed to open the explicitly specified database. March 26, 2010

Posted by juanpablo1manrique in DAtabase, event viewer, IT, SQL SERVER, SQL SERVER 2008, Windows 2008.
Tags:
trackback

A veces por alguna razon todo esta bien y pumm uno no se conecta y sale un error come este en el eventviewer

Login failed for user ‘NT AUTHORITY\SYSTEM’. Reason: Failed to open the explicitly specified database. [CLIENT: x.x.x.x]

Entonces toca iniciar una sesión por consola, y cambiar el dafault_database

 – Sql autentication

 sqlcmd -S ISQLSHP -d TableroControlDW -U sa -P *******

 – windows autentication

sqlcmd -S CSQLSHP\ISQLSHP -d TableroControlDW

Luego ejecutar

1>ALTER LOGIN sa WITH DEFAULT_DATABASE = availableDB

2>GO

ó

1>ALTER LOGIN [domain\user] WITH DEFAULT_DATABASE = availableDB

 2>GO

Luego Enter Cuando se ejecuta el comando se le cambia la clave a sa Entonces en bueno ejecutar la sentencia

ALTER LOGIN sa WITH PASSWORD = ”

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: