October 8, 2008 04:44am pdt

1. chapmandew 2,223,259
2. angelIII 1,997,731
3. mark_wills 631,410
4. aneeshatti... 607,479
5. ScottPletc... 456,851
6. EugeneZ 366,402
7. ee_rlee 353,240
8. BrandonG... 340,310
9. acperkins 335,429
10. dtodd 304,879
11. momi_sa... 194,132
12. cs97jjm3 188,038
13. matthews... 169,999
14. appari 166,334
15. nmcdermaid 165,158
16. rickchild 165,060
17. brejk 163,902
18. dqmq 156,258
19. Thomasian 153,702
20. dportas 141,305
21. ptjcb 140,761
22. dbaSQL 139,392
23. bhess1 134,605
24. mwvisa1 128,997
25. MohammedU 125,975

1. angelIII 10,954,144
2. aneeshatti... 4,665,358
3. acperkins 4,323,889
4. ScottPletc... 4,270,903
5. arbert 2,245,195
6. chapmandew 2,223,259
7. Lowfatsp... 2,174,384
8. EugeneZ 1,642,564
9. imran_fast 1,482,261
10. rafrancisco 1,460,132
11. Hilaire 1,221,775
12. nmcdermaid 1,149,742
13. Nightman 1,146,504
14. Mr_Peer... 1,087,815
15. ptjcb 1,074,620
16. bhess1 1,071,597
17. dtodd 891,222
18. adathelad 777,208
19. Sirees 776,352
20. appari 753,571
21. BriCrowe 722,959
22. matthews... 692,331
23. amit_g 683,229
24. mark_wills 631,410
25. ShogunW... 619,598

12.14.2007 at 12:17PM PST, ID: 23024513

	[x] Attachment Details

Security question - allowing userid access only from specifc hosts

Asked by goknows in MS SQL Server

Tags: SQL Server, Microsoft, SQL Server 2005, Security

I have a need to allow an application to access my SQL Server 2005 database - it is doing so using an application user (not an userid integrated with AD).

I would like to restrict this use (let's call it appuser with a password of AppUser1) to aaccessing the database only from specifc hosts (the app servers).

Is this possible in SQL Server 2005 as it is in most other dbms?

Thanks!Start Free Trial

Keywords: Security question - allowing userid ac…

	Title
1	UserID
2	Outlook 2000 asking for userid and …
3	userid disabled or restricted in DB2 8…
4	Best way to do Access/SQL Server …
5	UserID not passing in URL
6	Store UserID on Authentication

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Security question - allowing userid access only from specifc hosts

Asked by goknows in MS SQL Server

Tags: SQL Server, Microsoft, SQL Server 2005, Security

About this solution