Cannot access remote SQL Server 2005 Express

  • Thread starter Michael J. O'Connell
  • Start date

M

Michael J. O'Connell

I have Microsoft Accounting 2007 Pro running on a Windows Vista notebook. I
have Accounting 2007 Express running on Windows Server 2003. I can remotely
access the SQL Server instance on the server using Business Contact Manager
and using SQL Server Management Studio Express. When I attempt to open an
existing sample company in Accounting however I receive the error:

"The company could not be opened. Please ensure the SQL Server exists, the
server is running, and that access has been granted."

I am running as a domain administrator on the client and have verified sql
server and database security. Remote SQL connections are enabled on the
server.

Any ideas?

Thanks

Michael
 
Ad

Advertisements

J

Jesper [MS]

Hi Michael

This message probably indicates that it could not find the computer which is
specified in the sbc-file you tried to open or that the computer didn't
respond.

Could you open the sbc-file in Notepad and verify that the computer name you
see there is the correct name of the server.
Alternately you could open the Windows Firewall on the server and verify
that the exception in that firewall includes the laptop's ip address.
 
M

Michael J. O''Connell

Thanks Jesper,

It was a problem in the sbc file pointing to the wrong server. Fixed!

Thanks,

Michael
 
A

Ashelon

Hi. I had the same problem, but my sbc file is pointing to the right server.
Any other possibilities why it did not work?
 
J

Jesper [MS]

If you installed SQL Server yourself and used the default instance name, you
probably need to add it to the sbc-file - in that case you should add
something like server=[computer]\MSSQLSERVER,5356.

Otherwise verify that you have opened the correct port through your
firewall - if you are using the Windows firewall you can use the multi-user
feature in MOA to open the firewall for you.
 
Ad

Advertisements

S

sysadmin

Also verify that the remote user has a password - not a blank one - and it
must be the same on the client and server.

sysadmin


Jesper said:
If you installed SQL Server yourself and used the default instance name,
you probably need to add it to the sbc-file - in that case you should add
something like server=[computer]\MSSQLSERVER,5356.

Otherwise verify that you have opened the correct port through your
firewall - if you are using the Windows firewall you can use the
multi-user feature in MOA to open the firewall for you.

--
Thanks
Jesper
http://blogs.msdn.com/jesperbirkolsen/


Ashelon said:
Hi. I had the same problem, but my sbc file is pointing to the right
server.
Any other possibilities why it did not work?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top