Data base connectivity problem

Question

Dear All Hello I have created a website a web service. my web service is on different server my web site is on another and the database is on another server. in the website web.config file i have changed the connection string to the server of the data base. the web service calls the database correctly but when i run my website and try to login it tries to search the database localy and finaly throughs an error. what should i do.

Senthilkumar · Answer

Hi Can you post the error here. What you can do is ping the sql server from where you deployed your web application. check the authentication mode. If it is remote server then you have to use the sql server authentication mode. I suggest you to connect the sql server through sql server management studio with the credentials.