Deployment of Web Applicatoon

Question

Deployment of Web Applicatoon

Abraham Murtala

SSC Enthusiast

Points: 102
More actions
June 19, 2007 at 10:54 am

#196414

Hi All, Please can anyone Help me with this probs, I have a web application that is working on my development system but when deploy it to my client it cant connect to SQL server 2005.

thanks all

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

Is it that you have your web application deployed in the same machine where your sql server is also running. Check for the remote connections properties in the instance and enable if its disabled.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Abraham Murtala SSC Enthusiast Points: 102 More actions · Answer 2

Hi Thanks for your kind assistance, the problem is when i deploy the web ASP.NET application to my client system, and trying to access or do anything with the SQL server 2005 that i get the error not on my machine. the one on my machine is fine, the IIS and ASPNET are not connecting to SQL server 2005.

please what do i do, cause i have a client web application that need to be deployed.

thanks

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Is remote connections enabled in your sql server if not do that and check if you are able to connect to the database engine remotely.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Abraham Murtala SSC Enthusiast Points: 102 More actions · Answer 4

Hi Sugesh Kumar R.,

How are you doing, and thanks for your prompt assistance.

you see just as i reply in my last post, I have check the Remote connection on the SQL Server and it is enabled but still the web apps did not connect to the sql server instead it will give an error "Login fail to connect to server instance" and i have done all i could but still having that same problem. please if there is any where or help that you can to connect IIS to SQL server 2005 so that they could allow my connection to my database store via my code.

thanks very much.

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 5

Since you say that you have enabled remote connections few checks from our side.

from the machine where you face this problem try using SSMS to connect to the SQL Server and see if you are able to make successful connection. IF so build a connection string from the machine and use it in the web application. If not there might be few that stops you making connections like port numbers being used, protocols, etc. check them.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Abraham Murtala SSC Enthusiast Points: 102 More actions · Answer 6

Hi Sugesh Kumar R.,

Thanks for your kindly help, I dont realy know how to get to use the SSMS please explain how to do that. And for the protocool it is TCP/IP but the port I dont know.

Please your help on this matter, I realy need and appreciate.

thanks

Abraham Murtala SSC Enthusiast Points: 102 More actions · Answer 7

Hi Sugesh Kumar R.,

Thanks for all your help,I must admite that you are very knd. I finally resolve the problem and it very simple, so I love to share with others who mite have the same problem.

After you enable the SQL server for remote connection by right clicking "my computer" and select "manager" expand the "services and Applications" expand the "SQL server Configuration Management" select the "SQL server 2005 Network Configuration" at the rigt pane select the server and Enable TCP/IP and make sure the SQL Browser service is runing.
At the SQL server 2005 menu, select the configuration Tools, then select "SQL server surface area configuration" and click on "Surface Area Configuration for service and connections" from then Select "Remote Conection of your server instance" and select "local remote connections" finally selec "Using Both TCP/IP and Named pipes"
Finally from the Firewall browse to select the server and the SQL browser

that is all. and you are good to go.

once more thanks.

Abraham Murtala SSC Enthusiast Points: 102 More actions · Answer 8

hi all,

i have a probs with crystalreoprt for VS 2005, the report is working fine but the probs is that, the navigation and print button is not working, anyone with solution? please i need your help urgently.