Hi Guys

Please help... I'm fairly new to asp.net and can't seem to figure out how to deploy my web project to the web server. I keep getting error message "Specified SQL Server not found: (local)\NetSDK" and I'm guessing it's because I need a different value to the server property in the connection string when my database is on the web server rather than on my local machine. Is this correct? And if so, what should the connection string say?

Thanks

http://www.connectionstrings.com/

Take a look at the different ways to connect.

Yes, the webpage covers what you should use.

Thanks but now I'm even more confused...

I'm not really sure which one I should be using. Is it the standard security one and what is the difference between the data source and the initial catalog.

Standard Security:
"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd

If I'm not mistaken the Initial Catalog should be the Database Name like Northwind, pubs, etc.

Data Source should be the Server that SQL Server resides.

ok cool, but how do you know what the server name is. Is it web address. So say for example, www.mydatabase.com is a database driven web site and the sql server database sits on the root directory of the web server. Would the server name then be mydatabase.com???

The connection string you have been using should be fine if it's been working all along, you just need to change the server name. Of course, if security is set up differently on the web host's database system then you'll have to adjust accordingly.

If the database is running on the same box as the web application then "localhost" for the server name should work. You need to check with your host provider what name should be used.

I'm getting a different error now.. "SQL Server does not exist or access denied" but I guess I should open a new topic. I've never used one of these forums before but I have to say that so far so good.

It's been very helpful.
Thanks All