Link to home
Start Free TrialLog in
Avatar of rn0rd0
rn0rd0

asked on

SQL service won't start

Hello,
I have a small..... or HUGE problem. I cannot get my mssmlbiz SQL server to start. Nothing has changed in the environment, except a QB update, and a reboot. I am running 2003 SBS, with a shared BCM database. It worked fine for the last month, and then died. I am getting the error code 10048 (0x2740) in the event log. Any advise from some of you really smart people would be greatly appreciated. Thanks.

Rob
Avatar of rn0rd0
rn0rd0

ASKER

Just found another interesting log entry....
Server TCP provider failed to listen on [ 'any' <ipv4> 5356]. Tcp port is already in use.
I don't know what this means... but it is associated with the MSSMLBIZ service
sql server uses a dynamic port which is assigned when you restart the server and it can change in every restart. restart your machine, probably your problem will be resolved.
Avatar of rn0rd0

ASKER

I have restarted the server multiple times, to no avail. If I uninstall BCM, and then re-install BCM it will work just fine, right up until the point that I try to share the DB out to other users. At this point it gives the error. It doesn't appear as if this is a BCM specific issue, but rather a SQL express issue. One more small tid bit... I am also running full version SQL 2000 on the same box, I have disabled the other SQL services to try and rule that out, but still no dice. Thanks for your continued help.
Look at the SQL service & re-enter the administrator username & password that enables the service to start.
Avatar of rn0rd0

ASKER

I did change that from "local account" to "specific account" using the admin user and pass. No luck
the port number is stored under the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\EGTMRK\MSSQLServer\SuperSocketNetLib\Tcp
as TcpDynamicPort and TcpPort keys. try chnaging to a free port.
Avatar of rn0rd0

ASKER

Is there a specific "free port" O should change it to?
ASKER CERTIFIED SOLUTION
Avatar of tigin44
tigin44
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rn0rd0

ASKER

Thanks!!! Changing the port worked