Browse by Tags

Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Published 12 September 7 4:56 AM | SSQA.net

The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the...

Filed under: sql server, high availability, security, error, database mirroring, service account, 1418, ports

Error: Database diagram support objects cannot be installed because this database does not have a valid owner

Published 6 September 7 4:0 AM | SSQA.net

If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects...

Filed under: sql server, restore, security, database, upgrade, error, diagram, authorization

Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Published 22 August 7 8:56 AM | SSQA.net

One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. --...

Filed under: sql server, security, ssms, error, login, property, ssma

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

Published 21 August 7 9:6 AM | SSQA.net

--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState...

Filed under: sql server, high availability, integration, security, ssms, error, surface, not found

An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

Published 26 July 7 7:49 AM | SSQA.net

Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider...

Filed under: sql server, performance, management, security, ssms, error, access, sql express, tcp, named pipes, remote