웹 및 클래식 호스팅 도움말

Connecting to a SQL Server Database Using ASP.NET 3.5

Before you upload your ASP.NET 3.5 application onto your hosting server, you need to modify the connection strings section of your web.config file.

Note: You may want to back up the web.config file on your local computer or simply comment out your current connection strings before you make any changes. This way, you can easily return to developing your application on you local computer.

This is an example of the connection strings section that will connect an ASP.NET 3.5 application to one of our SQL Servers:

<connectionStrings>
	<add
		name="Personal"
		connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;
			Database=DB_675;
			User ID=user_id;
			Password=password;
			Trusted_Connection=False"
		providerName="System.Data.SqlClient"
	/>
	<remove name="LocalSqlServer"/>
	<add
		name="LocalSqlServer"
		connectionString="Server=whsql-v04.prod.mesa1.secureserver.net;
			Database=DB_675;
			User ID=user_id;
			Password=password;
			Trusted_Connection=False"
		providerName="System.Data.SqlClient"
	/>
</connectionStrings>

Note: You can find your server name, database name, user ID, and password in the SQL Server section of your Hosting Control Panel. These connection string values map to host name, database name, user name, and password, respectively. The user name and password values are those specified during SQL database (not hosting account) creation.


이 글이 도움되었나요?
피드백을 보내주셔서 감사합니다. 고객 서비스 담당자에게 문의하시려면 지원 전화 번호 또는 위의 채팅 옵션을 이용하시기 바랍니다.
도와드릴 수 있어 기쁩니다! 더 도와 드릴 것이 있나요?
그것 유감스럽습니다. 혼동이 되었던 사항 또는 솔루션이 고객님의 문제를 해결하지 못했던 원인을 알려주세요.