Dotnetpanel Forums

I was wondering if anyone can provide me some resources to look at or just give me a default setup guide to integrating sql2005 with DNP?

i.e. what setting would go in the DNP server configuration under the SQL2005 section... I'm a bit unsure of what the internal and external addresses would be with sql2005 express and if I have to add certain dns records?

Unfortunately, most of my work has been coding databases and access layers using stored procedures etc, not actually configuring and maintaining the product or pipes and things of that nature so any help or pointers is greatly appreciated  

I am running MSSQL2005 on the same box and have the following:

• Internal address: SERVER_NAME\INSTANCE_NAME
• External adddress: SERVER_NAME_FQDN\INSTANCE_NAME
• Connection: trusted connection as it's on the same box, but you could also connect DNP to your SQL through a SQL account
• DNS records: none

If you are running MSSQL as default instance, you don't need to add the instance name I think. The DNS would come in handy if you would use a dedicated IP for MSSQL and would like to create a mssql.usersdomain.ext for every user so they can connect to MSSQL through their own domain as with stats, webmail, etc.