Data warehouse Table Space configuration SQL Server
Hello,
I,m setting this JTS and in the configuration of the data warehouse it asking for the folder where it is going to save the table spaces. I,m Using SQl server and its in a diferent server than my JTS server. Also I,m using a local sql account to access the Data warehouse db.
The question is how I,m suppose the enter the table spaces values:
Like C:\TableSpaceFolder
or
Like This \\server\TableSpaceFolder.
Like I said the sql server is a diferent server from the jts and I,m using a SQl local account, not a domain account.
2 answers
Comments
Thank, The user that have dbowner over the Data warehouse database is a local sql account, how can I give him read / writable access if is not a domain account.
That would be managed within SQLserver. I know one way to manage it is that the db user can be associated with a Windows user group. There should be some SQLserver documentation that provides the information on how to grant file system access to local sql db user.
For example,
http://msdn.microsoft.com/en-us/library/ms189128%28v=SQL.105%29.aspx
http://msdn.microsoft.com/en-us/library/aa905192%28v=SQL.80%29.aspx