Client DB Issue


D

Dan

Hello. I have SBA 2008 installed on our database server on a SQL instance
named MSSMLBIZ (SQL Standard 2005). Connections work fine from the server,
however I cannot connect from any client machine. I have entered the
isntance name as SERVER\MSSMLBIZ, but it never connects.

What am I missing here? TCP/IP and Named Pipes are neabled, as is SQL
Server Agent for that instance.
 
Ad

Advertisements

J

JerryData

SBA sets users for the sql by entering them into sql when you add them to
users in it. Make sure you have the users and permissions in your sql server
so you can log in. Hope that helps, you weren't real specific about your
problem.
 
F

flexdog

check to see what tcpip port mssmlbiz is running on, change .sbc to that port.
 
D

Dan

Thanks, that works. It appears that it picks a different port locally than
the one SQL is actually running on.
 
Ad

Advertisements

D

Dan

The other issue I realize now is that I cannot create companies from a remote
machine, it only works from the SQL server. Is this by design? It looks
like adding users is greyed out on remote machines (a bit ridiculous if you
ask me), but since New Company isn't greyed out, I would assume this would
work.
 

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