Good evening,
I just installed the Express Versions of Visual Basic 2005, SQL Server 2005 and SQL Server Management Studio 2005.
I set up the database server using the default settings (at least I hope so..
) and created a database and a tables.
Then I tried to connect from a Visual Basic application to the database server using Windows authentication, but it did not work out. I got the following error message: "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."
I don't understand this message because I configured the SQL server to accept remote connections (at least I think so..): I used the SQL Server Surface Configuration tool to accept both TCP/IP and named pipes connections (Services and Connections) and I used the Management Studio to allow remote connections (Connection property of the server). I don't think it is the connection problem. If it was so, I would not be able to use the Management Studio.
Does anyone know this problem? I appreciate every suggestion.
Kind regards
Peter
I just installed the Express Versions of Visual Basic 2005, SQL Server 2005 and SQL Server Management Studio 2005.
I set up the database server using the default settings (at least I hope so..
) and created a database and a tables.Then I tried to connect from a Visual Basic application to the database server using Windows authentication, but it did not work out. I got the following error message: "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."
I don't understand this message because I configured the SQL server to accept remote connections (at least I think so..
): I used the SQL Server Surface Configuration tool to accept both TCP/IP and named pipes connections (Services and Connections) and I used the Management Studio to allow remote connections (Connection property of the server). I don't think it is the connection problem. If it was so, I would not be able to use the Management Studio.Does anyone know this problem? I appreciate every suggestion.
Kind regards
Peter
