Sunday, May 07, 2006 5:21 AM
I just configure the SQL TCP/IP but after I configure, I can't connect to the server via SQL Management tool. I am getting this error:
Cannot connect to WPCC\SQLEXPRESS.
An error has occurred while establishing a connection to the server. 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
May I know what is the error? I try to click on the link provided but there is not thing can help. Any idea?
Another question is, how I want to set the IP and Port for this SQL server in order for me to access via pocket pc emulator?
Thanks for advance.
Sunday, May 07, 2006 1:32 PMModeratorHi, did you switch on the remote connection for the machine, a screenshot of the needed configuration can be found here:
HTH, Jens Suessmeyer.
Sunday, May 07, 2006 3:14 PM
Thanks for your reply. Actually is after enable the TCP/IP then i can'r connect to the server via SQL Express Management studio. Now i solve the problem by enable the SQl Server Browser. but I still can't access via my ppc emulator. You mean my PC or ppc emulator? I din activate the my PC firewall.
Can set any IP address and Port No to the SQL server?
Wednesday, May 10, 2006 3:04 AMModerator
When you try to connect via managment studio, are you on the same computer, or a different one?
As far as specifying a specific TCP port for your server, check out the Books Online topic at http://msdn2.microsoft.com/en-us/library/ms177440.aspx.
SQL Express team
Please mark your thread as Answered when you get your solution.
Saturday, May 20, 2006 11:46 AM
I connect in the same computer.
Now the problem has been solve but I'm not sure what is the problem. Previously I can't login with SA and failed to create new user. I just try unistall the SQL Express and Reinstall back then the problem solve.
Anyway, thanks for your reply.