Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to set osqluser

Author  Topic 

kittu_s
Starting Member

3 Posts

Posted - 2005-11-02 : 03:06:52
Hi,
I am executing a script using osql command. After executing this script it will create .mdf and .ldf files after sucessful creation of database.

For .mdf and .ldf files I specified path as C:\Program files \<Folder name>

I logged as administrator to the system. Still it throws an error as “Access denied for open or create mdf file”

How to check under which user osql utility is running?

How to set the user for osql? I tried with setting “osqluser=administrator” in environment variable.

Still I am facing the same problem. Can you plese through a lite on this problem suggest me the solution.

thanks
krishna.s

Kristen
Test

22859 Posts

Posted - 2005-11-02 : 03:25:49
"I specified path as"

You will need to put quotes around the pah if it contains spaces. Personally I would never put Data in the "C:\Program Files\" path ...

"How to set the user for osql"

Type

osql /?

or

osql -?

for a list of parameter (or see them in Books Online)

Kristen
Go to Top of Page
   

- Advertisement -