After installing SQL Server 2005 SP1 SSMS cannot connect to the se



  • 1. Unable to run a backup script
    Hi all, I have two servers in a network. one of these servers are in a workgroup and the other is in a domain when i run the following command in query analyzer of the domain server, i get an error indicating device not ready etc. backup database northwind to disk = '\\domain\d\northwind.bak' both sql servers are in mixed mode. the Startup Service Account of the workgroup server is System Account. What could be the reason for this error? KK
  • 2. kerberos delegation through trusted domain.
    I have a web site that is set up to connect to a sql Server and log database entries . Keberos delegation is working and verified. All Users who connect on the same domain as the SQL server and IIS server have their credentials passed to SQL server successfully. I have a second windows 2000 domain which is joined to this domain by two one way trusts. Accounts from this domain just get passed to my sql server as null . Is there anything i can look at with a view to fixing this? Regards
  • 3. KB article 822668 - what's really happening?
    This article refers to the "connection is busy with results for another command" error message that sometimes occurs with a linked-server query. I understand that this is fixed in sp 4, but I was wondering if anyone knew what's going on internally to cause this error, and how sp4 "fixes" it. The KB article lists symptoms and resolution, but is silent on the cause. Thanks in advance.
  • 4. remote access
    I am setting up a windows applicaiton that need to have remote access over internet to a database. I am planning to use the Netlibraries with SSL and client-certificates. Does it make sense to use a VPN on top of this, and if so, what are the benefits? Or is the use of firewalls enough? thanx, Johan

After installing SQL Server 2005 SP1 SSMS cannot connect to the se

Postby RG1pdHJ5IEtvbGNoZXY » Wed, 12 Apr 2006 18:46:01 GMT


When I try to create db or do something else, SSMS fails with error (before
installing SP1 SSMS runs without errors):


Cannot show requested dialog.


Cannot show requested dialog. (SqlMgmt)

Program Location:

initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
initializationXml, IServiceProvider dialogServiceProvider)
doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument
doc, IServiceProvider provider)
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)


Failed to connect to server srv-027. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
at Microsoft.SqlServer.Management.Smo.ExecutionManager.get_ServerVersion()
at Microsoft.SqlServer.Management.Smo.Information.get_Version()
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.InitializeDataMembers(CDataContainer context)
Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase..ctor(CDataContainer context)


Cannot open user default database. Login failed.
Login failed for user '***************'. (.Net SqlClient Data Provider)

For help, click:

Server Name: srv-027
Error Number: 4064
Severity: 11
State: 1
Line Number: 65536

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

Similar Threads:

1.Cannot install update SQL Server 2005 SP1 - error code 0x2B18

Cannot install update SQL Server 2005 SP1 - error code 0x2B18
Please advice. Any suggestion appreciated.
I'm running:
XP pro SP2 (with all latest updates except this one)
SQL SERVER 2005 dev edition

2.Install SQL Server 2008 Management Objects onto SQL Server 2005 se

We have a requirement to install the the SQL Server 2008 Managament Objects 
onto a server that is running SQL Server 2005. The management objects have a 
number of pre-requisites including MSXML 6.0, the SQL Server 2008 Native 
Client and the SQL Server 2008 CLR types. Given all of these is this possible 
to do?

Thank you.

3.SP2 install refuses to install SP1 Database (doesn't recognize SQL server 2005)

Hi All:

I am trying to install the 'free trial' XPE on my XP Pro system with 
Microsoft SQL Server 2005 (SQLEXPRESS) already installed and running 
[confirmed with SQL Server 2005 Surface Area Configuration tool].  When 
the installer (Disk 2) for the SP1 database attempts to do the install, 
after checking database status, it comes up with the message:

"The Microsoft Data Engine (MSDE) or SQL Server, version 2000 or later, 
is required to be installed and running before you install or modify 
this product."

This is not a very auspicious beginning to my using XPE in our products. 
  Am I going to have to download and install the MSDE as well, or 
de-install SQL Server 2005, to get this installer to work?


4.Cannot install SSCE31VSTools-ENU.exe on VS 2005 Std SP1

I am having a problem installing the SSCE31VSTools-ENU.exe package for 
Visual Studio 2005 Standard with SP1.  Here's what I have:

* Smart Device Programmability option installed for VS 2005 Std.
* Downloaded and installed VS SP1 (from Microsoft's website dated 
* SQLServerCE31-EN.msi package has been downloaded and installed (from 
MS website dated 1/11/2007.)

The error I am getting is: "The upgrade patch cannot be installed by the 
Windows Installer service because the program to be upgraded may be 
missing, ...."

Is this package supported for Visual Studio 2005 Standard with SP1?  Or 
am I missing something?

Thanks for any help.

5.Can I install Sql Server Express 2005 if I already have SQL Se

6. SQL Server 2005 Cluster Instal Fails - Can't start SQL Database Se

7. Cannot Create Distribution Server on SQL Server 2005 SP1

8. Cannot Connect to Report Server with SSMS using Forms Authentication



Who is online

Users browsing this forum: No registered users and 25 guest