To use the front end tools in SQL Manager on the database at my ISP I want to connect directly. I have enabled TCP/IP and Named Pipes without succes.
My installation is based on SQL Server Developer Edition and VS 2005. With my previos installation based on Express versions of the product this worked fine.
To be more specific:In VS 2005 I select Tools -> Connect to database and fill inn the dialog window with the serveraddress (sql01.active24.com), username and password. I then get the following message:
An errror has occurd while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the fefault settings SQL Server does not allow remote connections. (provider: Named pipes, errror: 40 - Could not opeen a connection to SQL Server
In the network configuration I have now disabled Named Pipes and enabled TCP/IP.
Thanks in advance!
Andreassql
No comments:
Post a Comment