Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohdrashid
Starting Member
23 Posts |
 Posted - 2010-10-08 : 03:23:50
|
| hi all,Is MS Sql 2005 express edition able to run as a "server" in a workgroup enviroment?The ms sql 2005 express edition is installed on 1 of the workgroup pc ("server pc")and other pcs in the workgroup attempts to start the app in a shared folder on the "server pc". I have done the neccesary settings on the the surface config; allow remote access etc. My apps are getting the error: SQL Network Interfaces:Error Location Server/Instance Specified.Any pointers? or it cannot be done in such a setup wo spending purchase a ms sql 2005 workgroup edition.thanks in advance.rashi |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-08 : 04:43:39
|
MS Sql 2005 server express edition is a server.Show your connectionstring please.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mohdrashid
Starting Member
23 Posts |
Posted - 2010-10-08 : 08:08:23
|
| thanks webfred,from the apps:Data Source=HP-CB65CD2C421A\SQLEXPRESS;Initial Catalog=GBCrm;Integrated Security=SSPIhope it helps. I got it running successfully on a win 2000 domain server. but no go on a workgroup/peer to peer enviroment.thanks in advance |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-08 : 09:05:33
|
There are a few things that you can / must check on your way to solve this problem.1) Make sure your server name is correct, e.g., no typo on the name. In your case server name is the name of the box that has installed sql server.Is HP-CB65CD2C421A the name of the box?2) Make sure your instance name is correct and there is actually such an instance on your target machine. [Update: Some application converts \\ to \. If you are not sure about your application, please try both Server\Instance and Server\\Instance in your connection string]I think sqlexpress should be fine.3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true). 4) Make sure SQL Browser service is running on the server.5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.Found it here:http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspxgood luck!
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
MS Sql 2005 server express edition as a server