New books - Books store:
Understanding BizTalk
Designing Healthcare Solutions with Microsoft Biztalk Server 2004
First Steps: Developing BizTalk Applications
SharePoint 2007 Fundamentals: Interactive Training Course
SharePoint 2007 User's Guide: Learning Microsoft's Collaboration and Productivity Platform
Top Search List:


| |
12/13/2007 Problems Connecting to SQL DataBase through SQL Management Studio
Problems Connecting to SQL DataBase through SQL Management Studio:
TITLE: Connect to Server
------------------------------
Cannot connect to xxx.xxx.xxx.xxx
------------------------------
ADDITIONAL INFORMATION:
An error has occurred 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, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I change this in “SQL Server Configuration Manager”-> TCP/IP Properties -> IP Addresses
TCP Dynamic port live blank,
TCP Port – set default -1433.

And this help ;-)
The reason why a can't connect to sql database was that sql server used another port number then SQL Management Studio.
|
| |
Data Base





How To





Mail





News





Security





SharePoint




Software





Tools





Microsoft Exams
Windows Hosting
|