sql server - What Database Information Applies to What Connection String Attributes -
i attempting deploy asp .net mvc 4.5 website server. have database details , connection string written.
but unsure if connection string attributes correct , if have wrong way around. confused whether data source
represents database name or instance , whether initial catalog
server or else?
given database information below, connection string correct? uploading files server haven't had chance test yet.
db server: mssql.mywebsite.com
db instance: .\mssqlserver2014
db name: db_mydatabase
db user: myusername
db password: mypassword
<add name="myname" connectionstring="data source=.\mssqlserver2014; attachdbfilename=db_mydatabase; initial catalog=mssql.mywebsite.com; user id=myusername; password=mypassword;" providername="system.data.sqlclient" />
Comments
Post a Comment