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.
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?
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.
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.
Hi There,Being quite new to MS-SQL I would like to ask if there is a general opinionof what approach should be taken to storing things like external documentsand images in databases.Should the actual files be stored within the database, or instead shouldlinks to the files on a file server or something similar be stored instead.For the end user I imagine it is easier to have everything stored within thedatabase, because doing it the other way in effect gives another level ofmanagement because there is the need to perhaps manually look after the fileserver with all the image files or document files on.In my particular case, I am building a database where the users use a greatmany Word documents. For example, I particular record might have a number ofdifferent Word documents associated with it.I was going to create a "Documents" table that all documents were stored in(including meta data about each document because it will be really useful tobe able to search for documents so that they can be reused).In this table I was in a dilemma as to whether to actually store thedocuments in the table. Other then the performance hit and memoryrequirements this will require, are there any other disadvantages?What are the general thoughts when a database needs to manage a lot of pdfand word documents?Thanks in advance.Dave.
Hi I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005. Thanks for any help
I am having a problem with MMSQL BLOB with VB, Sorry to say I am new in Programming using VB 6 and MSSQL and I have never touch BLOB in my live.
I just wish anyone could give me any ideal, like, white pages, or manual on how do I insert BLOB data (Images) to MSSQL 2000 database using VB 6. I need to know exspecially the VB Code and the SQL Portion if you have a store procedure code for that it will be nice. :confused:
I have created an Access2003 project (existing data) that links to external data. First I connected to a SQL Server 2000 database. Success. Then I tried to set up a Transact SQL data connection to a legacy MDW-secured Access97 database. (A third-party VB6 application goes against it, and we don't have the source code, so we cannot upgrade it.)
The Transact SQL link tests OK but I cannot select any of the tables or queries from the list presented. However, with the same credentials, I can use these same objects in Excel 2003.
When setting up the link in Access2003, I specify JET 4.0 OLE DB Provider, I enter the MDW file on the All tab, a username and a password on the Connection tab where I browse to the MDB file, and specify Shared Deny None on the Advanced tab. When I test the connection, it tests OK ("Test connection succeeded"). Yet on the "Select the Database and Table/Cube which contains the data you want" dialog, "(Default)" appears in the grayed-out dropdown. Then, beneath that dropdown, there is a grid with Name and Description columns. The grid contains query names but the grid is not enabled. The list of queries is this table is grayed out. Neither of the scrollbars works.
BUT... if I use the SAME username and password in Excel2003, and specify the same MDW, there is no problem working with these same database objects in the legacy Access97 database. WHAT IS DIFFERENT ABOUT THE WIZARD IN EXCEL THAT ALLOWS IT TO SUCCEED AND THE WIZARD IN ACCESS THAT CAUSES IT TO FAIL HERE? In Excel, the list of available providers says Microsoft Access Driver, not JET 4.0 OLE DB Provider.
When trying to link to an SQL table in Access 2003, the software appears to be malfunctioning.
The sequence of events is File - Get External Data - Link Tables - Files of Type: ODBC Databases().
The Problem: On two of my computers, the select data source window does not pop up, preventing me from linking to any ODBC data source.
Observations: This function has worked normally in the recent past and works on other computers running Access 2003. One difference between the computers working and non-working computers is Norton Antivirus 2006 (recent upgrade).
Has anyone experienced anything like this? What's going on?
I'm trying to develop an application for a friend, who has his own server and SQL 2005 setup on it Is it possible to add a connection to an externally hosted SQL Database using VWD2008? I have a login and password for it, I just don't know where I set the IP address to connect to and the name of the DB etc...?Any help greatly appreciated.
hi,am working with my friend so we need to use the same DB ..how can i get him DB and insert it in mine to use it.i 've try to copy it and paste in C:Program FilesMicrosoft SQL ServerMSSQLData then try to connect it by New connection bt it doesn't workNote:am working n Web Matrix ProjectRegards,
have setup SQL 6.5 on a machine. I have verified that port 1433 is opened for SQL. I am also using a router dell 2300. I am running Windows XP. I have set up my machine to port forward and have setup a static ip 192.168.2.136 nothing I do seems to work.
but when I try to connect to the external IP 12.xxx.xxx.xxx I get the dreaded sql does not exist error.
I can register the server by external ip. When I try to start the server I get an (RPC server unavailable) error.
I can ping the external ip.
I can telnet 192.168.2.136 1433 without error
I can connect though security manager using 12.xxx.xx.xx
I can't telnet 12.xxx.xx.xx.
I think its router but I do not know what I'm missing. I have static ip 192.68.136 set up.
Router Port Forward Settings
Service Enabled In Port Dest Addy Dest Port Type MSSQLSER Y 1433-1434 192.168.2.136 1433-1433 TCP MSSQLSER Y 1434-1434 192.168.2.136 1434-1434 UDP
I have also read that some ISP's block port 1433 due to the worm problem. So I changed the listining port from 1433 to 1971. I am still able to connect using this new port with local ip or local name. I still cannot connect to external IP. (I did change router setting to reflect new port forward to 1971)
I am not sure what I missing. Thanks in advance for any help
Hello,I want to access my database server from the internet. I've created a ruleon my router to redirect port 1433 to the desired machine, but still get aServer does not exist, or access denied message. When I change the(external) ip to the local IP address, connection succeeds. Is thereanything i need to change within SQL Server to allow external (internet)access?
I am looking for some guidance on the following CE based project. The project would mean placing a program on multiple appliances (either PDA mrtphone) which would then periodically connect onto a SQL 2005 server and both read and right to a table on the server. This would mean multiple connections to the server.
I have read various articles which discuss the use of SQL_ce to achieve this but SQL_ce is a single user application. Is it possible to achieve this objective by publishing a share of the SQL 2005 database tables to an internet share folder to allow multiple external connections? Also if it is possible can I test the application on a windows XP platform?
I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?
Hello,First, I tried to find the answet to this question, but no luck - so I decided to post it. When I was creating my applications in asp.net - for the first time I decided to start using external DataSets. I think they are great and work very nice!But once I pushed the application to GoDaddy, I got an error of this nature:I was trying to access the exterbal dataSet like this:Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter() Dim products as Northwind.ProductsDataTable...And got an error saying that it couldn't find this type (but it worked fine on my local machine in visual studio).So did I miss something that prevented this application working on GoDaddy? or there are some limitations on GoDaddy? ...or something else.Thank you for looking into this for me.Valera
How can I read one external file (*.txt,*.csv) through stored procedure in MS Sql Server 2000 ?
On the database Interbase its very simple :
[CREATE TABLE table [EXTERNAL [FILE] ’ <filespec>’] ( <col_def> [, <col_def> | <tconstraint> …]); EXTERNAL [FILE]“<filespec> ” Declares that data for the table under creation resides in a table or file outside the database; <filespec> is the complete file specification of the external file or table]
Hi, I have been developing an app using SQL Server 2000 and am ready to transfer to a server located offsite. How can I connect to this server through enterprise manager or anything else so that I can use the copydatabase wizard to move it to the live server?
I have a problem with my MS SQL Server 2000 (SP2). My task is to restore a backup from a database on another computer.
The server makes a backup everyday. If this server gets a hardware problem there must be a chance to replace it by another server which is made by the backup files.
In this scenario I don't have the possibility to copy the whole folder of the old server.
Is it possible to restore the bakup so that the new server looks like the old one?
Is there a stored proc or a function I can call from Query Analyzer to execute another .EXE and return when it's finished?
I'd like something like SET @RET = sp_CallEXE('c:mypathmyprogram.exe myparameters')
(Except for the name of the function, there should be something that does this right? I mean, DTS does it already so it must be referring to a function or a SP.)
I want an answer to so that I can validate that everything went well (hence the @RET variable)
Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem...
I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy!? Well not for me ..
This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied
I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight off no changes...
After some investigating I have found a few threads about advice but still cannot get it to connect to the external SQL DB (BTW I can connect to a SQL DB on my server its just externally)... This is what I have done / Checked so far..
1. I have changed the connection string to include the port number 1433 (Provider=sqloledb;Data Source=THEIPADDRESS,1433;Initial Catalog=DB;User ID=xxxxx;Password=xxxx;)
2. I can ping the IP address of the external SQL Server with no problems
3. On my server I have enabled TCP/IP in SQLExpress & added sqlservr.exe as an exception in the Firewall
4. I have even tried turning the Firewall off completely while I tried to connect - But still nothing.
If anyone can help me I would be very appreciated.... I am starting to tear my hair out as I can't think what else I need to do???
Hi, I have two servers, namely ServerA and ServerB. These two servers are on the same subnet. ServerB has a database called DatabaseB. I'm logged in in ServerA and trying to pull data from DatabaseB.
This is the query I do when I'm logged in in ServerB (note im using Microsoft SQL Server Management Studio):
USE DatabaseB
SELECT distinct b.Subject FROM dbo.F_Class_Exam a LEFT OUTER JOIN dbo.D_Course_Catalog b ON a.Course_ID = b.Course_ID WHERE a.Term = '2071' AND a.Class_Exam_Type = 'FIN' AND b.Term = '2071' ORDER BY b.Subject
How would I do this same query on ServerA? Ideas? Thoughts?
I am getting the error Unable to open the physical file "E:Navision SqlDataForentaSQL_Data.mdf". Operating system error 5: "5(Access is denied.)". when I try to "attach" to a database located on an external hd. The database files on the external HD were copied from the original server location to the external HD. The file size is 51G+ which is why it is on the external HD. Can anyone provide me the syntax to do the sp_attach taht will allow me to send the necessary connection string: server, user, pswd etc.
I am trying to print a PDF via a stored procedure in SQL Server 2005 using c#
I first wrote a stand alone version which works perfectly however after porting it into SQL server the program no longer works
Went back to basics and just tried to open notepad from standalone and from within CLR - again works until I put code into SQL Server DB
Trouble is that it seems to run ok - prints lines to console etc... but the notepad application doesnt start up - there are no errors so really struggling to find out why this might be
Anyone have any ideas, had similar issues?? - Only thing I can think of is a permissions/credentials issue of some kind but again dont have any errors???
I have created the dll file and assembly successfully (using unsafe mode)
Thanks in advance
Code sample below:
.
.
.
executable = "notepad.exe";
ProcessStartInfo starter = new ProcessStartInfo(executable, null);
Hi, here is my problem: Because of some usability terms, I need to use SSRS scheduler to determine reports creation frequency (minimum frequency is once a day)I need to use an external scheduler to SSRS in order to launch reports creation daily, after some other batch tasks execution that must be completed before launching report creation. And I have no idea on how to do that properly. Can somebody help me?
Is possibile configure as expression the properties XMLData and XMLdataDefinition of a "XML Source"? looking the editors it seems it is not possibile... I think it is a great limit of the component because I must hardcode the path!
Regards,
M.rkino
-- Marco Barzaghi - [MVP - MCP] http://mvp.support.microsoft.com - http://italy.mvps.org UGIDotNet - User Group Italiano .NET, http://www.ugidotnet.org Read my WebLog: http://blogs.ugidotnet.org/markino
I'm not sure whether this is right section to post this. It seems the most relevant one to me. (Please point me in the right direction if it is not).
I am a programmer/web developer for a medium sized organisation in the financial industry (in Australia). Obviously being in the finance industry, we have very strict guidelines and access when it comes to security. We are currently in the process of converting our website to use a SQL Server database (instead of MS Access which we have been using for years). In the past, we have accessed our web database via SFTP as it was only an Access file. Now that we are converting to SQL Server, we will still need access to our database (which is on a server hosted externally). It seems a bit silly (and even bizarre) to me to consider trying to access a SQL Server database via SFTP (as that, to me, defeats the purpose of some of its security features), but is it even possible?
My security guys here will only allow me to access the external server that hosts our website/database via SFTP (on a machine that is outside our network, so any files that I wish to update on our website I need to copy over via USB or whatever). If I am not able to get into the SQL Server administrator program to change our database via SFTP, is there someway that I can "drop" a changed copy of our database into a directory somewhere that SQL Server can "pick up"?
Hi All, I am doing some research about External Linked Servers and am hoping that someone can point me towards some best practices information and let me know about any gotchas that I should look out for when using this capability in applications. Thanks in advance,
