November 7, 2008 at 2:55 am
Hi guys, i´m having a problem when i try generate a script to publishing my database to an host provider.
I don´t understand why the login failed, because i´m am the Computer and Database Administrator.
The error is this:
TITLE: Microsoft SQL Server
------------------------------
This wizard will close because it encountered the following error:
------------------------------
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
Failed to connect to server RUY\SQLEXPRESS. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot open user default database. Login failed.
Login failed for user 'RUY\Rui'. (Microsoft SQL Server, Error: 4064)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
November 7, 2008 at 3:28 am
Hello,
What is the Default DB set to for the Login (you can view this in the Login Properties page, from within SSMS)?
Does the Login have rights to the selected Default DB?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
November 7, 2008 at 3:36 am
When i enter to SQL Management Studio Express i go to:
Security -> Logins ->(right click on my) Login Ruy/Rui and the following error appears:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Failed to connect to server RUY\SQLEXPRESS. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Cannot open user default database. Login failed.
Login failed for user 'RUY\Rui'. (Microsoft SQL Server, Error: 4064)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
November 7, 2008 at 3:49 am
Hello Again,
It looks like the Login “RUY\Rui” is effectively locked out because the Default DB associated to it either does not exits, or the Login does not have the right to connect to the Default DB.
You’ll need to use another Administrator account to fix this Login e.g. the SA.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
November 7, 2008 at 3:57 am
I forgot the sa password.
How can i modify it?
November 7, 2008 at 4:16 am
Hello,
I don’t believe you can change the password without knowing the old one i.e. you would have to reinstall SQL Server.
The following is Microsoft’s work around for fixing your Login's Default DB:-
“Use a tool such as OSQL to specify a particular database during the initial connection. Once you are connected, execute sp_defaultdb to change the default database for your login to a database that is currently accessible.”
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply