Connection String problem?

by 6 replies
7
Hello fellow warriors,

The case is as follow:

I download the database, I download also the website files. Then add the database to SQL Management Studio Express 2008 and try to connect the site files using Sitefinity Project Manager. But it doesn't happen. Maybe the problem is in the connection string.

Here it is:

<add connectionString="Data Source=localhost;
Initial Catalog=my database name;
User ID=my database user;
Password=database user password;"
providerName="System.Data.SqlClient"
dbType="MsSql"
name="Sitefinity" />

If you can't notice any problem in the connection string, can you name the exact steps I need to do to connect the website to the database?

Thank you all in advance!

Best regards,

Alex


#programming #connection #problem #string
  • Are the db and the web server on the same computer?
    Also take a look here:
    SQL Server 2008 Connection String Samples - ConnectionStrings.com
    • [1] reply
    • Yes they are on the same computer,

      Thanks for the suggestion, I have checked them, but I need a solution, there are many different connection strings.

      Thanks for your help!

      Any other suggestions? :confused:
      • [1] reply
  • string query="Data Source=PC name; Initial catalog=Data base name; integrity security=true";
    Sql Connection con = New Sql connection(string query);
    con.Open();
  • Try this,
    <add name="YOur Databasename" connectionString="Data Source=localhost/SQLEXPRESS; Initial Catalog=Your Databasename;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
    • [ 1 ] Thanks
    • [1] reply
    • Yesterday I've found similar and it worked for me,

      Anyway, Thank you all for the suggestions!
Join the discussion

Next Topics on Trending Feed