none
Problems connecting a .Net 1 application to MSSQL Server RRS feed

  • Question

  • Hi there,

     

    Has anyone ever encountered problems making .Net applications connect to a SQL database on SQL 2000 with SP3a?

     

    It's running on a virtual machine with a Windows Server 2000 Std with SP4, the .Net application is working with .Net Framework 1.1.4322.573. For some reason it can't connect to the SQL database using the specified username and password in the web.config file even though the user exists in the SQL database. I've tried using the SA password but this still doesn't work. I can logon to SQL Query Analyzer using the SA password but not using the other username.

     

    The .Net application does work on other systems of mine all of which can run on Windows Server 2000 and 2003, I have compared them but can't find any differences. 

     

    Any ideas anybody?

     

    Thanks,

     

    Chris

    Monday, November 12, 2007 12:32 PM

Answers

All replies

  •  

    What is the exact error message ?

    Jens K. Suessmeyer


    ---
    http://www.sqlserver2005.de
    ---

    Tuesday, November 13, 2007 11:47 AM
  • The error message is telling me that the username that I am using is not recognised. I can logon to to SQL Query Analyzer using the SA password but when I use this password in the web.config of the application it does not connect the application to the SQL database. When I use a username created in Windows and place that username into the SQL database I cannot connect to SQL Query Analyzer and I still cannot connect the applicaiton to the SQL database. 

    Tuesday, November 13, 2007 3:49 PM
  • Well, could you please send the web.config file part then and check if the server you are connecting to is the same as used in QA ?



    Jens K. Suessmeyer

    ---
    http://www.sqlserver2005.de
    ---

    Tuesday, November 13, 2007 5:31 PM