.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Remote Blob Storage - does SQL Server do all the work?

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
 
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t


View Complete Post


More Related Resource Links

Remote Blob Storage - does SQL Server do all the work?

  
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t

Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,


I really do not know the reason, how much ever i tried; I am NOT getting message in "rbs_install_log.txt" like; “Product: SQL Remote Blob Storage -- Installation completed successfully.”


I can see Several tables residing under the content database with names that are preceded by the letters "mssqlrbs".

In Object Explorer, right-clicking  <DatabaseServer>, and then clicking Properties; In the Server Properties dialog box, clicking Advanced, clearly shows that the FilestreamAccess Level is set to Full access enabled

Right-clicking  the content database name, and then clicking Properties,
when I check the Database Properties dialog box by clicking Filegroups,
I see that,  in the Filestream list, RBSFilestreamProvider appears. Even under Files, in the Database files list, RBSFilestreamFile appears

------------------------------------------------------------------------------------------------

use [ContentDbName]







if not exists 

Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,

Hi

Based on many blog posts / articles on Remote BLOB Storage with FileStream Provider,  I could easily do for one Web-Application. It is working fine too. But my Issue is, I have 3 Web-Applications in turn 3 Content Databases. Out of three, anyway 1st one went smooth since I followed all the steps. For the next two Content Databases, I am facing Issues like; When I tried;

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroup RBSFilestreamProvider

It is giving;

Msg 5520, Level 16, State 2, Line 1
FILESTREAM file 'RBSFilestreamFile' cannot be added because its destination filegroup cannot have more than one file.

If I try with another Folder for example; c:\Blobstore_2ndWebApp

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore_2ndWebApp') to filegroup RBSFilestreamProvider

I get Command(s) completed successfully.

But when I run below piece of code with my values;


msiexec /qn /i

Does HP storage pooling and/or EMC virtual provisioning technology work well for SQL Server?

  

We are looking to implement a new SAN, either an EMC CX400 or an HP EVA 6400.  In either case we are considering a storage pool technology.  EMC calls it virtual provisioning and I believe HP calls it storage pooling.  Essentially you have one or two large pools of drives and from there your SQL Server installations are presented logical chunks of disk.  It's even possible to have multiple arrays on the same drives.  In HPs proposal we will have a pool of (58) 146GB drives.  We can then present them to SQL Server as one drive letter or multiple drive letters. 

We are still trying to understand how this technology works.  It clashes with the old practice of keeping your logs, data and tempdb on separate arrays in order to minimize seek time.

We would love to hear from people who are using this technology.  How well does it work for you?  How big is your storage pool and did you carve it up into logical drive letters?  Do you still use Perfmon to monitor disk performance?  What problems does this present?

Thanks,   Dave


SQL Server Remote Access not work with Live IP Address

  

I have one server which has OS Windows 2003 Server I have installed SQL Server 2005 Express Edition in that I have connect my Internet with this pc directly with Live ID.

 

But when i try to connect SQL server from internet it give me bellow mention error.

 

TITLE: Connect to Server
------------------------------

Cannot connect to xxx.xxx.xxx.xxx\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

What is the Mistake with 2nd One ? Installing & configuring Remote BLOB Storage (RBS) with the FILES

  

 

Hi anybody,

I am trying to Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2010)

When I install and Configure for 1st Content Database, things are really fine. Whereas for 2nd time, It is failing; Failing in the sense, nothing happens when I execute below code, EXCEPT for GETTING ONE MSIEXEC WINDOW!!

msiexec /qn

/i RBS_X64.msi

REMOTEBLOBENABLE=1

FILESTREAMPROVIDERENABLE=1

DBNAME=”Content_Database_2”

DBINSTANCE=”LOCALHOST”

Web Deployment with IIS settings of remote server

  

Im trying to deploy a web application project (VS 2010) via team build (TFS 2010), i got to use IIS settings of development server for deployment. So from the project properties I configured the web projects to use Custom web server, (enabled radio button), once i do this the Option in the tab Package/Publish Web "Include all IIS Settings as configured in IIS manager" gets disabled and as a result the deployed web project does not have this IIS settings.

What am I missing here, Im not using the option "Use local IIS Web Server" because the build happens in a build server and would try to take local IIS settings for packaging which is not present.

If this is not possible, suggest me any workaround. Any help on this is greatly appreciated.


Using Remote Data Access with SQL Server CE 2.0

  
Microsoft SQL Server CE edition is the database server built by Microsoft to run on mobile devices. Besides being a standalone database for mobile applications, SQL Server CE also allows you to connect to your desktop SQL Server 2000 and perform remote data access and merge replication. In this article, you will learn how to build a .NET Compact Framework mobile application using Visual Studio .NET 2003 and how it can perform remote data access using SQL Server CE 2.0.

For more information on .NET Compact Framework, see my previous article, "Developing Pocket PC Apps with SQL Server CE."
Features of SQL Server CE 2.0

Figure 1 shows the main components in SQL Server CE and its relationship to SQL Server 2000 (on the desktop).

need help about "Unable to connect to remote server." using HttpWebRequest

  


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

AsyncPostBackTrigger doesn't work on server..

  

Hi, 
 I am new to asp.net and ajax. I have a problem while using update panel.
I have a tabcontainer with 3-4 tab panels. Inside one tab panel there is a cancel button. What i want to do is to when i hit cancel button in code behind i change active tab index to 0 so that tabcontainer shows first tab panel. I have update panel around tab container. This works at my localhost. But on server its behavior is very random. Sometimes it works sometime it doesn't. Unfortunately I am not able to debug it also. I don't know how to debug code on server. As on localhost it works correctly so I am kind of stuck. 

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

  
Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

The remote server returned an error: (405) Method Not Allowed.

  

Error:

{System.Net.WebException: The remote server returned an error: (405) Method Not Allowed.
   at System.Net.WebClient.UploadFile(Uri address, String method, String fileName)
   at System.Net.WebClient.UploadFile(Uri address, String fileName)
   at System.Net.WebClient.UploadFile(String address, String fileName)
   at Test.Page_Load(Object sender, EventArgs e) in c:\Inetpub\wwwroot\WebSite1\Test.aspx.cs:line 35}

Windows application, automated process will run on local user system...
trying to upload a file to website folder. website address: http://1.1.1.1/test/files

System.Net.WebClient wc = new WebClient();
wc.UploadFile(website address, "c:/1.pdf");

Getting error from above line.. Am doing something wrong??
I dont want to use ftp or share folder logic..
is there any other way to upload the files to server??


Accessing file on remote server

  

Hi,      
       I need help to achieve the following.
 
       I have integrated the Single Sign On to my webapplication. Service Provider(SP) is developing in .net platform and windows server.Identity Provider (IdP) is configured in apache and linux server.
 
       For authentication I am redirecting the user to IdP and authenticate at IdP and return back to my .net website. So I have user's database in IdP as a db file user.db (see the apache configuration below) for authenticating user.
 
          <Location /idp/Authn/RemoteUser>
               AuthType Basic
       &

Proxy failed to create remote object on the server

  
Hi, I am using .net remoting for inter-process communication between two processes on the same machine 1.   The first process is one of the Office application: Ecxel /   Word /   PP 2.   The other process is another application that interacts with one of the above. For that it needs office application object. For example: Excel The solution is comprised with 3 projects: Project #1: The remote object is a simple Called RemoteOfficeApplication – that simply wraps the required application object (Word / Excel / PP).   Project #2: The Server is a simple Office add-in, written with a Visual Studio Extensibility -> Shared project. This add-in is instantiated whenever Excel is lunched. This project reference project #1. Code: var channel = new TcpChannel (5003); ChannelServices.RegisterChannel(channel,true ); RemotingConfiguration.RegisterWellKnownServiceType( typeof (RemoteOfficeApplication.RemoteOfficeApplication ), “AppObj”, WellKnownObjectMode .Singleton);   Project #3: The Client is the process that requires the application object. This project also reference project #1. Code:   //Get Remote object proxy object remoteAppObject = Activator.GetObject(typeof(RemoteOfficeApplication.RemoteOfficeApplication), “tcp://localhost:5003/AppObj" ); //Cast the proxy var r

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

  
Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

Remote access to SQL-Server 2008 R2 on Windows Server 2008 denied

  
Hello, after successful installation of SQLServer 2008 R2 and providing my account as a 'sysadmin' I failed to access the server from a management studio of a SQL-Server 2005 release installation. The TCP/IP access is enabled and the server is configured to allow access from remote connections.  The error message reads a follows: ' A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify ... (Provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error:2)' Accessing the SQL-Server by the management studio from the local host works fine but trying to acces by command line using the '-E' parameter fails. Is there any additional configuration on the operation system level needed to open a SQL-Server 2008 instance to be selected by other members of  domain groups from the non-local host? Thank you for the answer  

Server-side validation on an Entity Framework required field (property) does not work!

  
Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend