SQL Express TCP/IP Configuretion

Question

Hi All,

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.

------------------------------
ADDITIONAL INFORMATION:

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

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. 

Answer 1

Hi, did you switch on the remote connection for the machine, a screenshot of the needed configuration can be found here:

http://www.sqlserver2005.de/SharedFiles/Remoteconnection.jpg

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 2

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?

Answer 3

Hi wpcc,

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.

Regards,

Mike Wachal
SQL Express team

----
Please mark your thread as Answered when you get your solution.

Answer 4

Hi Mike,

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.