I have installed MS SQL Server 2005 Express Edition with Advanced Services and MS SQL Server 2005 Express Edition Toolkit SP1. Everything istalled without any errors noted. When starting SQL Server Management Studio Express, accepting the server name MAYNARD-MAIN with authentication as windows authentication. I get the following message:
Cannot connect to MAYNARD-MAIN
Additional information:
An error has occurred while establishing a connection to the server. Wehn connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider:Shared Memory Provider, error:36 - The Shared Memory dll used to connect to SQL Server was not found)(Microsoft SQL Server, Error: 126)
I haven found any info on either of these error in the forum.
The Configuration Manager shows the following:
SQL Server FullTextSearch(SQLEXPRESS) - Running
SQL Server(SQLEXPRESS) - Running
SQL Server Reporting Services(SQLEXPRESS) - Running
SQL Server Browser - Running
Protocols for SQLEXPRESS
Shared Memory - Enabled
All others disabled
Client Protocols
Shared Memory - Order 1 - Enabled
TCP/IP - Order 2 - Enabled
Named Pipes - Order 3 - Enabled
VIA - Disabled.
What do I need to be trying to find to corect this.
Either connect to the default server instance..."SQLEXPRESS" or Make sure that the "MAYNARD_MAN" instance is running before trying to connect to it
|||Well that was easy enough - I really feel dumb now. Add instance to machine name and it works a lot better. Sorry I took up your time being not to bright.
