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.
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 |
|
|
G37Sam
Starting Member
16 Posts |
Posted - 2011-10-15 : 16:59:30
|
Help a brother out people :DSam |
|
|
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 accountkindly read the following article about sqlserver accounthttp://msdn.microsoft.com/en-us/library/ms191543.aspxfinal notice :my recommendation is to trying to use SQL Authentication Mode and connecting using a sqlserver account |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-16 : 12:05:10
|
Is your machine in the same domain as the other users ?PBUH |
|
|
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 accountkindly read the following article about sqlserver accounthttp://msdn.microsoft.com/en-us/library/ms191543.aspxfinal 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 Paulquote: 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 yesI'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 passwordEDIT: 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 AuthenticationSam |
|
|
|
|
|