|
I'm trying to set up an SQL server for use with Windows Sharepoint Services. I have Microsoft SQL Server 2005 installed on a VM which is running Windows Server 2003.
I get the commonly-received error:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
.....
It goes on to say that by default, remote connections are disallowed.
However, I already enabled both named pipes and TCP/IP in the Surface Area Configuration, and when I check under services in Administrative Tools in Windows, "SQL Server (SQLEXPRESS)" is "Started", which seems fine.
When I check the Surface Area Configuration, I see:
- SQLEXPRESS
- Database Engine
-> Service
Remote Connections
The service name is "MSSQL$SQLEXPRESS" and the display name is "SQL Server (SQLEXPRESS)".
Have I done anything terrible wrong or am I missing something here? I did remember to reset the database system when I made changes to the connection settings to enable named pipes and TCP/IP, as directed.
|
