Last post Jan 22, 2009 04:04 AM by prabhatasp
Jan 19, 2009 04:49 AM|prabhatasp|LINK
I am Prabhat, I am newer in web development.I face a problem with custom action. My setup is installing on my vista machine but i am getting an error on Xp an win server. Acctually I do not understand what is the problem, Please help me.
I am creating custom action to create database at installation time. for this i have created a custom action installer class and include it in my web setup project.I paste my code here.
masterConnection.ConnectionString = DBCustomAction.My.Settings.masterConnectionString
app.config file which is using for connection string at installation
It works fine on my vista machine but i am getting an error on win xp and win server 2003. the error is
"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) "
Please help me as soon as possible.
Thanks in advance.
Custom Action Problem with websetup project
Jan 19, 2009 07:38 AM|kaushalparik27|LINK
connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=master;Integrated Security=True"
you need to work around your connection string. i would suggest not to use integrated security like above. create a sql user login for your db and use those userid and password in your connection string. also check that remote connections are allow in your
"surface area configuration (start > microsoft sql server 2005 > configuration toold > surface area config)
you can also get help on that here >
ConnectionStrings.com - Forgot that connection string? You will find it right here!
hope it helps./.
Jan 22, 2009 04:04 AM|prabhatasp|LINK
Thank you very much. I will try to Apply your suggesion. I am very happy because i am getting first reply from you on Asp.net forum.
Tankyou Very much again and again.