Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Windows Authentication without Windows NT

Author  Topic 

G37Sam
Starting Member

16 Posts

Posted - 2011-10-11 : 17:32:24
Hello fellas,

I have installed SQL Server 2008 on Windows XP Professional and it seems like I can only grant access to users on my Local Machine when Windows Authentication Mode was chosen.

Is there any way I could set it up to grant access to users over LAN without having to revert to Windows NT or SQL Authentication Mode?

Many Thanks,

Sam

G37Sam
Starting Member

16 Posts

Posted - 2011-10-14 : 17:48:19
Anyone please?

Sam
Go to Top of Page

G37Sam
Starting Member

16 Posts

Posted - 2011-10-15 : 16:59:30
Help a brother out people :D

Sam
Go to Top of Page

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-10-16 : 10:07:59
hi ,

may be you cannot connect because when setup of sqlserver , you select Local System account not a Network Service account and using a Windows domain account

kindly read the following article about sqlserver account

http://msdn.microsoft.com/en-us/library/ms191543.aspx

final notice :
my recommendation is to trying to use SQL Authentication Mode and connecting using a sqlserver account

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-10-16 : 12:05:10
Is your machine in the same domain as the other users ?

PBUH

Go to Top of Page

G37Sam
Starting Member

16 Posts

Posted - 2011-10-16 : 17:57:23
quote:
Originally posted by paultech

hi ,

may be you cannot connect because when setup of sqlserver , you select Local System account not a Network Service account and using a Windows domain account

kindly read the following article about sqlserver account

http://msdn.microsoft.com/en-us/library/ms191543.aspx

final notice :
my recommendation is to trying to use SQL Authentication Mode and connecting using a sqlserver account

good luck,

paul Tech



Thanks for the link Paul

quote:
Originally posted by Sachin.Nand

Is your machine in the same domain as the other users ?

PBUH



They're all linked to the same router yes

I'm just wondering if it would be possible to define all allowed machine names/usernames somewhere on the SQL server to save the user from entering an extra password

EDIT: Seems to me after a lot online research that unless some sort of Windows NT or Windows Server OS was installed on the server machine, windows authentication will be pointless and I would be forced to stick to SQL Authentication


Sam
Go to Top of Page
   

- Advertisement -