Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Deployment ProblemsDeployment Problems
Previous
 
Next
New Post
5/24/2006 9:26 AM
 

A lot of! These connection strings can't work, but I need more information to help you.

First question - how did you setup a database for the sql server running at ip 209.200.235.3?

You need to setup an empty database first on that server, define security permissions, etc. Did you take these steps?

 
New Post
5/24/2006 9:50 AM
 
OK - I think we need to re-clarify some things here, I am using SQL Server 2005 Express with the database file being located in my App_Data directory - so no I didn't create a database anywhere. If we revist my first post we will see that I uploaded the complete application including the database. Secondly I am using a LunarPages as my webhost and they told me that SQL Server 2005 was located at that IP address. However they haven't confirmed with me yet whether SQL Server 2005 Express is on that server - I was just playing around to try and see if I could work anything out while I wait for their support to get back to me - hence why I was trying to work out if those error messages gave me any information to go on or whether I should just wait till I hear back from them Thanks for helping - any more thoughts? 
Stefan Cullmann wrote

A lot of! These connection strings can't work, but I need more information to help you.

First question - how did you setup a database for the sql server running at ip 209.200.235.3?

You need to setup an empty database first on that server, define security permissions, etc. Did you take these steps?


www.creative-dreaming.com
 
New Post
5/24/2006 10:12 AM
 

Ok.

SQL Server 2005 will not load an database by its file name - this is a special feature of SQL Server 2005 Express. If your provider has only SQL Server 2005, you will need to attach the files as a new database to that instance, setup security again and finally use the classic connection string like you have done using msde or sql 2000.

 
New Post
5/24/2006 10:27 AM
 
Think we're still a bit unclear here... I am using SQL Server 2005 Express - someone kindly informed me earlier in this thread that the Express database engine can reside on a different machine than the website. I have not yet managed to confirm where the Express database is located (but they have confirmed they support Express) - so I am trying the server that I know SQL Server resides on while I wait for their response. Anyway if we assume that the Express database engine is located at the IP I gave is the connection string correct? Thanks
Stefan Cullmann wrote

Ok.

SQL Server 2005 will not load an database by its file name - this is a special feature of SQL Server 2005 Express. If your provider has only SQL Server 2005, you will need to attach the files as a new database to that instance, setup security again and finally use the classic connection string like you have done using msde or sql 2000.


www.creative-dreaming.com
 
New Post
5/24/2006 10:54 AM
 

I have been the one who kindly informed you before. There are different syntaxes of connection strings for sql server.


1) Server=.\SQLExpress;AttachDbFilename=pathtofile\database.mdf;Database=dbname;Database=dbname;Trusted_Connection=Yes;"
This string is used to attach a database file to a local SQL Server Express instance.

2) Server=servername\serverinstance;Database=DNN;User ID=xx;Password=xxxx;Trusted_Connection=False
Connects to the database DNN on the server servername, instance serverinstance using sql server security
This is aquivalent to
Data Source= servername\serverinstance;Initial Catalog=DNN;User Id=xx;Password=xxxx;
You are able to replace the servername with the IP address

3) Server= servername\serverinstance;Database=dnn;Trusted_Connection=True;
Now the owner of the running dnn process needs to have the permission to access the database using windows authentification. Ip address will not work!

There are some more possibilities, for more information see http://www.connectionstrings.com/

The main information for you:
Sql Server 2005 Express has to be installed on your local server if you want to use variant 1). Otherwise there is no difference between sql 2000, sql 2005 or sql 2005 express

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Deployment ProblemsDeployment Problems


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out