ADO.NET and SQL Server question

• Allen Anderson-308568

  Grasshopper

  Points: 24

  More actions

  April 19, 2009 at 10:21 pm

  #95126

  Hi all. I am attempting to connect to a remote SQL Server using the SqlConnection object, but SQL Server rejects all attempts. I know it has something to do with the user ID I'm attempting it with, but I don't know how to get around it. First of all, my ID on my primary network is AAD09; my ID on the remote server is upits\admAnderson ... huge disconnect right there. We're not using mixed-mode security, nor are there individual accounts for users on SQL Server itself; that leaves me with using Integrated Security.

  So, my question is this: what steps do I need to execute before I can successfully execute a series of statements along the line of:

  using (SqlConnection conn = new SqlConnection(...))

  {

  conn.Open();

  ...

  ...

  }

  I'm almost certain I have to do something to let it knowI have a legitimate right to access the server and thus be able to access SQL Server using Integrated Security, but I don't have a clue as to what that might be.

  Any help will be greatly appreciated.

• Sean Lange

  SSC Guru

  Points: 286602

  More actions

  April 21, 2009 at 10:38 am

  #981613

  Look at the parameters for instantiating your SqlConnection. You either need to pass the connection string here or set it after you instantiate it.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  April 21, 2009 at 12:24 pm

  #981690

  Please post the connection string you are using. Are you doing a desktop application or a web application?

  Check out http://www.connectionstrings.com/ for connection string syntax and arguments.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question