In Object Explorer window of SSMS, you have a Connect Combo in Top Left corner of Object Explorer window. Many thanks for taking the time to reply, but I am getting this error message Do I have to change any other settings TITLE: Connect to Server------------------------------Cannot connect to XX. 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, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)For help, click: Prod Name=Microsoft SQL Server&Evt Src=MSSQLServer&Evt ID=53&Link Id=20476 Barry Andrew Can you get the DBA to run SQL Server Surfice Area Configuration tool to chech that Name Pipes is allowed.
Wear All Plus Size Frill Short Sleeve Tie Up Cardigan Featuring a tie up front and frill around the short sleeves, this lightweight cardigan with a snug fit can be dressed up or down for a range of looks.
Also, one thing worth check, have you confirmed the port on the IP address.
Finally please remember to check the firewall settings on the server as this could also be causing you problems.
Quantcast is an American technology company, founded in 2006, that specializes in audience measurement and real-time advertising.
The company offers public access to traffic and demographic data for millions of Web sites and detailed user insights to digital publishers enrolled in its Quantified Publisher Program.