Results 1 to 4 of 4

Thread: SQL Connection in domain names

  1. Sep 8th, 2003, 03:08 AM #1
    berrie_luv
    berrie_luv is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2003
    Posts
    68

    Red face SQL Connection in domain names

    Hi all, Do u know how to connect sql server in vb.net using domain login? That means when user log into the windows, then he use e application, he is able to do e data entry, viewing... etc, by recongising his domain login. He need not go into a password login.
    Reply With Quote Reply With Quote
  2. Sep 8th, 2003, 07:01 AM #2
    VBCrazyCoder
    VBCrazyCoder is offline
    Fanatic Member VBCrazyCoder's Avatar
    Join Date
    Apr 2003
    Posts
    681
    You need to make sure the user is set up in SQL Server as a Windows User type login, then you can just create your Connection String in VB without the UserID and pass, and using integrated security.
    Reply With Quote Reply With Quote
  3. Sep 8th, 2003, 09:00 PM #3
    berrie_luv
    berrie_luv is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2003
    Posts
    68
    Do u have any sample codes for the sql connection?
    Reply With Quote Reply With Quote
  4. Sep 9th, 2003, 07:00 AM #4
    VBCrazyCoder
    VBCrazyCoder is offline
    Fanatic Member VBCrazyCoder's Avatar
    Join Date
    Apr 2003
    Posts
    681
    VB Code:
    1. data source=SqlServerNameHere;initial catalog=DBNameHere;integrated security=SSPI;persist security info=False;packet size=4096
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width