Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL 2005 Can't connect remotely

2 views
Skip to first unread message

Vene

unread,
Nov 7, 2007, 10:14:01 PM11/7/07
to
Recently I uploaded the free version of SQL 2005 EXPRESS EDITION, previous of
that I was working with SQL 2000 with no problem at all, to migrate my
database from SQL 2000 to SQL 2005 I used the restore procedure and was
successfully updated.
I can interact with my new SQL 2005 database using SERVER MANAGEMENT STUDIO
EXPRESS, the problem is remotely I can't open it!!
So, I did some research and knew that SQL 2005 by default is not remotely
enabled and the solution is:

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

0 new messages