469,627 Members | 1,068 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,627 developers. It's quick & easy.

MS sql server on workgroup not domain.

Hi have a small network setup and have MS sql server on workstation.
Can access it locally but cannot access it from other work stations.
I am assuming it is some sort of logon error, being it is not a
domain. Any ideas on getting by this ?
Jul 20 '05 #1
2 2575
Two possible issues.

One it's installed on Win XP with service pack 2. SP2 has an automatic
firewall that you will need to punch a hole through.

Two the SQL Server is configured for Windows only authentication. Since you
can access it locally you are probably a member of the local administrators
group and as such are granted sa rights by default. Windows only
authentication will not work for remote connections in a work group. You
will need to use SQL Server standard security in mixed mode.

Hope this helps,
Danny
"Father Jack Hackett" <Ja*****@rcc.org> wrote in message
news:j8********************************@4ax.com...
Hi have a small network setup and have MS sql server on workstation.
Can access it locally but cannot access it from other work stations.
I am assuming it is some sort of logon error, being it is not a
domain. Any ideas on getting by this ?

Jul 20 '05 #2

I have been trying to set it up on a local workgroup with all XP home
edition computers, I am running into the same problem.
Lionel
On Tue, 23 Nov 2004 12:45:16 GMT, "Danny" <is****@flash.net> wrote:
Two possible issues.

One it's installed on Win XP with service pack 2. SP2 has an automatic
firewall that you will need to punch a hole through.

Two the SQL Server is configured for Windows only authentication. Since you
can access it locally you are probably a member of the local administrators
group and as such are granted sa rights by default. Windows only
authentication will not work for remote connections in a work group. You
will need to use SQL Server standard security in mixed mode.

Hope this helps,
Danny
"Father Jack Hackett" <Ja*****@rcc.org> wrote in message
news:j8********************************@4ax.com.. .
Hi have a small network setup and have MS sql server on workstation.
Can access it locally but cannot access it from other work stations.
I am assuming it is some sort of logon error, being it is not a
domain. Any ideas on getting by this ?


Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by John J. Hughes II | last post: by
6 posts views Thread by Spyder | last post: by
reply views Thread by =?Utf-8?B?RGF2aWQ=?= | last post: by
3 posts views Thread by Kevinp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.