Brad Roland
Hi All,
I've got an SQL 2005 server setup with some databases. I'm trying to set it up so that a user can upload his database backup and then restore the DB using Studio Express but am having some issues with it. The user can upload his database fine, but when we try and go in to restore it, he can't view the directory or file of the backup. I've added the service account that SQL runs as, as well as the SQL2005%Machine%etc... user without much luck. The only thing I can think of from here is SQL permissions and I'm a little vague on how to accomplish what I want. One other thing is that if I add sysadmin rights to the user, they can see the directories fine. I tried adding dbcreator as recommended by other posts and that didn't work either. Any help would be greatly appreciated. Thanks!
Brad
SQL Restore Rights
SQL Server Security
-
- Previous
- 1
- Incorrect processing order for views Hi Martin Thanks for your suggestion. Similarly to what you suggest - I am looking at ways of introducing a generic mechanism in our system to provide a means of running scripts that replication should have run. As some subscribers are SQL Express this can't be an agent job I did look at using the pre-snapshot script for this purpose - but this script is only run when initializing The case I have cited is just one instance of the type of ordering problems that may be encountered - so I can't just code for this specific case Note that I created the new view manually on a test system and profiled the subsequent merge (which was successful). As anticipated all the 'alters' were run first and then the 'creates' came along afterwards. The processing order applied was correct within the 'alters' and correct within the 'creates'. However, the processing order needs to be applied across the whole set of 'alters' and 'creates' together aero1 Tag: SQL Restore Rights
- 2
- Unable to read local eventlog (the parameter is incorrect) What is the status of this bug I just recently had two seperate servers go absolutely bonkers, flooding the SQL Server error logs and application logs with these errors... one machine has since settled down after a restart of the SQL Server agent, the other continues to throw this error every hour or so... Thanks, Joe Tag: SQL Restore Rights
- 3
- Database Blobs & Performance Unless you have specifically created the table with the image/binary data 'in the row', it is NOT stored in the table. sp_tableoption N'MyTable', 'large value types out of row', 'ON' is the default. In the table, there is only a 'pointer' in the actual location. In any case, NOT including the image/binary field in the SELECT statement will definintely enhance performance. But there will be little effect noticed by moving the image/binary pointer (16 bytes) to another table. Tag: SQL Restore Rights
- 4
- How to extract domain name from an email address?? Ok, then drop the part to the right of the last dot: declare @email varchar ( 50 ), @domain varchar ( 50 ) set @email = 'johndoe@nl.eu.whatever.com' set @domain = substring ( @email , charindex ( '@' , @email )+ 1 , 50 ) set @domain = substring ( @domain , 1 , len ( @domain ) - charindex ( '.' , reverse ( @domain ))) print @domain This gets the subdomains as well, if you only want the top domain you'll have to do sonthing similar to get the bit after the last dot. Regards Gert-Jan Tag: SQL Restore Rights
- 5
- problem connecting Remote Analysis service 2005 from vb.net 2005 This almost sounds like there might be a firewall or something blocking the communication. Are you able to connect and query the cubes from remote machines Are you using a windows account that has permission to process the cube You can send an xmla command to process the cubes, but you need to be able to connect first. Tag: SQL Restore Rights
- 6
- select inside update query? Is it possible for me to do something like update table1 SET var1=something,var2=something2 from table1 (SELECT * from table2) as newtable where newtable.field1=acondition Tag: SQL Restore Rights
- 7
- SSAS processing Hi, I've looked at this issue several times but I couldn't solve this problem. Here is the situation: I only have 1 data source and deploy and process cubes to local machine and another target server with same database name. ( SalesCube > Local Server and target Server) I tried to create AS processing package in 2 ways: Package in Local Package in Target Server When I run these 2 packages it reads the data and processing is successful. (I run the sql profiler and check it) But the problem is data or dimension /cube structure is not updated. In management studio of two servers (local and target) , if I try to process cubes processing succesful but not updated also. So. I'm manually processing the cubes through BIDS but is there anything that I'm missing Please advice me. Thanks in advance. Tag: SQL Restore Rights
- 8
- Schema (owner) Names Not Visible In Shapes On Diagram When reverse engineering a SQL Server 2005 database (using VS 2007 Professional), I can't figure out a way to display the schema name in front of the table name in the database diagram. For instance, If I have a table named Person.Type, it just comes over as Type. It knows what the schema is because it's in the properties box for that object. It just doesn't appear in the name on the shape itself. Is there a setting somewhere that I'm missing that will display the schema in the name Tag: SQL Restore Rights
- 9
- Select Statement Problem? A single pass through the table and just concatenate tel1 and tel2. e.g. Code Snippet select name, telephone1 +isnull(char(13)+char(10)+telephone2,'') [telephone] from tb Tag: SQL Restore Rights
- 10
- MS SQL2005 express ed + SSIS installation problem You can't download it unless you have purchased it. Tag: SQL Restore Rights
- 11
- Problem in MDX query for calculating total sales. hi, can someone help in finding the error in this mdx query for the given problem statement. Query : Sales performance by gender of the customers. - The expected output is 2 values of sales ,one for all male customers and other for all female customers. - The level CustomerID of dimension Customer has attribute GENDER. - I have calculated two sets [Male] and [Female] . - At present i am getting sales value for all the members ,i want one aggregated value for male set and another value for female set.How do i go about doing this Please help. MDX Query : WITH set [Male] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "M")' set [Female] AS 'Filter ([Customer].[CustomerID].Members,[Customer].CurrentMember.Properties("GENDER")= "F")' SELECT {[Measures].[SALES($)]} ON AXIS(0), {[Male],[Female]} ON AXIS(1) FROM [cubename] Tag: SQL Restore Rights
- 12
- help enabling FTS in multiple database Hi Amit, Thanks for ur reply. When FTS failed on our remote server, we tried the same in our domain. We installed SQL 2000 on one of our servers, restored the same database instances on to this server and tried full test search. It worked fine on all the 4 instances. What I meant to say was the we had tried to do it in a member server on our domain and or remote server is a standalone server not attached to any domain. here are the ans. Hope it wud be clear to u. 1. The databases are actually a collection of resume summary and we are trying to do something like a keyword search. meanwhile this is a database server for a recruitment website. 2. No, nothing is happening in the background, MSSearch instantaneously stops. 3 & 4. It is a 32 bit server and 32 bit SQL. 5. SQL Server 2000. 6. There is nothing logged into the log files. 7. The server has 2GB of RAM 8. There are other SQL instances running abut without FTS. 9. I am sorry we hadnt checked with the perfmon, we had no clues of low memory availability as the same was the case when we tried to do it with the default databases too like northwind and pubs. 10. The query also leads to a service stop. Thanks once again, Smitha Tag: SQL Restore Rights
- 13
- Dervied Column - Expression? Try doing that in an OLE DB command... You can't execute a SQL statement in a variable. You can store a SQL statement in a variable as it's just a string. You can even make that statement dynamic using variable expressions. Tag: SQL Restore Rights
- 14
- How Do I Hide Internet Explorer Menu and Tool Bar Hi - You should be able to do this using javascript in the calling page. Something like: function popReport(parm) { window.open("path\to\report parameters="+parm, "WindowName", "location=no, scrollbars=yes, menubar=no, status=no, resizable=yes, height=500px, width=300px"); } You can call it using the onclick event of an item in the calling page, like: <a onclick="return popReport('<% =label.Text %> ')" href="#">....</a> Here's a link to some more information http://msdn2.microsoft.com/en-us/library/ms536651.aspx HTH... Joe Tag: SQL Restore Rights
- 15
- The INSERT statement conflicted with the FOREIGN KEY constraint FK_source_destination. You need to do the same thing on the other tables. The FK CONSTRAINT must be on the table that requires data to be in [Users]. You have it backwards, requiring data to be in the other tables before it can be put into [Users]. Remove these CONSTRAINTs from [Users], and add them to the appropriate table. ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_lastlogin] FOREIGN KEY([userid]) REFERENCES [dbo].[lastlogin] ([userid]) GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_precedence] FOREIGN KEY([userid]) REFERENCES [dbo].[precedence] ([userid]) GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_savedsearches] FOREIGN KEY([userid]) REFERENCES [dbo].[savedsearches] ([userid]) GO ALTER TABLE [dbo].[users] WITH NOCHECK ADD CONSTRAINT [FK_users_userphotos] FOREIGN KEY([userid]) REFERENCES [dbo].[userphotos] ([userid]) GO And then if you get erros on adding data to these tables, it will be because the [UserID] does not exists in the [Users] table. Tag: SQL Restore Rights
- 16
- Missing Properties??? Has anyone tried to open a cube into Business Intelligence Studio and the properties for the database vanished (project menu, properties) How do you get them back Tag: SQL Restore Rights
- 1
- Next
- 1
- Multiple masks in a For Each File Loop container Actually it's about cleaning up what I created in the TEMP folder, I don't want to wipe out everything there, only my "Mask1*.txt" and "Mask2*.csv". I was thinking of something similar when you use File->Open and you have multiple masks. Tag: SQL Restore Rights
- 2
- stored procedures compilation i think you must have a look at Query Notifications feature of SQL 2005. read Using Query Notifications in BOL. Basically , u have to enable service broker on your database. Madhu Tag: SQL Restore Rights
- 3
- Permissions for creating views You will need to grant alter on the schema and create view on the database to the user who wants to create views. T-SQL: grant create view to user1 grant alter on schema: bo to user1 go HTH, -Steven Gott SDE/T SQL Server Tag: SQL Restore Rights
- 4
- Cant install SQL Server 2005 on vista.. and there was me thinking Ultimate edition would be just that... ultimate . apparently not. Maybe it requires business edition.. Tag: SQL Restore Rights
- 5
- GENERATE(): Is there an alternative? WITH SET MYROWS AS FILTER ( NONEMPTY ([Machine].[Machine Name]. MEMBERS * [Date].[Date]. MEMBERS * [Patch].[Patch Name]. MEMBERS , [Measures].[Patch Applied]) AS MYSET, NOT (MYSET. CURRENT . ITEM (0) IS MYSET. ITEM ( RANK (MYSET. CURRENT , MYSET)). ITEM (0)) ) SELECT MYROWS ON 0 FROM [MyCube] Try the above it should list the last patch applied per Machine. Just with the Machine and Patch if you and the patch per Machine, which is not the same thing J . I run this same sort of quest on my cubes and verified the result in my DW. I would recommend you do the same. Tag: SQL Restore Rights
- 6
- Activation procedure design I've been experimenting with Service Broker and was surprised at one aspect of the design: the interface to Activation stored procedures. I would have expected the queue to be a parameted passed to the procedure rather than having to hard code the queue query into the SP. In a system with lots of queues it seems plausible that the same activation procedure might want to be used with several queues. Any comments David. Tag: SQL Restore Rights
- 7
- Replacement for Access Forms Thanks a lot for the reply, Madhu and Arnie. Let me start exploring the ADP. Thanks, Sundar Tag: SQL Restore Rights
- 8
- Setting Maximum Memory I need to up the Maximum Memory setting. Out of the box it is set to 2147483647 MB. I assume this is ~2GB. I have been instructed to set it to 1GB less than total server memory which is 16GB. When I change the value it just changes back. How do I change it and how are these Megabyte numbers calculated OS: Windows 2003 R2 Enterprise SQL: SQL Server 2005 Standard Thanks! Tag: SQL Restore Rights
- 9
- SQL CE top/limit, unable to find WORKABLE solution According to the Synchronization Services CTP, which includes as SQL Compact Edition 3.5 CTP, the following features are planned for SQL CE 3.5 (Orcas timeframe - who knows when ): Support for the timestamp datatype Nested queries in the SELECT FROM clause CROSS APPLY and OUTER APPLY operators CAST function and TOP clause Support for the ADO.NET Entity Framework and LINQ to Entities with System.Data.SqlServerCe.Entity.dll (under Orcas) Enhanced table editor for VS Orcas can add foreign key constraints Support for local transaction scope Tag: SQL Restore Rights
- 10
- sql server 2005 Hi , i'm a C# developer. I want to upgrade this hotel app. i made from using access to SQL server. I got SQL server express 2005 and the management studio . Now i've been looking for a proper book for a whole lot of time. The last book i reviewed was Programming Microsoft SQL server 2005 . It says : "We assume you have basic, working knowledge of .NET programming in C# on the client and Transact-SQL (T-SQL) on the server. On the tools side, we assume you are familiar with the prior generation of SQL Server and .NET toolsspecifically, SQL Server Enterprise Manager, SQL Query Analyze r, and Visual Stdio .NET 2002 or 2003." ARRRG ! I'm good at C# , and ADO.NET , (datasets , adapters etc) , but i have no idea of what SQL server is all about. I 've never run any older version and never used any of thier dbs I know simple sql query statements like "SELECT * FROM <sometable> Where <somecondition> ". Oh and i have VS.NET 05 pro. I need a book that covers : installing a db on a pc , and mantaining it programatically via C# Adding tables , rows columns again , programatically working with relationships. Tag: SQL Restore Rights
- 11
- Merge Join - Output of Lookup as sorted field? Lindsay wrote: In the merge join transformation, it will join on the originally specified join keys, which would be incorrect for me. So I'm not sure how this would be correct Where's the merge join Before or after the lookup Tag: SQL Restore Rights
- 12
- Config and Connection String The other guys are quite right but it may help to explain why. As you may or may not be aware, a few years ago Microsoft introduced a programme called the 'Trustworthy Computing Initiative'. An effort to try and make their products more secure. This is one of the main reasons it took them so long to get Vista out of the door. Anyway, you can see the effect of this here. If you are going to store passwords in a text file (which is inherently a security risk) then Microsoft want YOU to be responsible for doing that - they will not do it for you. -Jamie Tag: SQL Restore Rights
- 13
- Standard Edition Limits and Partitioning by Multiple Cubes Hi Thomas, if you made full process of dimensions, all partitions schould be fully reprocessed. if you made update process of dimensions, all partitions loose indexes and aggregations but keep the data and schould be processed with ProcessIndexes options. Tag: SQL Restore Rights
- 14
- New features of Reporting Service in SQL 2008 BOL is SQL Server Books Online. Documentation for all SQL Services and much, much more. You should find it in SQL Server 2008 start program group, if not run again install and chose books online. Tag: SQL Restore Rights
- 15
- expressions based on subtotals was able to nest a table within a matrix and do all my calculations Tag: SQL Restore Rights
- 16
- reporting dashboard thanks both of you. Tag: SQL Restore Rights
- 1
- Previous
Re: SQL Restore Rights
Michael Hotek
This is the way the security infrastructure was designed. Even if someone has the ability to run a system stored procedure or extended stored procedure (which is what is used to populate the GUI in Management Studio), they will only see the Windows resources which their account has the authority to see in the first place. They can see the directories and files when you add them to the sysadmin group, because the sysadmin group's Windows authoirty is mapped to the Windows security credentials of the SQL Server service account which therefore allows them to then see any Windows resources which the SQL Server service account has access to.
What you should do is grant then CREATE DATABASE permission along with adding a SQL Server credential which has the authority to view the directory which the files are being uploaded to. Then map the credential to the user's login. The following BOL article will help. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/81c632cc-9d6c-486f-8590-4819517e6006.htm
Re: SQL Restore Rights
Brad Roland
Hi Mike,
Thanks for the quick response on that. I'll take a look at that BOL and see what I can come up with. Again, thanks for the quick help
Brad
Hi Mike,
Thanks for the quick response on that. I'll take a look at that BOL and see what I can come up with. Again, thanks for the quick help
Brad
Re: SQL Restore Rights
Brad Roland
Hi Mike,
That looks to be exactly what I needed but I'm having a bit of an issue. On the Login Properties - General page, I can't seem to see anything labeled Credentials. I see the main username at the top, but no where that I can specify the credentials that I created. I tried using the ALTER USER command and it appeared to have worked, although I'm still in the same situation of not being able to see the backup location. Do you or anyone else reading this know how I can view the SQL login properties so that I can see if the credentials have been associated with that SQL account And why am I missing the credentials section in the properties in the first place! Thanks for all the help
Brad
Hi Mike,
That looks to be exactly what I needed but I'm having a bit of an issue. On the Login Properties - General page, I can't seem to see anything labeled Credentials. I see the main username at the top, but no where that I can specify the credentials that I created. I tried using the ALTER USER command and it appeared to have worked, although I'm still in the same situation of not being able to see the backup location. Do you or anyone else reading this know how I can view the SQL login properties so that I can see if the credentials have been associated with that SQL account And why am I missing the credentials section in the properties in the first place!
Thanks for all the helpBrad
Re: SQL Restore Rights
Brad Roland
When I tried to delete the created credentials, it gave me an error that they were in use, so I'm guess that is working, but I still can't see any of the backup locations. Does anyone have anything else that I can try Thanks!
Brad
When I tried to delete the created credentials, it gave me an error that they were in use, so I'm guess that is working, but I still can't see any of the backup locations. Does anyone have anything else that I can try Thanks!
Brad