MS SQL .Mdf attach problem
Hello
I am installing an website made in asp.net2 & mssql2005
I have copied all the files in the webserver directory and set the web.config connection string as below:
<add name="visuConnection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\visu_database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
Get error on the page:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I am running the appkication the virtual directory of the server. I have not created any database in the mssql, if I need to create one, then please let me know what should be the database name(what if I need the database name to be 'abc_db') and how to link the mdf & ldf files with them.
Thanks
Regards
Nikhil
|