Last post Jan 05, 2008 02:41 AM by Rasetti
Jan 04, 2008 02:04 AM|ravi.ambar|LINK
I have one asp.net application and i am trying to deploy that application. when we create setup file of web application what are the prerequisite for that
2)Reportviewer (my application have some reports)
3) sql server component (?)
actually i had created an intra net application and also it will be used on single system . but when i had created setup file for that and deployed application. on client machine it is showing sql server remote connection error.Client system having WINDOWS
XP with IIS only. Now wht are the prerequiste that we hav to install explicitly? It is mandatory that client machine also have Sql server or any component of sql server.
plz help me . it's urgent ......
thanks in advance
Web Deployment Project
web deployment projects
Jan 04, 2008 07:44 PM|Rasetti|LINK
Exactly what kind of SQL error are you getting? Have you setup correctly your connection strings? And your ReportsServer url?
For what you say it looks like a permissions problem, because you just need SQL installed on the machine where the application is trying to connect to...
Try posting more details about the error and your connection string and we ay be able to help you some more,
Jan 05, 2008 12:56 AM|ravi.ambar|LINK
thanks for help. My application is running very well when i had installed SQL server on client machine.
But for NON-SQL machine i am getting following error whenever i am trying to run web page.
Pages which are not linked with database (static pages) are running very well but pages with database are showing this error.
My Connection string :
<add name="connectionstring" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|YFinn.mdf;Integrated Security=True;User Instance=True" />
* note that application is running properly when i had installed SQL server on client machine.
My application will be deployed on a single system for single user (not on any web server) then i want to know that is it mandatory that SQL server is also deployed on client machine ???????.
Instead of Installing SQL server is there any way to run application without SQL SERVER with the help of sql component.
web deployment projects
Jan 05, 2008 02:31 AM|Rasetti|LINK
Looking at your connection string, you are connecting to a local instance of SQL Server, so, in short, you need SQL Express on the client machine.
In your scenario (single machine), there is no other way.
Jan 05, 2008 02:35 AM|ravi.ambar|LINK
I had installed Sql Express and now all is going ok
Jan 05, 2008 02:41 AM|Rasetti|LINK
Excellent! I'm glad it's working now!