Post reply

Create New Database

  • August 13, 2006 at 9:36 pm

    #173774

    Hi all, need ur help here...

    I attend to create a new database in the local harddisk in the server, the hard drive has been divided into 3 partition (C, D, and E)...

    The problem is i can't put the mdf and ldf files for the new database in the drive E, this partition has the biggest size. Why only C and D are showing in the option?

    is there anyone how to solve this...thx in advance...

  • August 15, 2006 at 9:01 am

    #655076

    Does the account that runs SQLServer have access to the E partition?

    Have a good day,

    Norene Malaney

  • August 15, 2006 at 8:11 pm

    #655190

    dear Norene,

    how and where to find out what is the account that runs the SQL Server??

    fyi, i'm using an administrator login when installing the sql server initially.

  • August 16, 2006 at 3:20 am

    #655221

    Look at the properties of the MSSQLSERVER service in the Services applet.  You can also find the same information in Enterprise Manager by right-clicking on the server name, choosing Properties and clicking on the Security tab.

    John

  • August 24, 2006 at 6:39 pm

    #656753

    Hi John, I did that you've suggested, my SQL Server machine run from the option: "system account" not the option "this account". What is that mean?

    I always login to the server as administrator, but i can put the mdf file in the drive E, instead the option only C and D. Did anyone have any experiences on this?

  • August 24, 2006 at 10:12 pm

    #656762

    Are you sure this E: drive is local, not mapped network drive?

    _____________
    Code for TallyGenerator

  • August 27, 2006 at 8:44 pm

    #657018

    Hi Sergiy,

    Yes, i'm sure. I have partitioned the server hard disk into three partitions C, D and E

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply