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
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
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.
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.
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\SOFTWAR E\Microsof t\Microsof t SQL Server\EGTMRK\MSSQLServer\ SuperSocke tNetLib\Tc p
as TcpDynamicPort and TcpPort keys. try chnaging to a free port.
HKEY_LOCAL_MACHINE\SOFTWAR
as TcpDynamicPort and TcpPort keys. try chnaging to a free port.
ASKER
Is there a specific "free port" O should change it to?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!!! Changing the port worked
ASKER
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