Connection String problem?

by AlexanderBeloev

Posted: 11 years ago 6 replies

PROGRAMMING

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

EDIT!!!!! - I will pay you $10 in your PayPal account if you help me fix the problem!

#connection #problem #string

KirkMcD 11 years ago

Are the db and the web server on the same computer?
Also take a look here:
SQL Server 2008 Connection String Samples - ConnectionStrings.com
- Thanks
- 1 reply
{{ DiscussionBoard.errors[7852575].message }}
- AlexanderBeloev 11 years ago
  
  Originally Posted by KirkMcD
  
  Are the db and the web server on the same computer?
  Also take a look here:
  SQL Server 2008 Connection String Samples - ConnectionStrings.com
  
  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:
  
  Thanks
  
  1 reply
  
  Signature
  >>> Learn How We Generated Over $48000 Revenue
  
  >>> In Under 30 Days With A Super Dirty CPA Secret That
  
  >>> Quite Frankly 99.9% Of People Don't Know About!
  
  {{ DiscussionBoard.errors[7852609].message }}
  
  AlexanderBeloev 11 years ago
  
  Hey Warriors,
  
  I really need help with this problem and will pay you if you help me to fix it!
  
  Thank you in advance!
  
  Thanks
  
  Signature
  >>> Learn How We Generated Over $48000 Revenue
  
  >>> In Under 30 Days With A Super Dirty CPA Secret That
  
  >>> Quite Frankly 99.9% Of People Don't Know About!
  
  {{ DiscussionBoard.errors[7854194].message }}
carleywatson 11 years ago

string query="Data Source=PC name; Initial catalog=Data base name; integrity security=true";
Sql Connection con = New Sql connection(string query);
con.Open();
- Thanks
{{ DiscussionBoard.errors[7858570].message }}

weaveronline

11 years ago

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

Signature

Thanks & Regards,
Reach us at dukeduke600@gmail.com.
Web Design| Logo Design | Banner Design | Web Development | Mobile Applications [iPhone/iPad/Android/Windows Phone]

{{ DiscussionBoard.errors[7859294].message }}

AlexanderBeloev

11 years ago

Originally Posted by weaveronline

Try this,
<add name="YOur Databasename" connectionString="Data Source=localhost/SQLEXPRESS; Initial Catalog=Your Databasename;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>

Yesterday I've found similar and it worked for me,

Anyway, Thank you all for the suggestions!

Thanks

Signature

>>> Learn How We Generated Over $48000 Revenue

>>> In Under 30 Days With A Super Dirty CPA Secret That

>>> Quite Frankly 99.9% Of People Don't Know About!

{{ DiscussionBoard.errors[7861327].message }}

Connection String problem?

Trending Topics

How did you turn it all around?

A healthy fascination for Hollywood...

Any thoughts on golf's latest phenom...Scottie Scheffler??

What's the Best IM-Related Skill to Learn Today That Can Help in the Future?

best high quality crypto traffic.