Clever Geek Handbook

Need to know what the connection string should be set for in my web.config file for SQL Server 2005

I created an asp.net site that connects to a SQL server database. Currently on my development machine, I have a SQL Express Express connection with a file found in the website's App_Data file.

Now I need to upload a site to my host that has a SQL Server database installed. They gave me the name of the SQL server database - mssql.mydomain.com - but I'm not sure how to configure the connection string in the web.config file to point to this.

Any help would be much appreciated. - Thanks in advance.

0


source to share


3 answers 


Server=mssql.mydomain.com;uid=user_id_goes_here;pwd=password_goes_here


+2


source


www.connectionstrings.com



+1


source


Initial Directory = MyDatabase; Data source = mssql.mydomain.com; User ID = MyUser; Password = MyPassword

It works?

0


source






More articles:


All Articles