SQL Connection string for Web.config to my sql2000 server on the asp site from the beta site

Discussion in 'ASP.NET 2.0' started by easyrealtya, May 7, 2005.

  1. I was wondering if you were not too too busy tonight if anyone there knew the correct connection string to get to my SQL server mssql05.discountasp.net from my WeB.Config file on the beta site. I am able to connect just fine here at home to a aspnetdb databaseon my local server from within my Visual Wb developer 2005.I am using a login control to authenticate a user at login but when I try it on the beta sitewith the config modified to connect to mssql05.discountasp.net it fails
    Here is my Web config line that works with my server name as I have the same user and password setup that my hosted site uses I just have to alter the server name to be my sql200 onthe ASPsite....
    <add name="MySqlConnection" connectionString="Data Source=mssql05.discountasp.net;Database=MYDATABASENAME;uid=MYUSERID;pwd=********"/>
    Is the syntax wrong for what i am doing???
     

Share This Page