Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    80

    Unanswered: remote sql server connection

    Hi all,
    I am trying to connect to remote sql server in vb.net application.
    I am getting an error "login failed for user'abc' ".
    why am I getting this error, what could be the possible reason.
    any help will be appreciated.
    Last edited by theguru; 04-13-04 at 02:39.

  2. #2
    Join Date
    Apr 2004
    Location
    Manila, PH
    Posts
    1
    what is the login and password in your database?
    whats ur connection string in vb.net?

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://www.freevbcode.com/ShowCode.asp?ID=2226 a template to perform the task.

    What is the connection string set and SQL server authentication?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Posts
    80
    Originally posted by deidei76
    what is the login and password in your database?
    whats ur connection string in vb.net?
    login: abc
    password: abc

    "data source=IP address of server;initial catalog=databasename;persist security info=False;user id=abc;workstation id=WSID;packet size=4096"

  5. #5
    Join Date
    Mar 2004
    Posts
    80
    Originally posted by Satya
    http://www.freevbcode.com/ShowCode.asp?ID=2226 a template to perform the task.

    What is the connection string set and SQL server authentication?
    thanks satya.I am able to connect to the server now. simple and stupid mistake.I forgot to mention password in connection string.

Posting Permissions

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