sql express problem, very urgent

忆茹天使

create database tes
on primary
(
name = tes,
filename = 'c:\tes.mdf'
)
error:
Message 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Unable to create some of the file names listed. Please review related errors.
Message 5123, Level 16, State 1, Line 1
CREATE FILE encountered operating system error 5 (Access denied.) While trying to open or create the physical file 'c:\tes.mdf'.
Can be created in sql server

fanfan1980

--try

create database tes
on primary
(
name=tes,
filename='c:\tes.mdf'
)
on log
(name=tes_log,
filename='c:\tes_log.ldf')

fanfan1980

--Wrong, change


create database tes
on primary
(
name=tes,
filename='c:\tes.mdf'
)
log on
(name=tes_log,
filename='c:\tes_log.ldf')

wgfxman

Check user rights, directory access rights, whether the target file exists, etc.

忆茹天使

The big brother above doesn't work, I asked why it was wrong to create a system directory in sql express,
Including the directory where I created the application

create database tes
on primary
(
name=tes,
filename='c:\tes.mdf'
)
log on
(name=tes_log,
filename='c:\tes_log.ldf')
Tried, not the same error

忆茹天使

I use the sa system administrator login

忆茹天使

Is it necessary to set directory permissions? It was not set before.

wgfxman

The default log file is c:\tes_log.LDF

忆茹天使

Brother, is it related to the default log file?

wgfxman

See if it already exists c:\tes.mdf, c:\tes_log.LDF?