Deployment error

Question

0.00/5 (No votes)

See more:

, +

Hello,

I deployed y web site using ftp server..

I copied my database schema with data and run the script..

I have chnged the web.congif file and ab.dbml.cs file..

web.congif:

XML

<configuration>
    <connectionStrings>


    <add name="dbbooksConnectionString" connectionString="Data Source=tcp:host.com;Initial Catalog=MyDB;User ID=User_NAme;Password=password;Integrated Security=False;"
       providerName="System.Data.SqlClient" />


  </connectionStrings>

================

I changed the database name and base paramaters as follows.
abc.dbml.cs file as follows:

C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;



[global::System.Data.Linq.Mapping.DatabaseAttribute(Name = MyDB]

public partial class booksDataContext : System.Data.Linq.DataContext
{

    private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();

  #region Extensibility Method Definitions
  partial void OnCreated();
  partial void Inserttbaut(tbaut instance);
  partial void Updatetbaut(tbaut instance);
  partial void Deletetbaut(tbaut instance);
  partial void Inserttbcat(tbcat instance);
  partial void Updatetbcat(tbcat instance);
  partial void Deletetbcat(tbcat instance);
  partial void Inserttbcatdet(tbcatdet instance);
  partial void Updatetbcatdet(tbcatdet instance);
  partial void Deletetbcatdet(tbcatdet instance);
  partial void Inserttbcnt(tbcnt instance);
  partial void Updatetbcnt(tbcnt instance);
  partial void Deletetbcnt(tbcnt instance);
  partial void Inserttbcty(tbcty instance);
  partial void Updatetbcty(tbcty instance);
  partial void Deletetbcty(tbcty instance);
  partial void Inserttbord(tbord instance);
  partial void Updatetbord(tbord instance);
  partial void Deletetbord(tbord instance);
  partial void Inserttborddet(tborddet instance);
  partial void Updatetborddet(tborddet instance);
  partial void Deletetborddet(tborddet instance);
  partial void Inserttbpub(tbpub instance);
  partial void Updatetbpub(tbpub instance);
  partial void Deletetbpub(tbpub instance);
  partial void Inserttbsta(tbsta instance);
  partial void Updatetbsta(tbsta instance);
  partial void Deletetbsta(tbsta instance);
  partial void Inserttbreg(tbreg instance);
  partial void Updatetbreg(tbreg instance);
  partial void Deletetbreg(tbreg instance);
  partial void Inserttbbook(tbbook instance);
  partial void Updatetbbook(tbbook instance);
  partial void Deletetbbook(tbbook instance);
  #endregion

    public booksDataContext() :

       
        base("Data Source=tcp:host.com;AttachDbFilename=MyDB.mdf;User ID=UserName;Password=password;Integrated Security=False", mappingSource)


    {
        OnCreated();
    }

    public booksDataContext(string connection) :
            base(connection, mappingSource)
    {
        OnCreated();
    }

I am trying to run the application. I get folowing error:

Server Error in '/' Application.
--------------------------------------------------------------------------------
CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file MyDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file MyDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:

Line 306: public ISingleResult<dspAllBooksResult> dspAllBooks()
Line 307: {
Line 308: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
Line 309: return ((ISingleResult<dspAllBooksResult>)(result.ReturnValue));
Line 310: }

Source File: e:\web\kainthte\App_Code\books.designer.cs Line: 308
Stack Trace:

[SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file MyDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009598
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +43
System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +47
System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +20
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +57
System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters) +83
booksDataContext.dspAllBooks() in e:\web\kainthte\App_Code\books.designer.cs:308
WUCBooks.Bnd_DataList() in e:\web\kainthte\WUCBooks.ascx.cs:58
Default2.Page_Load(Object sender, EventArgs e) in e:\web\kainthte\Default.aspx.cs:18
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +91
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

Please help me...

I have been trying to solve it from last 2 days.

Many thanx,
Jass

Posted 13-Jan-11 10:40am

Jass22

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rama Krishna Vavilala · Answer 1 · 2011-01-13T12:38:00

Solution 1

You need to specify the full path of the file MyDB.dbf e,g c:\database\mydb.dbf. Also makes sure that the NT AUTHORITY/NETWORK SERVICE or ASPNET user has permissions to create database on the sql server. Finally, the file has to be present on the sql server.

Posted 13-Jan-11 12:38pm

Rama Krishna Vavilala