To SQL SERVER Gurus...

[*Vince]

Hi there,

is there a way I can run SQL SERVER on a Network without
domains ( here I mean a workgroup with NT SERVER 4). I've been trying so for a long time now and I always have the same error:

" SQL SERVER can't start the service because it depends
on the NET LOGON service that didn't start. "

I think it's normal that NETLOGON doesn't start because
I'm using workgroup and there is less need of security in a
workgroup...

What I want to know is if there is a configuration that
can be changed for this or is anyone know a rockaround on
this ?

Should I start looking for a gun, rope or bridge OR is it possible ?

Thanks in advance...

[Gen-X]

I am not absolutely sure...

But I think SQL Server needs that Service running on NT to work. The reason for this is that the service allows SQL Servers to talk to other servers if you want to remotely locate it. All you need to do is state in your Connection String that you are using this server and this database and it connects.

It cannot do this unless there is a METHOD of communicating between the client and the server and this is done using the NETLOGIN service. Without it all you can do is run SQL Server locally and connect to the same machine.

Why else would you want to use SQL Server unless in a network environment that has been configured to properly support it?

[Paul282]

It is possible! and I just installed it at home on a standalone NT server machine (not a domain controller)

Check the services that are running and see if the netlogon is there, try to start it if it is, if it crashes check the event log, chances are that the event log is full of the Netlogon service crashing because it's missing a file or something.

[Gen-X]

You still need the NETLOGIN service running though which I think is something the person who asked the question is really reluctant to do.

[*Vince]

Thanks for the answers guys but I'am still a bit confused...


What I want to do is run SQL SERVER within a workgroup.
The thing is that my SQL server is on a stand alone computer
and was on a domain not so long ago. Everything worked
fine, I had my connections to SQL SERVER OK and I could
browse in my database from SQL SERVER MANAGER. The thing
is that since I was forced to change my PC location, I was
forced to be part of a workgroup instead of a DOMAIN. Since
that time, I can neither access my SQL SERVER remotly OR
locally ??? It keeps saying that since I'am in a workgroup,
I don't need to start NETLOGON... AND doesn't want me to start it manually ( good job NT !!! ).

Any suggestions guys ?

[Paul282]

Maybe the SQL server was using an account on the domain that is not in the local user manager so it can't log on!

Were there any errors in event log (at all) ?

[*Vince]

The only things in the log event were the NETLOGON that
said it didn't had to start ( since I'am in a workgroup)
and the SQL SERVER that said it needed the NETLOGON to
start...