SQL 2005 In Hosting Environment
May 2, 2007
Hello,
I want to offer a SQL 2005 server in back-end configuration for my hosting clients. Basically this means that they administer the DB with a webbased tool and the DB server it self is configured in the backend and has no direct connect to the internet. The DBs can only be access from the frontend web server.
- What security considerations should I take to use this server in a public hosting environment?
- We only allow webbased administration, no direct connect to the server are allow and possible.
- Multiple databases will exist on the same server from different customers.
I really would like to have as many information as possible. There is not much usefull information available on the web or in the books I own about SQL.
The question should actually be: what do you want to prevent from happing on your servers by authenticated users and ofcourse unwanted users. And how to do this.
View 6 Replies
ADVERTISEMENT
Jul 9, 2006
I must be missing something, and its starting to fusterate me. Bear with me here.
I created a site for a ...client I guess you'd call it, and made this really slick newletter generator thing. The people from the web enter in their info, and if they want, they sign up for a newsletter -- all tied into a db, 1 table, 4 stored procedures, REALLY simple stuff. They insisted I used a certain webhost which, on paper, looks like it will fit the bill. I'm starting to question that.
On top of the newsletter thing, I created an aspnetdb for the "administration" side of it for her to log into and send out the newsletter so total, there's 2 dbs in the app_data folder. Locally, it works GREAT and on my test box (iis6) that is running 2k5 express. The webhost runs sql2k in (what I consider) a bastardized way. Can't use the management studio, can't use anything except a really weak web-based interface which adds to my fusteration.
Anyway, my questions : 1, is there a way to make the mdf files work with sql2k without having to re-do the whole thing and 2, if I have to redo it, does anyone have an example connection string that might help out?
View 1 Replies
View Related
May 1, 2006
All--
Please help.
I have deployed my site to my shared host and I am getting the following RTE...
An attempt to attach an auto-named database for file... ..App_DataCommerceDB.mdf failed
...and I cannot find the issue.
Note that I have given Full-Permissions on root folder for the IUSR account and for the ASPNET account.
The full error message is below.
Anyway, do you have an suggestions?
My web hosting provider has advertised that they do support SQL Express 2005. What exactly do I need to ask them to do in order to get this working?
Please advise.
Thank you.
--Mark Kamoski
Server Error in '/mkamoski/S16' Application. --------------------------------------------------------------------------------
An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
Line 88: ''' <returns></returns>
Line 89: Public Shared Function GetCart() As ShoppingCart
Line 90: Dim rdr As IDataReader = ShoppingCartProvider.Instance.CartGetCurrentCart(GetUserName())
Line 91: Dim cart As ShoppingCart = New ShoppingCart()
Line 92: cart.Load(rdr)
Source File: c:hostingwebhost4lifemembermkamoskiS16App_CodeBLLShoppingCartManager.vb Line: 90
View 5 Replies
View Related
Aug 11, 2006
I am new to database.
I have a website in a hosting environment and it uses sql server 2005 databases. I want to have a complete backup of my database in addition to the hosting company's routine backup. I want to write a program to automatically backup everything every night. And of couse have the ability to restored the whole database if necessary.
How should I do it? Are there any tools exist that I can use? What is the best way to deal with backup/restore in hosting environment?
Thanks!
View 1 Replies
View Related
Apr 4, 2008
hi,I was redirect to this URL* based on Deploying a SQL Database to a Remote Hosting Environment,pertaining to my question on how do I convert MDF file to .SQL.I had downloaded and installed the program recommended that is Database Publishing Wizard.but the problem is now, there isn't any context menu "Publish to Provider" * when i right click on thedatabase aspnetdb.mdf..please advice me. thanks.* Reference : http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
View 4 Replies
View Related
Nov 3, 2007
I have a SQL .bak generated by our existing hosting package at 1and1.com, I want to import that SQL .bak to our new hosting package at ixwebhosting.com.
ixwebhosting.com don't have a import feature in their control panel.
I have to maintain the SQL at ixwebhosting.com using Microsoft SQL Server Management Studio Express since they don't have that feature in their cp. I don't see any import features in Microsoft SQL Server Management Studio Express either.
How can I import it using Microsoft SQL Server Management Studio Express or another free GUI program?
View 4 Replies
View Related
Apr 9, 2006
Can I use database that i develop in SQL Server 2005 in hosting company that has SQL server 2000 installed?
Thanks guys !!
View 1 Replies
View Related
Jan 27, 2008
I have developed asp .net wbsite with SQL Server 2005 Express Edition and Crystal reporting. I want to know that whether i can deploy my website with SQL Server 2005 Express Edition? If yes, Please say SQL Server 2005 Express Edition is a local database version like MS Access or server database version. And also give me name of website or server name on which i can host my website.
View 6 Replies
View Related
Jul 31, 2006
I am trying to use the new Common Language Runtime (CLR) hosting feature to write stored procedures in C# i have addedMicrosfot.sqlserevr.server name spaceand ia m trying to use sqlContext Object as below
using (SqlConnection connection = new SqlConnection(dbConn)) { connection.Open(); SqlCommand sqlcmd = new SqlCommand("select @@ version", connection); SqlContext.Pipe.ExecuteAndSend(sqlcmd); }
i get the below error when i execute (SqlContext.Pipe.ExecuteAndSend(sqlcmd);)
System.InvalidOperationException was unhandled by user code Message="The requested operation requires a SqlClr context, which is only available when running in the Sql Server process." Source="System.Data"
i checked if (SqlContext.IsAvailable) and it returns false as well.
Please le me know how to make it work.
Thanks
THNQDigital
View 5 Replies
View Related
Jun 6, 2006
What is needed for a hoster / hosting company to be able to host .Net applications with SQL Server 2005 Express database?
My questions regarding this issue basically are:
If a hoster has several sites hosted on a server, can each one of them have its own SQL Express database?
Or, do they have to be migrated to full SQL Server?
What is with the Upsize Tool for SQL Server Express (or something like that) - is it available?
Generally, how do hosters do their hosting - do they have SQL Server SPLA signed? Or do they just have SQL Server 2005 Express and allow users just to copy their web sites and databases to server?
I would really appreciate any answer.
Kind regards,
Luka
View 1 Replies
View Related
Aug 20, 2007
i've got a database stored on my computer using mysql server 2005, and I've just registered for hosting which uses the Plesk control panel.
In plesk I've setup a database and relevant user. What the easiest way of exporting the whole database on my computer and getting it onto my hosting account?
View 5 Replies
View Related
Mar 30, 2007
Hi,
I'm trying to get the External Activation Sample to work on a shared hosting Sql Server. The error seems to indication that I might be able to enter my db un/pw to get it to work. Where in the code or app.xml can I provide credentials? Here's the EA log. Thanks!
3/29/2007 4:47:39 PM STATUS: External Activator initialization completed.
3/29/2007 4:47:42 PM WARNING: Failed to connect to Notification SQL Server 'sqlb2.webcontrolcenter.com' and Database: 'xyz' because: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
3/29/2007 4:48:17 PM STATUS: External Activator is shutting down...
Stacy
View 1 Replies
View Related
Nov 16, 2005
I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?
View 3 Replies
View Related
Aug 23, 2007
I am creating a backup strategy for our non-production SQL Server 2005 data. We wish to utiliza the Master/Target Server scenario avaible in SQL Server 2005 with events directed to the Master Server. The question I have is what is the symptoms from the Target Servers if the Master Server fails and is unavailable for whatever reason there might be? I can change the event notification back to local server, but what other impact is there and are there any recommendations as to handle a Master Server outage so Maintenance plans can continue to execute as scheduled on Target Servers.
Thank you!
View 4 Replies
View Related
Apr 24, 2006
I have to spend an extra money on hardware if my PC hardware environment for installing SQL Server 2005 is not enough. Please tell me about it. It might be a RAM requirement? I don't know.
View 1 Replies
View Related
May 20, 2008
I am running into an issue trying to uninstall SQL Server 2005 64-bit. It hangs at the same point: Removing backup files. I then get a message that, "The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it." The instance that I am trying to uninstall is in a cluster hosting two other SQL Server installations. I have tried a few combinations when attempting to uninstall: running the cluster group containing the server I am uninstalling on a different cluster node than all the other cluster groups; running them all on the same node. The only one I haven't tried is moving the Cluster Group containing the IP address of the cluster, cluster name, etc to another node while running the other groups on the other node. Has anyone run into this issue? Each of the nodes has been rebooted several times during these attempts and we are using Windows Server 2003 Clustering. Again, the hang happens at the same point every time. The exact error(s) from the even log are as follows:
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29528. The setup has encountered an unexpected error while Completing Commit. The error is: The cluster resource cannot be moved to another group because other resources are dependent on it.
Product: Microsoft SQL Server 2005 (64-bit) -- Error 29530. Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 2 (The system cannot find the file specified.
)
Thanks,
Todd
View 6 Replies
View Related
Mar 5, 2008
Hi all,
Currently i faced a problem while setting up SQL 2005 STD into the Cluster Environment.
User has existing windows cluster purposely for Print Cluster usage.
We install SQL 2005 standard version into windows cluster.
After installed SQL 2005 cluster into windows cluster. All SQL services can be up correctly in Cluster.
Then we install Print Manager Plus software from vendor Softwareshelf.com into both cluster nodes.
Configure/add one additional resource as generic service with dependency with windows/system32/spooler.
Everything is working fine for that night.
Next day morning I install SQL 2005 Management Tools into both server.
User claim that one of the printers has 1 print queue cannot be deleted in Print Management software from Microsoft. We tried shutdown and unplug cable from that PC. That print queue also cannot be deleted.
That I check with Cluster Administration. Found Visual C++ runtime error. It is related with €œspoolsv.exe€?.
Existing environment: OS is windows 2003 Ent R2 SP2 x 2
Cluster has been setup for print management server.
Please help.
Thanks
Best Regards,
Chun Oon
View 1 Replies
View Related
Dec 8, 2006
Hi,
I am installing SSRS 2005 with the following scenario:
- Report Server and Report Manager will be installed on web server
- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.
Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1
When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.
The error message is:
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837
But this doesn't work.
I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.
I also look at BOL, but doesn't help much.
Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?
Many Thanks,
Usman Tjiudri
View 3 Replies
View Related
Jan 30, 2006
Environment:SQL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine
I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.
I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.
I got the error message. Please find the Message below.
An error occured while starting mirroring.
additional Information:
:..>Alter failed for Database 'KQDB', (Microsoft SqlServer.Smo)
:..>An exception occured while executing a Transact-SQL statement or batch
[Microsoft SqlServer.Connection.info]
:..>Database mirroring Transport is disabled in the endpoint configuration.
[Microsft SQL Server,Error: 1486]
If anyone have a solution on how to setup a database mirroring environment.Please send.
View 10 Replies
View Related
Aug 19, 2006
I've started with the development of a website which will use a sql server 2005 database. I want to use the asp.net membership and roles functionality. In the end the website will be hosted by a hosting company.
What is the best way to store the database? In the App_data folder or outstide the App_data folder?
Second, do hosting companies support placing sql server databases stored into the App_data folder?
View 1 Replies
View Related
Nov 1, 2006
I'm using SQL Server Management Studio Express and I'm trying to figure out how to copy a table(s) from my local database to my web hosting database. I know how to do it in 2000, but it's completely different now. Is this feature not allowed on SSMSE? If so, then how do I deploy database tables to a web host?Also, how do you add local database(s) to SSMSE? I tried to use 'attach database' in SSMSE and it wouldn't allow me to navigate to My Documents folder where the database resides. Thanks...
View 8 Replies
View Related
Jan 31, 2007
I've seen other posts on this topic, but not with error 0x32.
I was attempting to change a CLUSTERED instance of SQL 2005 from dynamic port to static port and in the process have somehow messed it up to the point it will no longer start. Version is 9.00.2047.00
The ERRORLOG has the following
2007-01-31 15:02:05.77 spid9s Starting up database 'model'.
2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1c.
2007-01-31 15:02:05.77 Server Error: 17182, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server TDSSNIClient initialization failed with error 0x32, status code 0x1.
2007-01-31 15:02:05.77 Server Error: 17826, Severity: 18, State: 3.
2007-01-31 15:02:05.77 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-01-31 15:02:05.77 Server Error: 17120, Severity: 16, State: 1.
2007-01-31 15:02:05.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
The values have only been changed using SQL Server Configuration Manager (no direct registry changes have been made).
Thanks for you help.
View 1 Replies
View Related
Dec 6, 2006
Hi,
We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1.
The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix).
Does anyone know what is going on, how to fix it?
Thanks.
Cathie
View 12 Replies
View Related
Nov 14, 2006
I've hosted a website in a freehosting account which supports .net 2.0 and SqlServer 2005Express and they only gave me an ftp access which i can access my website, i found that there's the "App_Data" folder which i placed my database in.Now here's the message i get when i try to connect to the SQL Express DBAn attempt to attach an auto-named database for file I:DataWebqsh.eucipherasp_015f1bdd-1338-4a35-9873-b29232b472c9wwwApp_Datacipherasp.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC shareSo, what should i do!
View 5 Replies
View Related
May 21, 2008
Developer made website. I want to upload in sever. There is
no index.html. Linux server is not
supporting. Files & Folders are the following.
1. ADMIN 2. APP_BROWSERS 3. APP_CODE 4. APP_DATA 5. BIN 6. IMAGES 7. ADS.XML
8. CALENDARDATEINPUT.JS 9. CHKUNCHECK.JS 10. CONTACTUS.ASPX 11. CONTACTUS.ASPX.CS 12. COUNT.JS13. COUNTING CHAR.ASPX 14. COUNTING CHAR.ASPX.CS 15. DEFAULT.ASPX 16. DEFAULT.ASPX.CS
17. DEFAULT.CSS 18. LOGIN.ASPX 19. LOGIN.ASPX.CS 20. MASTERPAGE.MASTER21. MASTERPAGE.MASTER.CS 22. MYCUSTOMPAGE.HTM 23. RECOVERYFORM.ASPX 24. RECOVERYFORM.ASPX.CS
25. REGISTRATION.ASPX 26. REGISTRATION.ASPX.CS 27. SALE.ASPX 28. SALE.ASPX.CS 29. SMS.ASPX30. SMS.ASPX.CS 31. SMS1.ASPX 32. SMS1.ASPX.CS 33. SMSSERVICE.ASPX 34. SMSSERVICE.ASPX.CS
35. TERMSCONDITION.ASPX 36. TERMSCONDITION.ASPX.CS 37. WEB.CONFIG 38. WEB.SITEMAP
39. XMLFILE.XML Please suggest & support me which server will support my file. I am
waiting your answer. I shall be very grateful to you. My email address is yog2599@sify.com
Thanks.
View 4 Replies
View Related
Nov 28, 2004
I am trying to export from an SQL Server on a hosting company to my own computer using DTS. I'm new to SQL Server manipulations like this so please go easy on me...
I can't seem to manage to do this properly - If I select "Copy tables & data only" it will not copy the identity constraints and primary keys. If I select "copy all objects" it starts giving me permission issues which I cannot seem to resolve, because I guess the tables on the hosting server are owned by my username up there, but when they come to my computer they are orphant?
Isn't there an easy way to do this? It's a very simple database, tables and that's it, not even any stored procedures.
View 3 Replies
View Related
Oct 9, 2006
I told my client to use a particular host, or at least one that offers a database... they instead went with a friend of a friend that offers hosting as a reseller.
Now I'm the web developer for this huge site overhaul which requires a database with a host that doesnt offer it.
I'm new to databases... thats why I'm accustomed to using the simplicity of ipowerweb or mediatemple and their phpmyadmin interface.
Anyway... what do I do? Will a database hosted elsewhere work? If you know about this stuff, please help.. I may not be asking the right questions!
THanks!!!
View 1 Replies
View Related
Feb 22, 2008
Hi
I have experience only designing an implementing DB in sql2000 but not too much administering.
My app is a Web Service that communicate with my DB.
The DB is in a hosting company, so I don€™t have too much permissions to play with.
The application have been the same for at least one year, no changes at all but recently my users complaint that the system was not working/responding.
I immediately thought about excessive load
When I went to query analyze and execute the command (sp_who), I saw that 173 processes where sleeping €“ awaiting command
that is the only thing I can imagine was the problem(not sure yet). I investigated and found the Kill process instruction but I was not able to run it because permission.
Based in this scenario How can I give a fast CPR to drain my DB and allow my user to work?
Any link?
Any sug?
thanks
View 6 Replies
View Related
Dec 30, 2006
Does anyone use One and One Internet (UK) for their hosting?
I use them and when I published my site all membership feautures wouldn't work, I called the One and One support and they said that their servers only support SQL Databases if they were created using their own tool in their control panels.
How would I get my site to use their database, I'm really not sure.
If anyone else could help me out I'd be grateful.
Kind Regards
Mattie
View 2 Replies
View Related
Jun 24, 2007
hello guys
I am developing ASP.NET applications in order to build a portfolio, im using MS SQL EXPRESS databases, do i need a hosting account that allows multiple sql databses or does SQL express fit in to your application, eg as many as you like in as amany applications. I am asking this because i know MS SQL server is a different thing from MS SQL EXPRESS server and hosting companies say stuff like 1 MS SQL databse and stuff. I have multiple applications that wont need the real MS SQL databse because there not live just portifolio stuff.
Can somone sugest a ASP.NET hosting company please a cheap one.
Thanks
Nadeem
View 2 Replies
View Related
Feb 16, 2005
I will like to know the files i will load to a remote server if i want to host an sql database.
let's use the northwind database for example, if i want to host it on hosting server what are the files i will host i mean i need a detailed procedure on how to go about it.
View 1 Replies
View Related
Jun 11, 2006
Hi all!
One good thing about access databases is the ability to upload the .mdb file to a hosting server and not being charged for database space.
How about MSDE? Does it require SQLServer hosting or can it be done just by uploading the database file?
Thanks,Ricardo
View 1 Replies
View Related
Oct 29, 1999
How u can connect u sql database with web server ?
bye
Navnit
View 2 Replies
View Related
