Browse by Tags

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

Can't find linked server in management studio?

Published 28 June 7 9:41 AM | SSQA.net

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked