Question

Locked

Client cannot connect. SBA 2008 on SBS 2003 with SQL 05 WG

By mellow52 ·
I have Small business Accounting 2008 installed on my SBS 2003 R2 server running SQL 2005 WG.
The DB exists in SQL and local accesses to it works (on the server) but no client can connect.
.sbc file points to correct DB and port 5356 is added. (1433,5356) on the server IP
SQL is set to allow remote connections.
I have setup Accounting Security Group and Accounting Database shared folder.
I have followed these instruction exactly: http://www.microsoft.com/downloads/details.aspx?FamilyID=1193e3f3-b626-4264-af3e-8c4f190caa69&DisplayLang=en using the 2007 options
In SBA 2008 I have enabled remote access, though the "manage users" will not allow me to add users.

Error I am getting is: The company could not be opened. Please ensure the SQL server exists...

I can get to the DB location from the client \\servername\folder

What am I missing?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Solved!

by mellow52 In reply to Client cannot connect. SB ...

The default file that SBA gives after you turn on multi user works
fine for a workgroup but not for a domain.

this is what it gave in the .sbc file:

database=dbasenamehere
server=servernamehere,5356

this is what works:

database=dbasenamehere
server=servernamehere\sqlinstancenamehere,5356

Hope this helps some poor sole... took 10 hours of my life.

Back to Networks Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums