asked on

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

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?

ASKER CERTIFIED SOLUTION

Jeffrey Kane - TechSoEasy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mellow52

ASKER

This I have done. It does point to the correct server and database.

Jeffrey Kane - TechSoEasy

Oops! I missed that in your original question. sorry.

Anyhow... have you reviewed the troubleshooting steps in http://support.microsoft.com/kb/910012 ?

Jeff
TechSoEasy

mellow52

ASKER

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

this is what it gave:

database=dbasenamehere
server=MONKEY-servernamehere,5356

database=dbasenamehere
server=MONKEY-servernamehere\sqlinstancenamehere,5356

Hope thius helps so poor sole... to 10 hours of my life

Thanks for your help.

Jeffrey Kane - TechSoEasy

:-) I like being right.

Glad it worked out for you.

Jeff
TechSoEasy