1.Enable the TCP/IP protocol using the Surface Area Configuration Utility
2.Make sure the TCP/IP protocol is enabled in the SQL Server Configuration
Utility
3.start SQL Server browser
4.Open SQL Server Configuration Manager check that protocols were enable.
4.Exceptions are added in Firewall
5.Restart the computer
Well, I did this probably 10 times but the error still is coming, here is
the error
......A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. 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: TCP Provider, error:
0 - An invalid argument was supplied.)....
This is the Web.config connection string I'm using (NET 2.0)
<connectionStrings>
<add name="myconectionmame" connectionString="Data Source=(local);Initial
Catalog=nydatabasename;User ID=sa;PWD=mypassword"
providerName="System.Data.SqlClient" />
</connectionStrings>
Can someone help in this one, please....
Vene