Can't Save And Access Images In External Folder From Remote Location
Jun 9, 2014
I have developed on winodws based application using C# in .NET. I am connecting from my database using internet, means my database kept on remote location. I have to save images in DB because I can't save and access images in external folder from remote location. In this situation my DB is growing very fast. Is there any other alternative to work on this requirement or compress image in any format so that I can reduce DB size.
View 1 Replies
ADVERTISEMENT
Jan 20, 2015
SQL Server 2012 running under a domain Managed Service Account. (Server A)
File located on a Windows 2012 server in a directory which has been shared to user A. (Server B).
User A is a domain account and is using his laptop, (laptop C) which is using SSMS to run a bulk insert command.
User A (Bulk Insert from laptop SSMS Client) --- > SQL Server (server A) --- > File Server (Server B)
The command fails and is returning Access denied to the file/folder share on Server B.
Running the same command on the SQL Server (Server A), the command works fine, so this is a double hop kerberos issue.
If I use a SQL Login from Laptop C, then the command works fine as the SQL Server will use the SQL's Managed service account to connect to the file share, which is set up for delegation and impersonation.
I am struggling to work out why a domain user cannot bulk insert a file from a remote location. I have checked that the user is connected with Kerberos authentication and they are. All articles seem to talk about setting up SPN's for the SQL Server so that SQL Login authentication can work over remote bulk insert, and just say to set up the file share properties properly if using a domain account.
What I am missing to allow domain accounts to bulk insert remotely, from a remote file share?
View 2 Replies
View Related
Sep 19, 2007
I dont alot about sql server 2005(Express edition). For debugging purposes i want to copy the whole app_data folder(.mdf & .log files) on the production server to another folder on the same machine(or sometimes to a network folder). So when i copy and try to paste this App_data folder to a new location, i get this error message
"cannot copy ASPNETDB: it is being used by another person or program. close any programs that might be using the file and try again."
After reading the above message, i close visual web developer, stop the website in IIS and stop the SQLExpress service on the server and try again but still get the same message.
So how can i make sure that all the programs accessing these database files are closed such that i'm able able to copy them to a different location.
View 2 Replies
View Related
Sep 9, 2015
I have a package that need to copy a file from a remote server using path like  ipaddresssharedfolder..now, inside of Microsoft data tools, everything runs fine, because y access to those folders on the windows sessions and enter my credentials. however how to I set up the package to use my credentials on the remote server? Â
Without it, I got error Executed as user: NT ServiceSQLAgent$RETAIL_PRO.and this user does not exists on remote server. so got access denied. error.Â
View 4 Replies
View Related
Aug 12, 2015
I have to access the remote system folder files in local machine using SSIS.
View 2 Replies
View Related
Aug 16, 2007
Hi!
I've got a real problem with inserting images into report. The problem is that I work with Reporting Services and SharePoint Portal. My employer wants to have CV created dynamically. Information for CV is taken from database under special account with read-only access. And photos of employees can be found with URL
http://corporate-site/Resources/Team/Name_surname.jpg (this string is also generated dynamically). When I preview report on my local machine, everything is Ok, I can see the images. But when deployed the images are not displayed. I have created an Unattended Report Processing Account to get photos. But if I want to use it I must change account for reading data from Data Source (in my case it is SharePointDB.rds) for €œCredentials are not required€?. And after it I can't get the information for CV.
Does someone know how to use one account for database and another one for getting external image? Or maybe there is another solution for this problem?
Thanks.
Yuliya
View 1 Replies
View Related
Apr 25, 2007
Hello,
I tried to use an image from a url and got the error:
"[rsWarningFetchingExternalImages] Images with external URL references will not display if the report is published to a report server without an UnattendedExecutionAccount or the target image(s) are not enabled for anonymous access."
I found a link in the MSDN about that that explain how to configure the UnattendedExecutionAccount:
http://msdn2.microsoft.com/en-us/library/ms156302.aspx
But even after I configure it and use my user and password (I'm an admin) I still can't see the images.
Any ideas?
Thanks.
View 4 Replies
View Related
May 2, 2007
Server Software:
SQL Server 2000 (all sps up to date)
SSRS 2000 (all sps up to date)
We have an issue when emailing a report that contains external images.
When the email recipient receives the report the images appear broken.
Although when we check the report in the report server it displays correctly and all images are intact.
We also noticed that if we manually "export" the report to the MHTML format the images appear broken but if we immediately export the report again the images appear perfectly. (the report must be exported to MHTML twice in order to work. This has been verified and is repeateable)
It is almost as if the MHTML format cannot reference the images fast enough to include them in the report on the first try. But, it is able to do so on the second attempt...
We would rather use external images as we have 700+ reports and manually updating embedded images takes quite a while. Then we can update a single image to change all reports.
Any help would be appreciated.
Thank you.
View 1 Replies
View Related
Mar 12, 2008
how do i write a select query which will return all my data into an excel file or an xml file or txt file?
View 3 Replies
View Related
Dec 31, 2007
Hi
We are building a portal internal to our org. Here, For one of the option on the portal, we have given each user in our organization an option to upload three images. Iam storing these images in Sql server table columns with datatype image.So, the question is:
1. Is it ok to store the images in sqlserver? Will it add any performance degradation?
2. Is it ok to store the images in folder and store the respective urls in the DB?
Please let us know.
Thanks!
Santhosh
View 3 Replies
View Related
Feb 22, 2008
how can i execute an sql query(which is in test.sql) which is in an external folder, from my program??
View 1 Replies
View Related
Feb 29, 2008
I am trying to create a website that people can upload an image and have it saved to a database. Can someone point me in the right direction on this? What properties need to be saved in the db and how?
View 4 Replies
View Related
May 9, 2007
hi everyone,I'm currently developing a website and have a lot of images to use there(obviously :P), until now I have in some tables in my sql server db where exists a column which stores the path to: 'image folder + filename'And my question is: what are the advantages of using binary images in database instead of this approach to the problem, i.e., having images stored in a server folder.Thanks in advance.
View 2 Replies
View Related
Jul 10, 2007
How can i change the default folder to which my database files are saved? right now it's saving everything to
program filesmssql servermssql.1mssqldata
uggg! i can't even find an option to use a "save as" or export the mdf file. the "save as" tries to save the solution file. Any help is greatly appreciated.
View 3 Replies
View Related
Dec 8, 2014
I need to load images from folders into a SQL Server table and I have done it successfully for individual images, however I need to load all the names of the folders and sub folders names in separate columns + load all images.
So the folders look like as in the screenshot and the final result of the table in SQL Server should look like the second screenshot.
View 9 Replies
View Related
Jan 11, 2007
to utf8 format through BCP or throuhg the dos command prompt?
Cheers
View 3 Replies
View Related
Feb 27, 2007
Prior to SP2, when you clicked the save button it would take you to the root of Report Server. With SP2 (in old-style Report Manager mode, not Sharepoint integrated mode) it takes you to the /Models directory by default when you click save. Is there a way around this?
If I launch Report Builder via the following URL, it does fix the problem. But it doesn't let me pick table/matrix/chart. I would like to override the default save location AND be able to let the user pick table/matrix/chart:
http://localhost/reportserver/reportbuilder/reportbuilder.application?model=/Models/MyModel&savelocation=
Suggestions?
View 7 Replies
View Related
Oct 5, 2006
I have an SSIS package that I created that looks like the following:
Execute SQL Task [Determines the file name]
Data Flow Task
Source - Query [Grabs the data]
Destination [Saves data to file on network drive]
Send Mail Task [Tells user to get file from network]
When I run this package inside Microsoft
Visual Studio I get the results I want. It sends the file to the
network drive and because there are SSN's in the file, it doesn't
actually e-mail the file but puts it in a secure location for the
person to get the file.
When I schedule this in SQL Server 2005 I get the file saved to: c:windowssystem32dynamicfilename.csv
So somehow it is still able to determine what the file name should be, but instead of sending the file to the right destination when you run it through VS, it flops out and sends it to this wacky directory.
I've
spent too much time on this and was wondering if someone can point me
in the right direction without going to the extent of writing a script
like this suggests. thread1555-1265108
Thanks,
Keith
View 6 Replies
View Related
Mar 12, 2008
Hi, I have created a store procedure and want to save them. this is wha ti did.
I clicked on the Northwind--> Programm--> Stored Procedure-- > right clicked --> new stored procedure
after writing my stored procedure I saved it. But when I am saving I want to save it under the Stored Procedure folder
of the NorthWind database. I guess this is what it should do. When I use to use the sql 2000, i could always send my stored procedure here , i guess it was by default. But even if i save my sql stored procedure at any other location than at the run time, how the applicaiton will find my store procedure.
Well so thinking of that I have to save my stored procedure under the database for which table it is created however, i can not save it there. I tried to figure out the directly but I couldnt.
So any suggestion????
View 1 Replies
View Related
Aug 19, 2015
how do I copy a folder from an FTP location using the FTP task in SSIS. Currently, I can only move the files in the folder one after the other but I want to copy the folder at once.
View 3 Replies
View Related
Jan 16, 2007
Hello --
I'm building an app that will allow users to create their own photo galleries. At this point, I'm planning on storing all photos as byte arrays in SQL server image fields.
Besides the organizational benefit, is there a space benefit to doing this? That is, if I have 1MB of .jpg's, will those same images take up less than 1MB of file space within the database?
One of the reasons I ask is that most hosting plans out there seem to offer more "normal" disk space than is allocated for the database, so I'm trying to make a best plan to accommodate what will probably end up being the biggest disk space consumer in my app (the photos, that is).
Any other recommendations re: this scenario (hosting, best practices) are appreciated.
TIA,
Eric
View 8 Replies
View Related
Jun 10, 2015
I am using the below code in my command prompt and it is copying all the records from a particular table and dropping in Flat file format in particular folder location. The below code is working if I am pointing to my local database but if I need to point to different database outside my environment how should I set it here also including the case where User ID and password are required to access the db.bcp AdventureWorks.HumanResources.Department out C:myDepartment_c_t.txt -c -t, -r -T -S.
View 12 Replies
View Related
Jun 8, 2015
I have a requirement where I have to take all the data available from a sql table and write it out as a flat file in folder location.Its a simple table have 8-10 coloumns, have to take this data on daily basis from sql table and deliver out as flat file in a folder.
View 19 Replies
View Related
Dec 2, 2013
is there a way to change SSMS 2012 default query save location?
Scenario:
1. Open SSMS
2. Create new query
3. Click Save
I see "DocumentsSQL Server Management Studio" folder, but I want to change it to be "d:". How do I do this?
I tried:
1. [URL]- in folder "DocumentsSQL Server Management StudioSettingsSQL Server Management Studio" there is a file NewSettings.vssettings, setting it to "d:" or "d:" didn't work.
2. Changing HKEY_CURRENT_USERSoftwareMicrosoftMicrosoft SQL Server100ToolsShell VisualStudioProjectsLocation didn't work too. There is no "Shell" under "110Tools"
Did I do something wrong, or is there another way?
View 6 Replies
View Related
Jan 15, 2006
I have my SQL Server installation on drive c: and the databases on anotherdrive. My c drive got corrupted and I am planning to restore it from an oldbackup. This means drive c will not be up to date.Is there anything that SQL Server saves in the registry or in its homefolder that changes frequently? I am hoping that nothing does which meansthe old backup will be good enough.Although I think the default databases are in the c drive, I will try toget them back from a recent backup.John Dalberg
View 1 Replies
View Related
Jun 4, 2015
I have Developed ETL Package Which Supplying the CSV File, if I run the package Next time if Same File name  is there I need to Rename the that File with Currentdatetime need to move in to Archive Folder. if that File is not exist in that location no need to move the file into Archive file.
View 4 Replies
View Related
Apr 28, 2015
Basically i have 3 images capacity per record in my asp.net application. In there i am saving the image path with record id in database and image in my application folder.
Now i am creating SSRS Report in Report builder . In there i have taken one image control to show the images. In the Image properties in report builder i have chosen database under the select the image source field. then inside use this field i have chosen image url and in use this MIME Type i have selected image/jpeg. Now i have saved this report in report server folder.
Now while calling in .net web from through report viewer control. It is opening the report but wont showing the image.
View 2 Replies
View Related
Sep 17, 2015
When I go to Save As Report it doesn't allow me to create a new directory (folder)
Here is where the directory (folder) needs to be created: gdgdb01preportserverProduction.
Where can I create this directory (folder)?
View 4 Replies
View Related
Jul 15, 2015
We have the following requirement :
1. In daily basis auto loop through each item in the invoice table.
2. passing invoice number into a Summary SSRS report as parameter.
3. Auto download ALL generated PDF reports into a window folder with a special file name format i.e. <INVOICE_NO>_<DATE>.pdf
how to achieve this via SSRS, Store Procedure or Power Shell?
View 4 Replies
View Related
Oct 13, 1998
We have one development server and another production server. I am trying to restore a production dat file to the development server. I can get as far as adding the path name of the remote file (e.g. serverd$directoryfilename), but I can`t seem to enable the "Restore Now" button. The file actually displays in the Devices and Files section, but when I click it, nothing happens.
There happens to be another pre-existing device that does respond to my click - the device is added to the "Backup Information" section of the screen, and the Restore Now button is enabled - but that isn`t really the one I want to restore from.
Is there a step I`m missing?
Thanks in advance,
Lisa
View 1 Replies
View Related
May 26, 2015
I have table which consists of images. I am trying to export those images to a folder.
declare @path varchar(100)= 'c:images'
SELECT [PICTURE]
,@path+[PICTURE] AS Path
FROM [A].[dbo].[PICTURE]
I am getting this error: The data types varchar and varbinary(max) are incompatible in the add operator.
View 1 Replies
View Related
Dec 20, 2007
Please can anybody help me in transferring existing SSIS Packages saved in a shared folder location from development server 2ED to Live server TWD1.
Both has SQL server 2005 running and has visual studio 2005
Currently about 25 SSIS packages are executed from the development server transferring data on Live server TWD1...these ETL process is called from development server but executed on live server.
Now the problem is when i call these packages from the shared folder from live server it crashes.....i need to changes something to shift the whole package to the live server..and execute on live server itself instead of recreating the whole 25 process from scratch.....also i use optimize for many tables ..and run in a single trancastion....so how can i see the mappings of source and destination tables.
Please let me know the process how i can achieve this.
Thanks
George
View 5 Replies
View Related
Aug 29, 2015
there are several remote locations where sql is running, my company has asked me to find a way to collect all the data from the remote locations to a central location automatically,for example day to day data should be synced at night time from 2am to 7 am and it should be compressed automatically before data transfers to the central location. NOTE there is no domain only standalone workstations
View 3 Replies
View Related