Error while Deploying WebMatrix Beta Application having SQL Database...
Last post May 17, 2011 04:49 AM by simtan
Sep 21, 2010 09:13 AM|thewebhostingdir|LINK
I have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery.
Now I want to deploy it on the remote server using Web Deploy method.
Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error:
Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).
Can anyone have the solution of this error?
Thanks in advance....
Sep 21, 2010 03:42 PM|simtan|LINK
When you selected to publish with the SQL database, was there a text box in the Publish Settings dialog that allowed for a connection string to be typed in?
You are usually provided with a database connection string from your hosting provider when you sign up for an account. It looks something like this:
Sep 22, 2010 03:32 AM|thewebhostingdir|LINK
Thanks for the reply. I have tried the Connection String that you have suggested but it didn't work.
I got the following error:
10:26:42 AM: Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy Provider is dbFullSql).
10:26:42 AM: Publish Failed.Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy Provider is dbFullSql).
10:26:42 AM: Error Detail:
10:26:42 AM: (9/22/2010 10:26:42 AM) An error occurred when the request was processed on the remote computer.
10:26:42 AM: at Microsoft.Web.Deployment.StatusThreadHandler.CheckForException()
10:26:42 AM: at Microsoft.Web.Deployment.AgentClientProvider.RemoteDestSync(DeploymentObject sourceObject, DeploymentSyncContext syncContext)
10:26:42 AM: at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
10:26:42 AM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
10:26:42 AM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
10:26:42 AM: at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
10:26:42 AM: at Microsoft.Web.Management.Deployment.MsDeployWorker.Execute()
Attempted to perform an unauthorized operation. dbFullSql http://go.microsoft.com/fwlink/?LinkId=178034
I have some queries:
1) Which Username and Password are used in Connection String? Created from the
Website Panel or the IIS Manager Users
2) My Database Server and Web Server is different so, I want to know that which server address is used in Connection String?
3) Is there any IIS related configurations required at Database Server?
Thanks in advance ...
Sep 22, 2010 06:24 AM|simtan|LINK
Yes, the connection string I gave above was just a sample - you'll need to substitute your own custom values into the connection string (replacing what's after each '=' symbol).
You should be using the database server's information in the connection string, and there should be an associated username and password along with a database name. I'm not sure where this information is for you, but I am guessing that if you have a Website
Panel, you should be able to find it somewhere in there.
The database information is generally different than the IIS Manager user information.
Sep 22, 2010 09:04 AM|thewebhostingdir|LINK
I have substituted my own custom values for the connection string. According to my knowledge there is no problem with it.
I want to know about Server side configuration settings and IIS settings for SQL database deployment.
Is there any IIS related configuration settings required to be performed on Database Server for SQL database deployment?
Or any other settings needed to be performed on Database Server or Host Server?
Thanks for the reply...
Sep 23, 2010 12:12 AM|panic_at_the_disco|LINK
Hi there, definitely looks like a connection string or database permissions issue. Some questions:
1. What happens when you click Validate Connection in the WebMatrix Publish Settings dialog?
2. Are you able to connect to the database using SQL Server Management Studio Express 2008? This is a good way to check if you can even connect to the db and create tables in it.
Sep 23, 2010 01:18 AM|thewebhostingdir|LINK
Thanks for the reply.
When I click on Validate Connection in Web Matrix Publish Settings dialog box it gives
“Connected Successfully” message.
I can also connect to the database using SQL Management Studio Express 2008.
There is no issue related to the values provided in the Publish Settings dialog box in Web Matrix. I can successfully deploy the Web Matrix application without selecting SQL database.
I think there are some settings missing at the Server side.
I want to know which Server Address [Database Server or Web Server] is used in the Connection String?
Is there any additional settings require at any of these servers?
Sep 23, 2010 06:50 PM|simtan|LINK
You should use the Database Server in your database connection string. Don't forget that the database username/password is generally different than your Web Deploy username/password.
May 13, 2011 01:34 AM|jatin.maniyar|LINK
MS SQL sever
May 17, 2011 04:49 AM|simtan|LINK
Could you describe the errors you are seeing? Is it during the publishing process, or at the Publish Settings screen? If there are error logs also, it would be very helpful if you would post them here.