database connection

I am setting up a Dot Net Nuke site and i am running my owen database server. I have a domain name pointing to my comp which is just for database hosting so what is the string i need to put in my web.config to connect this is what i have right now:




connectionString="Server=(database323.com/happy);Database=dnn;uid=******;pwd=*********;"





database.com being the domain name and happy being the SQL instance

 

I usually do something like this:

Server=database323.com;Database=Happy;User ID=myusername;Password=p@55W0RD;Trusted_Connection=False

I assume that connects to the default SQL instance on your computer. If you want to connect to a different SQL server (not a database, but a completely separate instance of sql server) you might need to do some more research on connection strings.