SQL Server On Chared Hosting With Client Connections
Jul 23, 2005
www.shanje.com
does sql server hosting, on shared servers, at a reasonable price. It seems.
They also allow client connections. Just playing around I've managed to
connect an Access Data Project to a SQL Server database, and to access the
database from Enterprise Manager (running locally).
First of all - what does anybody think of that as a general idea - local
client, connecting to MS SQL Server running on a shared host, connecting
over the internet (ADSL here). Speed looket OK ish, but of course I haven't
done any real stress testing.
Second. In enterprise manager I could see ALL the database, though I could
only access mine. What's the security implications of this approach?
Third. Anybody got any experience of Shanje? Service/uptime/value etc. Or is
there anybody else offering a similar service?
Cheers, Jo
View 3 Replies
ADVERTISEMENT
Jul 23, 2005
I'd like to do this:Have a SQL Server database hosted on a public facing web server.I want it to be held at an ISP/Web hosting company. Though I have ADSL hereI don't want to manage a server.I want some ASP pages accessing the database.I would also like for a very small number (probably 2) of users to accessthe database from a richer client. Perhaps Access/VB.I've tried using www.shanje.com, as a test. It seems to work, though thereare worries about security.I want to keep cost down!On 'normal' shared MS hosting, would it be possible to connect to the dbfrom a client like Access. The way most web hosts talk it doesn't look likeit.Is there any way of providing a richer client interface than plain webpages? I want things like autocomplete (beyond the first character) for dropdowns, keyboard shortcuts etc.This would be low volume. Essentially a private database held on theinternet.Yours, Jo
View 2 Replies
View Related
Oct 25, 2005
I am running SQL Server 2000 on windows XP pro. I have configured (enabled) TCP/IP protocol and left the default port 1433, but SQL server still does does not listen for client connections.
Can anyone tell me what might stop SQL server from listening???
With the server running, here is what I see (nothing on 1433...):
Proto Local Address Foreign Address State
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1030 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1031 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1098 0.0.0.0:0 LISTENING
TCP 0.0.0.0:6401 0.0.0.0:0 LISTENING
TCP 0.0.0.0:10002 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1034 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1037 0.0.0.0:0 LISTENING
TCP 192.168.0.104:139 0.0.0.0:0 LISTENING
TCP 192.168.0.104:1138 38.119.97.5:119 ESTABLISHED
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1900 *:*
UDP 192.168.0.104:123 *:*
UDP 192.168.0.104:137 *:*
UDP 192.168.0.104:138 *:*
UDP 192.168.0.104:1900 *:*
and here is the server log:
2005-10-25 23:23:24.31 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2005-10-25 23:23:24.31 server Copyright (C) 1988-2000 Microsoft Corporation.
2005-10-25 23:23:24.31 server All rights reserved.
2005-10-25 23:23:24.31 server Server Process ID is 3792.
2005-10-25 23:23:24.31 server Logging SQL Server messages in file 'c:MS SQL ServerMSSQLlogERRORLOG'.
2005-10-25 23:23:24.34 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2005-10-25 23:23:24.71 server SQL Server configured for thread mode processing.
2005-10-25 23:23:24.71 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2005-10-25 23:23:24.74 spid3 Starting up database 'master'.
2005-10-25 23:23:24.92 server Using 'SSNETLIB.DLL' version '8.0.194'.
2005-10-25 23:23:24.92 spid5 Starting up database 'model'.
2005-10-25 23:23:24.96 spid3 Server name is 'GS-DELL'.
2005-10-25 23:23:24.96 spid3 Skipping startup of clean database id 4
2005-10-25 23:23:24.96 spid3 Skipping startup of clean database id 5
2005-10-25 23:23:24.96 spid3 Skipping startup of clean database id 6
2005-10-25 23:23:24.96 spid3 Skipping startup of clean database id 7
2005-10-25 23:23:25.10 spid5 Clearing tempdb database.
2005-10-25 23:23:25.28 server SQL server listening on Shared Memory, Named Pipes, Rpc.
2005-10-25 23:23:25.28 server SQL Server is ready for client connections
2005-10-25 23:23:25.59 spid5 Starting up database 'tempdb'.
2005-10-25 23:23:25.71 spid3 Recovery complete.
2005-10-25 23:23:40.37 spid51 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_MSADEnabled'.
2005-10-25 23:23:40.71 spid51 Error: 15457, Severity: 0, State: 1
2005-10-25 23:23:40.71 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-10-25 23:23:40.89 spid51 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
2005-10-25 23:23:40.93 spid51 Starting up database 'msdb'.
2005-10-25 23:24:54.20 spid51 Starting up database 'gpldb'.
2005-10-25 23:24:54.26 spid51 Analysis of database 'gpldb' (7) is 100% complete (approximately 0 more seconds)
2005-10-25 23:24:54.46 spid51 Starting up database 'Northwind'.
2005-10-25 23:24:54.60 spid51 Starting up database 'pubs'.
View 2 Replies
View Related
Apr 30, 2007
SQL Server is cutting off client connections intermittently and I'm having a hard time figuring out why. Restarting the SQL server service fixes the issue for a few days but then it happens again. It's SQL Server 2005 on Windows SBS 2003 with XP and Win2000 clients connecting. Clients connect via a DSN file--they run an Access database. I run daily backups and all maintenance tasks on the databases and these happen without any errors.
Here are some of the error messages I get from the SQL Log:
Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: 192.168.1.16]
Error: 18056, Severity: 20, State: 23.
The client was unable to reuse a session with SPID 72, which had been reset for conection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x862. Administrator should deregister this SPN manually to avoid client authentication errors.
And a recurring error in the SQL Agent Log:
[165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]
any clues into how i can further troubleshoot would be appreciated. I can't reproduce the error on command but it is bound to happen "randomly" during business hours and i really need it to stop. any insight appreciated.
thanks,
k
View 4 Replies
View Related
Apr 18, 2007
I cannot understand how this was allowed to happen, but I can recreate the situation all day long. Someone, please tell me that I have missed an obvious solution to this;
With a fresh install of SQL 2005 Express (SP2) I have 4 databases installed and two service-based applications running. One of the service applications uses/requires three of the four databases and the second service application uses/requires the fourth database.
On boot, with the above described services set to depend on SQL Server service startup I get repeated failures on initial database access. Looking at the event log reveals why (in sequence):
SQL Server Startup...
Event: Server local connection provider is ready to accept connection on...
Event: Server named pipe provider is ready to accept connection on...
Event: Server is listening on [ 'any' <ipv4> 1911]
Application Service Startup...
Event: SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again
Moments Later:
Event: SQL Server is now ready for client connections. This is an informational message; no user action is required.
Now, its clear that the SQL service has started, and that this opens the floodgates for dependant services to start, each of which is told - essentially - to go away and come back once the SQL server has **really** started. With the accompanying suggestion to 'look for the informational message that indicates that SQL Server is ready' in the event log.
Am I reading the situation right so far?
In response to this, with my developer way of thinking, I could probably script the startup of application services rather than have them start automatically at boot or some such insane idea. But its not really the way that I had planned to spend the next few hours of my life, and it seems to me that I should not have to do such a thing.
Our in house service application (one of the two described) is in fact robust enough (just enough) to survive and to try the connection periodically, accomplishing a successful startup even with no database available.
The second of the two services is external and is unfortunately unable to start with no database available (Business Objects XI CMS). The normal means of making this service robust against database outages is the service restart procedure setting. But since the service doesnt ever start successfully, this doesnt work (learn something new every day - the restart is literal. It does not provide an initial startup retry and the service must have been started and fail for the retry to kick in)
Now, im not trying to bash anyone over this situation and regardless of the inflexible nature of the external service application and the general sillyness of the SQL server startup sequence - i mean c'mon... we are started but not ready? How about dont report startup until after you are ready? - the end result is that I need to come up with a solution to this problem.
I cant imagine that this is the first time that this behaviour has been questioned and I have to believe that there will be a simple, reliable workaround. I will keep looking for myself, but if any of this sounds familiar and you have a suggestion, your response will be greatly appreciated.
View 2 Replies
View Related
Jun 20, 2007
Hi guys,
You know when restoring a database in SQL Server, exclusive access is required. With sp_who I can see the clients. But I don't know how to terminate the client connections easily. Usually I have to stop the server and restart it. I DO think it's too troublesome. Do you have any ideas? Is there any sp or command, or tool that may help? How do you deal with this issue?
Thanks!
View 4 Replies
View Related
Dec 7, 2006
If I look under SQL native client configuration | Client protocols, I have no entries and no ability to look at the properties of SQL Native client Configuration. Something is missing which I think is related to an error when connecting to my local server.
sqlcmd -E -S .devmain, 1064
I get error :
Encryption not support
sqlcmd: Error: microsoft SQL native Client : Client unable to establish connection
An error has occurred while establish 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..
In comparison to other machines here at work, it appears my remote connections are configured. But I have no Client Protocols under sql native client configuration, how can I get them in there?
Thanks, in advance.
View 5 Replies
View Related
Jun 5, 2006
As stated in the subject I have a situation where if database mirroring is employed for either manual or automatic failover, all the client (including web connections) connections use ODBC not ADO, or OLEDB etc... so what methods are recommended? Client side redirect is not available so I could not employe the "Data Source =A; Failover Partner=B..." option.
Right now the method employed (pre database mirroring and basically employing log shipping on SQL 2000) is to have a DNS alias for the ODBC connection so that if the server were to change in a failover situation the DNS record would have to be altered, so that all the client connections would not have to be reconfigured.
Regards,
Dominic Baines
View 5 Replies
View Related
Mar 31, 2014
I have been investigating the number of connections activeinactive to a certain database server and I have stumbled across an application which seems to not be clearing its database connections.For one instance of a client there was >70 sql connections which eventuated from the closing and reopening one 1 screen in the culprut app. Once the application was closed all of the connections are recycled but its evident that within the application itself it is not correctly reusing already existing open connections.
I have raised a point with the main programmer that we need to investigate more into how the application is managingot managing its ADO .NET connections to SQL.
I am starting with doing some reading here URL... and I was hoping to get some more information about the possible impact of excessive sql connections on the SQL Server itself. Our organization is quite lucky in that our SQl Servers are Overspecced given their workload, bearing that in mind I would like to dig a bit deeper to get some stats if I can to highlight the scope of the issue to the managementprogrammers.Our SQL server peaks at 6500 processes and a good 70% of those are due to this applications mis-management of its sql connections.
View 6 Replies
View Related
May 2, 2006
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
View 2 Replies
View Related
Oct 29, 1999
How u can connect u sql database with web server ?
bye
Navnit
View 2 Replies
View Related
Mar 14, 2007
I have a server that i would like to use as a dedicated DB Server. It is running Win Server 2k3 and SQL Server 2005. The typical upstream bandwidth is anywhere from 384Kb/s to 700Kb/s. Is this enough to host multiple SQL Server 2005 DB's?
The DB's will be used for database driven websites.
Please let me know what your thoughts are.
Thanks,
View 1 Replies
View Related
Aug 5, 2007
I have established roles to restrict access to the data
entry pages. The database is SQL Server which I've established on the hosting server. Security was previously maintained through
~/app_data/aspnetdb.mdb (MS Access). It works, but isn't too stable, so I have modified the security to use
SQL Server with an aspnetdb.mdf file, also located in the app_data
folder. Is this appropriate? Since it doesn't work, I assume not.It's now my assumption that I need to setup a SQL Server
database to support the security/roles. I have seen some reference to
using a script to build the aspnet.mdf on the hosting server. If
I do create such a database, is there anything special I need to do to
have my application read the aspnetdb? Do I need a connection string
in the membership and/or roleManager sections of my web.config.
A little guidance would be appreciated.Thanks
View 4 Replies
View Related
Aug 12, 2007
I have been reading on aspnet_regsql.exe tool and still haven't found my answer. So here we go... I am using VWD Express and I have already made many pages in many dbs within the app folder. My question is how do I use the aspnet_regsql.exe tool to know what DB that I want the tool to know AND how do I put in the name of the DB on my sql hosting server? For instance:Let say in my app folder I have a DB named testDB.mdf and my hosting sql server is named sqlHostingServer... so if I use the command line entry in accordance with the documentation, it should look like this (in the dos prompt):aspnet_regsql.exe -E -S localhost -d testdb.mdf -A all -sqlexportonly c:output.sqlbut it seems that for the DB name I can put anything I want and still gives me output... wtfark... any help? I don't work at Microsoft so please simple documentation or something like that.Thanks,MR
View 4 Replies
View Related
Dec 15, 2003
Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..
View 1 Replies
View Related
Dec 29, 2005
I am currently developing an asp.net 2.0 app which uses form authenication now implemented in a sql server express mdf database file. I wonder if there will be problems when I want to deploy this app on a hosted server from a hosting provider. I have the impression that hosting a SQLexpress user instance is currently not supported by hosting companies. Is this correct? Should I revert to an msaccess database instead (we don't want to pay extra for full blown sql server storage).
Ronald
View 5 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
Mar 11, 2015
I'm a web developer who writes transact-SQL to make my web applications run properly. I'm not real strong in other areas of SQL. Let me explain our set-up and then I'll explain what I want to do:
We have an ecommerce web site and all sales are saved in a SQL Server 2008 R2 database at our hosting company. We also have a local Windows 2012 network that has SQL Server 2014 Express installed.
Here is what I want to do:
I want to copy sales rows from the SQL Server 2008 database at our hosting company and save them in the SQL Server 2014 Express database on our local Windows 2012 server. I'd like to automate this if possible so that it happens each night perhaps. I know there is a way to schedule SQL jobs but I've never actually done this. I also would need to know how to attach to our hosting company DB as well as our local network DB.
View 2 Replies
View Related
Mar 15, 2004
Hi Friends,
If I upload my Sql Server Database to a hosting company, can they see my tables?
Regards,
View 1 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
May 20, 2003
I'm new to database development and have created a database-driven website which now needs to be uploaded to the client's hosting company server. What is the easiest way for a newbie to upload a copy of the databse to the host. Thanks in advance.
View 1 Replies
View Related
Feb 5, 2005
i am getting ready to build the back end for a client server application, using a shared sql server as a back end. microsoft's white pages don't mention shared hosting. i need to know if anyone else has had problems with lisencing in a shared hosting environment. my web host told me i don't need to liscence my users (who will have read write priveledges), but microsoft gave me the impression that i did. anyone know a clear answer?
View 2 Replies
View Related
Apr 28, 2004
I am using a SQL Server 2000 Database for the purpose of development.
Now I want to host the SQL Server2000 database in the internet and I want to access it via the ASP.Net
1) Please, what is the best server that host SQL Server databases?
2) And Can I control the database remotely(such as execute srcipt to change table structure in the hosted database) as I did in Query Analyzer?
3) Is the administer of the hosting server able to change the strucure and contents of My Hosted DataBase?
Please send me an example if you have
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
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
Oct 13, 2006
Hello,FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the expree editon dont have function to import or export.Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables usin management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please
View 7 Replies
View Related
May 30, 2008
hi all,my hosting company uses a different port for connect to their sql server.how do i register a server in sql server management studio with a different port number??
View 3 Replies
View Related
Nov 16, 2005
I have a database in my local system. here every thing is working fine. now i need to upload the database in the hosting server. i dont know how to upload the db. so i sent a msg to my hosting support center , they told "use microsoft enterprise manager software for upload". pls let me guide how to upload through enterprise manager. please. i know the remote database username and password.
View 2 Replies
View Related
Apr 28, 2014
We have request where client want to host both application server(IIS...etc) and MSSQL DB server on same machine. (DB is used for Time & Attendance tracking only, so there are not many transactions per day and No HA) .........
Do we have any disadvantages if we host both on same Machine.?
View 1 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
Sep 17, 2007
All,
Is there a way to simulate hosting three environments on one Report Server. Due to resource limitations, I would like to set up three environments DEV, TEST, STAGE on one report server such that the data source for each environment would be different. Can I use a different folder structure for each and then deploy the reports by providing server url accordingly?
e.g.
http://servername/DEV_Reports or should it be (http://servername/ReportServer/DEV_Reports)
http://servername/TEST_Reports
http://servername/STAGE_Reports
and then in each of the above define a datasource that has connections to appropriate database on db server. Can we do something like this?
Thanks.
View 2 Replies
View Related
Oct 16, 2006
Hello,
FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the express editon dont have function to import or export.
Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables using management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please
I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings???? when i ask the provider they told me to use the management studio for the databse for connection into their server.
i also noticed if i install the application which use sql server dataabse it can be install the database including the tables and the data, so how is it i want to make my web site including the database be like installer. Like CommunityServer Forum? i just install into web hosting..is it possible?? How the way?? Thank you
note: I'm newbie in VS and Sql server
View 6 Replies
View Related