Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
inet
active_desktop
active_scrptng
asp.components
asp.db
asp.general
comctl32
comp.packaging
components.dev
dbweb
dhtml_editing
docobjects
html_authoring
html_objmodel
iis
iis.ftp
iis.security
iis.smtp_nntp
indexserver
misc
mshtml_hosting
scripting.jscript
scripting.vbscript
sdk_setup
shell_objmodel
urlmonikers
webbrowser_ctl
wininet
  
 
date: Wed, 7 Nov 2007 19:14:01 -0800,    group: microsoft.public.inetserver.dbweb        back       


SQL 2005 Can't connect remotely   
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
date: Wed, 7 Nov 2007 19:14:01 -0800   author:   Vene .(donotspam).

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us