Using Encryption Via An Asp Site. How Is It Done
Feb 18, 2007
ive been playing around with encryption, just encrypting a column with a symmetric key, and having that symmetric key encrypted with a cert, and all that , and it works well through the SSMS, but i want to know how that will be used if im using sql server as a back end database for an asp web site, or an application. does the sql server have to be protected with an SSL cert, and once a user has logged in, what would the steps be to view encrypted data?
View 6 Replies
ADVERTISEMENT
Oct 7, 2015
I have created two user defined functions for encryption and decryption using passphrase mechanism. When I call encryption function, each time I am getting the different values for the same input. While I searching a particular value, it takes long time to retrieve due to calling decryption function for each row.
best way to encrypt and decrypt using user defined functions.Below is the query which is taking long time.
SELECT ID FROM table WITH (NOLOCK)
WHERE dbo.DecodeFunction(column) = 'value'
When I try to use symetric or asymetric encryption, I am not able to put "OPEN SYMETRIC KEY" code in a function. So, I am using PassPhrase mechanism.
View 3 Replies
View Related
Jan 31, 2007
I have a website with membership system. I've been through a lot implementing the site and I think I'm on the verge of full implementation. I can't get my registration page or my admin page to add, edit or delete users. I'm assuming that asp does not have proper permissions on SQL to do such.
I'm running the site on a provider that has a SQL 2000 server. I access the database through VS2005 and SQL Server Management Studio Express.
Is there a tutorial out there that could help a newbie to SQL understand how to check and correct my permissions issue (or find out that I'm haveing a different issue entirely.
-Bill
View 3 Replies
View Related
May 26, 2008
Hi all,
I`m a .NET desktop-app developer and i`m new to ASP.NET and web development, i start developping a web application with SQL Server database and i want to know if i can put all my tables in ASPNETDB?
is any restriction with that?
Regards
View 3 Replies
View Related
Feb 3, 1999
Hello,
This may be the wrong place to add this but....
I am attempting to setup a membership instance for Site Server 3.0 using SQL 7 and try as I might, Site Server Membership will not see the server at all. I can do anything else I want to to that server and it works great (commerce, etc.). It all works OK under SQL 6.5 SP3 or later, just not SQL 7.
Does anyone have any thoughts or insights?
Thanks
John
View 1 Replies
View Related
Oct 6, 2003
I have to download a file from a ftp site using either SQL/T-Sql or ActiveX script. I'm using SQL Server 2000. Please help
Thanks in advance
View 2 Replies
View Related
Oct 13, 2004
Is there a good back up software that willl back up by SQL server to a FTP site. All of them I have seen either backs up to a disk or tape.
Thanks
Jay
View 2 Replies
View Related
Nov 17, 2004
Poeple are calling me for resume 5 years old. They need DBA's all over the country. Please pass it on to look at the job opportunities on this site.
View 2 Replies
View Related
Jun 14, 2006
I am having problems deploying my web site from my machine to the hosting server.
Does any know of any special configurations that have to be perfomed before copying your web site to a server? All I have is a login in page that loads another page. The login page is launching okay but it does not load the second page.
View 2 Replies
View Related
Apr 11, 2007
Hello,
I am upgrading my site from a VPS with a shared SQL server to a dedicated server and my own sql server 2003 standard. My site is an ecommerce site with about 10,000 users a month with between 10-20 people on the site at one time.
It is better to host both my site and the SQL server on the same system or is it better to have them on separate systems? if they are on the same system is 1 gig of ram enough? is will there really be much better performance with 2 gigs?
Any information on the best way to do this would be greatly appreciated!!!
Best regards,
~ Moe
View 2 Replies
View Related
Dec 17, 2007
How can a genuine Web Outlook url be classified by filtering software as a known phishing web site?
Thanks.
View 1 Replies
View Related
May 15, 2008
Hi,
I am trying access a FTP site present from a different server (remote work station). I am getting "The page cannot be displayed" error. I am able to access from my local machine.
Please help me solving this.
Regards,
Sriram.
View 3 Replies
View Related
Feb 7, 2006
I want to backup my database to an ftp site. How can I do that with SQL Server 2005? Thanks.
View 1 Replies
View Related
Apr 23, 2008
Hello:
I have setup a Flat File connection manager and set the location of the file as such:
ftp://10.1.1.1/FileName.txt
When I enter this URL into Start | Run on my machine it opens the txt file fine. Working in BIDS, when I create the flat file connection manager, it doesn't give me a message saying this file does not exist, indicating it is correct. When I create a flat file Source that uses the connection manager, the preview comes up blank. When I try to execute the step it gives an error saying it "cannot open datafile ftp://10.1.1.1/FileName.txt"
Any idea what could be going on?
Thanks,
Kayda
View 5 Replies
View Related
Oct 16, 2006
I need to place some site settings in my Report Manger.But in my Report Manager there is no Site Settings Icon.Is this installation problem please help me.
View 3 Replies
View Related
Aug 24, 2006
Hi!
My problem is...i gut this errormessage in Web Site Administration Tool:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote)
I recieved it after i try'ed to change the default Providers and use another DB then default. Now i want to go back to how it was from start, if i create a user and role - i want VS 2005 to create a SQL Express DB for me. Can anyone help me? I have even tryed to reinstalled VS 2005 but it didn't help.
/Bamsen
View 1 Replies
View Related
Dec 21, 2006
how can I scale the full text search system on my web site?
View 1 Replies
View Related
Mar 8, 2007
hi alliam trying to build an asp.net webpart site, i donot want to use SQL Server Express for it, rathar than that i planned to use an sql server 2000 database , so far after doing this my pages is getting me this errorAn error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)where i surprise because i tell it in web.config to use my profile rathar than this default one, can any one tell me the secret behind thatRegards,
View 2 Replies
View Related
Mar 28, 2007
I am wondering how some of you update your database once it is already been in use. So take for example you have a few tables and users can enter data into the site. Now suppose you either add tables to the db or you add fields to an existing table. I am using sql express 2005 and just want to copy the db over with the copy website but it would overwrite any data users entered.Is there any easy solutions or suggestions for this.Thanks
View 1 Replies
View Related
Apr 17, 2007
I'm getting the following error:An error has occurred while establishing a connection
to the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified) Here's the setup: I have a website I've published on my server, but I haven't moved the SQL DB over to the server. For some reason the testing server can't connect with sql express on my computer. I have named pipes, tcp/ip both on, connections string is "Data Source=AMBA-176SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI"When I'm simply testing the site locally in visual studio it can connect just fine.
View 1 Replies
View Related
May 15, 2007
Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.
My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".
CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?
CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.
POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.
Color me "confused in Kauai" ... :) KevInKauai
View 2 Replies
View Related
May 20, 2007
Hello!
I'm interested in using the NEW security that 2.0 has. I had a table that has users, passwords stuff like that. But I wanted to try this new option. I ran "aspnet_regsql.exe" wizard, which updated the schema on my db. But when I go to Web site admin, and click on security tab, it states unable to connect to database. I have no database in my AppData folder. Do I need to just make my own connection with a data source, like I have done for everything elses, or is there a diffrent way?
Rudy
View 1 Replies
View Related
Jun 29, 2007
Hi:I have a site that is getting close to production. I am using SQL Server 2005 express and VWD express. Up to this point, I have been updating the live server by deleting the file and copying the MDF file from my development machine in its place. This clearly won't work once the site goes live - but I still expect to be doing a lot of upgrading of stored procedures etc. Can someone point me to a resource or make any suggestions that would help me in this regard?Thanks,Roger Swetnam
View 3 Replies
View Related
Jan 15, 2008
I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called "SiteData.mdf", I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.Login failed for user 'CENTAURUSASPNET'.
I also observed that inside the SQL Server Management Studio, in the database properties, it shows "ETHERASPNET" as User or Roles ( however "ETHERASPNET" was created using the old computer's name [ or should I say domain ? ]) but the permissions list correctly displays the new name "CENTAURUSASPNET".
I think that I, probably, should create a new user using the name "CENTAURUSASPNET" because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message "An object named ‘CENTAURUSASPNET' cannot be found".
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name "CENTAURUSASPNET" ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as "centaurus.SiteData.dbo" -while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as "SiteData" ?
View 2 Replies
View Related
Apr 2, 2008
hello
Iam building a big site for video ( like youtube )
and I want to store the video url in the database because as I know that is the best choice
but my friend advised me to store all the video in the database for more security
I know that will take alot of space in the database
but he said ask the proffesionals
please give me your opinion
thanks
View 3 Replies
View Related
Jun 23, 2005
Hello!
I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?
Thanks in advance!
View 2 Replies
View Related
Jul 25, 2000
I am new to the internet field. Can anybody help me in administering the SQL database on the site. Are there any tools so that I can administer the database on the site straight from my PC??? If there, please tell the URLs so that I can refer them. And please tell me other issues which are involved in administering the database on site.
How can I maintain a parellel SQL server database on my PC?? How can I take backup from my site to the SQL database which is placed in my PC?? I want to keep backup of my database in my PC.
Please help me in these issues.
Venkat Reddy
gv.reddy@usa.net
View 2 Replies
View Related
Oct 2, 2000
Hi,
can anyone tell me how exactly sql server7 interacts with Site Server, LDAP.
I am a sql dba, trying to work with above ones. Anyone pls suggest me any book or material or ur ideas.
Thanks!
--Siva
View 1 Replies
View Related
Apr 4, 2000
Is anyone using SQL server to navigate their public web site?
We are concerned about having a database hit every time the user chooses a different page from our navigation bar.
Any advice? Experience with this?
View 2 Replies
View Related
Jul 17, 1999
Greetings,
Could you guide me in the designing and drawing of the relative database
structure in SQL Server 6.5/7 for an Auction Site. I need information on appropriate ...
Tables-Records-Fields + SP's-Triggers etc etc for such an Auction Site as say www.ebay.com or
www.onsale.com etc.
Please Guide accordingly. Hoping to hear soon!
--ASHBeN (ashben@neuk.net)
w. http://ashben.cc.st
View 1 Replies
View Related
Mar 6, 2001
Hello everybody,
We have a web site with about 100 connections per hour.
This site is only for consultation : read only.
We implement ASP on IIS 4.0 and use as often as possible stored procedures with ADO objects on client side (ASP).
We close every objects after they are used.
The site works about 1 hour and then is stopped because inetinfo service is down.
The memory and the CPU on the SQL server machine are quiet at maximum.
'user connections' is to 0 (so 32767 enabled connections).
'locks' is to 0 (so it will give memory dynamically).
The machines are very powerfull : 2 X bi-processor P III 700 Mgz, 512 Mo RAM :
1 for the front-end, the other for the SQL Server.
We think that we can make it work with such a materials.
Thank you very much.
Laurent Diep.
View 2 Replies
View Related
Feb 14, 2007
OK, so im getting closer to producing my web site selling t shirts and stickers.
Ive also learnt a bit of SQL- through work.
How do I combine the 2 to enhance my site?
thanks
View 2 Replies
View Related
Dec 15, 2006
I have a DTS package that updates information in a database for one of our clients. This information then needs to be republished to the websites which is done by going to a URL
Example: http://webrepub.DomainName.com/apps/publish.cfm?temp=1&ID=1101.
Is there a way from within the DTS package to execute/call the URL that performs the republishing of the websites with out opening a browser on the server.
TIA
View 1 Replies
View Related
