How To use SQL Server Database

Hi.

I am Create a web Application Using Visual Web Developer and SQL Server 2000, I am Upload my Database on web server also. Now what Chaning req. in my application for access my web server database online.

Reagrds

Fakhruddin

Usually, the only change you would need to make is the connection string to make sure it points to the Sql Server that your web server has access to.|||

Thanks Mike

Can your give me Example. ?

this is my Connection string (LOCAL)Data Source=MYSERVER;Initial Catalog=Testing;User ID=sa; Password=xxxxx

if my server IP for eg. is 168.0.2.0 then ?

wating for your +ve reply

Thanks

|||

No, I can't give you a meaningful example that you can use. The thing that would change is the name of the server (Data Source), and only the person who manages the Sql Server you will be using can tell you that. You would be better advised asking your web hosting admin/support for this information.

|||

Hi Fakhruddin,

Based on my understanding, I think you are asking about how to connect to your database again after you have migrated it to a new web server ( the "changing requirements" as you have mentioned in your first post).

Well, I think what you should do now is exactly like our community member Mikesdotnetting has suggested you in his last post,

"Usually, the only change you would need to make is the connection string to make sure it points to the Sql Server that your web server has access to "

Generally speaking your connection string should look like this: Data Source=MYSERVER;Initial Catalog=Testing;User ID=sa; Password=xxxxx

And what you need to do now is to make sure that

1. the "data source" section has been filled in with the new server name(or IP Address in most cases)
2. you have used the right User ID and Password as the web hosting admin/support has given you(you can only get this user id/password from your web hosting admin/support).

Hope my suggestion can help. Thanks.

|||

Bo - that's all well and good if the OP has access to the web server. I understood his question related to the changes he would have to make to his existing development set up twhen migrating to a hosted environment. Are you reading it differently?