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

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -