Server Macloudd

Mike P asked:


I am not sure what would my connection string be like on my asp.net website:

These are the information that I can get from my server host:

(I am using MS SQL Server)

Server info:

Host Name: mssql123.websitename.com (or the IP address)

Server Login: login_DB
Server Password: xxxxx

My empty database in server:

DB name: ar_cub
DB login: ar_DB (no password provided)

Now I need to create my connection string to be able to connect to my database.

I assume it should be something like:

mConnection = new SqlConnection(”Server=’mssql123.websitename.com’;Database=ar_cub;Trusted_Connection=True;Integrated Security=SSPI”);

Or maybe I should put my db’s username/password as well as the servers username/password? How?
Thanks in advance

Kathleen