September 8, 2008 at 4:58 am
After developing my website on my computer, how does one deploy the sql server 2005 database to the hosting site. I worked with Access before and all you had to do was copy, paste, but sql doesn't allow you to do that...
Any help will be appreciated.
September 8, 2008 at 6:13 am
It depends on your hosting provider. You should contact them. There may be additional cost - if they allow this at all.
October 9, 2008 at 4:06 pm
I am trying to do the same thing. I have developed a Default.aspx page with 2 objects (table handlers) which does Select statements against a SQL 2005 DB (1 table). The page works fine in the test mode, the localhost test offered by Visual Web Express. I've followed the instructions to add the page to IIS, but when I try to run it: I get the following error>
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "MyDatabase" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Again, there is no issues with logging into the DB either through Visual Studion, Visual Web Express, etc. Its just when I call the web page which refers to the SQL DB.
Do I need to adjust the properites of my web.config file? When I goto the ASP.NET tab, and hit the "Edit Configuration" button, I do not see a place where the web page is asking for the database creditials.
Any help would be appreciated. Thanks.
BTW, I am able to successfully "touch" the same table and render it using SQL Reports Serverices. But there was a configuration tool which was available to do this. Not so with the .aspx page.
October 9, 2008 at 5:06 pm
How are you login in to the DB? Are you connecting user sql login/password instead of windows authentication?
Does the network services has been granted access on the server and on the db?
October 10, 2008 at 11:30 am
Ninja, thanks for responding. Your questions jogged my memory and I figured it out.!
I reproduce the solution for myself and for all others who might be experience the same. Also, I am interested to know if this is the correct way, or if I'm onto a fluke!
Open Microsoft SQL Server Visual Studio > Expand the Server Tree > Expand the Security Tree > Expand the Logins Tree > Right Click the appropriate Login > Goto Properities > In the upper left hand corner , identify "User Mapping" under "Select a Page". > Highlight User Mapping > In the center of the screen, identify "Users mapped to this login" > Identify your Database under the column "Database" > Click the correspoding checkbox under the column "Map" . Then click "Okay" and click all the way out the applications.
Refresh the browser / Delete Temp files / and it produced the page I was looking for, hitting the local SQL. The SQL and the the IIS exist on the same machine.
http://localhost/WebSite/Default.aspx
However, when I substitute the "localhost" with the IP. I can render the page, but the drop down box is not fetching the db results as it did with "localhost" in the URL . Can anyone suggest a solution for this now?
October 10, 2008 at 12:01 pm
Fire up profiler and see what's going on. Try catching exceptions in the trace so that you have the real error right away instead of a general adodb error that tells you nothing.
Also checks that the server accepts remote connections.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply