The Sql Mobile site on MSDN recommends that you do not host SQL Everywhere when running as a service. Is this a recommendation, if so why, or is it simply not possible. My understanding is that when hosteed in a IIS hosted application a not supported exception is throw.
If anyone has any ideas on this or pointers to some resources i would appreciate them.
Thank You
Architecture question for anyone....We have a typical SQL Server 3-tier VB.net app running at corporate and want our customers to interact through a website. If we host the website on-site, we can simply access the DB; but if we host at a remote location and want the users to perform updates (think DHL, Wells Fargo, Amazon), we'll need replication with Peer-to-peer. Some basic questions:
1) is everyone doing it this way?
2) will we need a full time replication consultant to set this up, keep it up, and keep an eye on it (administering the 50 user, 200 table DB is relatively easy and we've not needed a DBA for the past 10 years).
3) we're not DHL or Amazon, we just want that kind of end user add/update/delete functionality...so transation rates will be miniscule. But still, the corporate site is constantly being updated so we'll need a fat pipe to the hosting service, etc... any thoughts on performance?
any other tips on doing an installation like this?
thanks in advance
john
Hi,
Can a web hosting company charge clients for using an SQL Express instance on their network?
E.g. The host charges the client $x per month per instance. Is this legal?
Hello,
Im a bit of a novice at this so please bare with me
Does anyone know how to convert a .mdf to .csv as my hosting provider will only allow .csv importing to there SQL servers.
Plus will my data base work in this .csv format. (comma separated value)
Thanks in advance
I created a small ASP.NET website with VS2008 that employs user authentication (login) functionality to protect some of the site data and allow access only to authenticated users. This functionality created an ASPNETDB SQL database in the project to hold all the user data such as usernames, passwords, user roles, etc. The website works flawlessly on my local PC but when I copy the files to my windows-based web server (IPOWER host) I can't find a way to activate the SQL database so the user authentication functionality works. I've been through all the Scott Guthrie tutorials on this subject here and here, but none of the suggestions worked for me. IPOWER is no help since they will not provide technical support for scripting.
I'm at a loss. This is just a simple little website but I've hit a wall and can't seem to find my way around it. I am new to ASP.NET and SQL server applications so my newbie status certainly plays a role here.
I will gladly pay someone (via PayPal) to spend time with me on the phone talking me through the steps to get the site working on my web hosting site. Other than that, are there any other suggestions on what I could try?
Thanks in advance for your help with this.
Doug
Hi, I'm developing a website using VWD 2005 Express, which needs a Membership system and a products database. Using the VWD inherent Web Site Administration tool makes the membership set up easy but by default it creates a 'Local' SQL database in a folder named 'Apps_Data' in the VWD project. My question is: considering I will need to upload my web site to a Hosting Service, would it be better to change the default so that the membership systems, and the product database I need, are created in an SQL 'Server' database instead of a 'Local' database?
The hosting service I am considering using is having a bit of a problem understanding this question, I hope it makes sense to someone or am I asking a stupid question?
Regards
Sean.
I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.
The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.
Again, the app will run all packages just fine. The data is imported and the results return as "Success."
The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = sPackageFolder & PackageName & ".dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
Dim vars As Variables = pkg.Variables
vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath
pkgResults = pkg.Execute()
All,
I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.
My question is:
Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?
Any help is greatly appreciated!
Mark
I am doing some research to see if the Service Broker technology would help my company with our Enterprise application. Here is our scenario: We have a 3 tier system. The first tier needs to contact the second tier asynchronously. Hence, using queues is a good option. However, the process that needs to happen on the second tier is mostly process intensive with little database updates. Is it still worth our time to use Service Broker?
I like the concept of Activation that Service Broker provides. But, from what I am reading most of the documentation describes activation as a way to call another stored proc. I definitely dont' want to do any process intensive work on the SQL server. So here comes my question...
How would I use a windows service to listen to the activation event from the Service Broker. I could have multiple windows services watching the same queue (scalable). Would I have to handle collisions myself? If so, I think I would rather keep it simple, and just use a simple table as my queue.
Thanks for your comments in advance...
Vijay.
Hi All,
View 1 Replies View RelatedI want to monitor the transaction log files for growth to limits and be able to automatically shrink the log... I had to do it manually the last time I had to do it with my current setup.. Is there away without having to run a windows service for monitoring the file size or drive space left?
Example; current transaction log is ~8gigs at full limit... reduced was ~5gigs, this is just 1 transaction log for 1 database on server.
Morgan
Greetings. I'm wondering if y'all typically turn off filesystem indexing (IE: uncheck "Allow indexing service to index this disk for fast file searching") on the drives that hold your ldf and mdf files? Do any mssql services depend on this functionality?
Thanks,
Amy
HI,
Recently i had to maintain few SSIS packages. One of the packages keeps running indefinitely to monitor a folder for new files using FileSystemWatcher. Once new file is arrived, it simply renames file and calls another package for further processing. My first impression was that windows service might be a better choice for such functionality.
Any idea about these two approaches to implement this functionality i.e Continuously running a package using indefinite loop as compared to a windows service.
Thanks
Saeed
The problem is integrating an ADO connection into a Service in C#. The peculiar thing is that the same thing works well in an application but throws a problem in the Service i.e. the Service doesnt want to start...
The problem is at establishing the connection - but the same thing works just fine in an Windows application.
string MySqlConnString = "SERVER=N16\SQLEXPRESS; TRusted_connection=yes; database = EventTrack2007";
MySqlConnection = new SqlConnection();
MySqlConnection.ConnectionString = MySqlConnString;
MySqlConnection.Open();
Thank you!
I've done a bit of work with the External Activator but I think it may be a bit overkill for what I need to do (which is RECEIVE messages from a single queue and process them with managed code). I've tried creating a Service Broker Interface service that retrieves messages from this queue, but I notice that if I set the timeout to -1 to watch for messages indefinitely, the Service never completes the OnStart code.
I notice if I change the service's timeout to something greater than 0, the message is retrieved, but this defeats the purpose of using a Windows Service app, which I want to continuously monitor the queue. I noticed the External Activator spawns a thread to start monitoring an EventNotification queue, which I can bypass since I want to monitor the notification's target queue.
Rushi, can you point me in the right direction to create a Windows Service that constantly monitors a queue? Also, I'd like the ability to monitor multiple databases (the queue name would be the same) as well, so if that is not feasible from a Windows Service please let me know.
Also, am I sacrificing scalability by NOT using the External Activator and switching to a Windows Service (I believe the External Activator will spawn multiple instances of the processing executable)?
Thanks,
Chris
I'm building a Windows Service which keeps getting denied access to SQL Server 2k. The Service operates as a System User rather than an individual user profile.
I've tried Trusted_Connection=yes and Integrated Security=SSPI but these are both denied.
Any ideas what the connection string to connect to SQL Server 2k from a Wndows Service is?
hi all.
please help with my dilemma.
this is my task:
i should write a service that will run every 1 hour.
this service should check a folder.
inside this folder there are some xml files, all of them in the same format exactly.
when the service encounters with this xml file, it should open it,pull some data out of it, and update a table in the db.
NOW - I HAVE 2 OPTIONS, AND THIS IS THE DILEMMA:
should i write a clr function to do this task, or should i just write a standard c# windows service, that will open a connection to the db when it should perform update?
what are the advatages?
I've got a report that shows the current status of sql activity on my servers for our ERP application. The one thing I've been wanting to do is to add the ability to check if a certain windows service on another server is running. Is this possible in Reporting Services 2005?
Thanks,
Ian
Hi,
I'm currently writing a windows service which will generate XML documents for FTP upload. When running the service the goal is to get records from a stored procedure, then generate the XML documents.
When running the service (lokal service account) the connection fails; instead of using the supplied connection string, it defaults to the LocalService account. How can this be solved?
Thanks in advance
I'm developing a Windows Service to watch for an e-mail and then launch a package. It extracts some parameters from the e-mail that I then need to pass to the package. What is the best way to launch the package from the service? Should I run it in a new thread? I don't want the service to have to wait for the package to complete. How would I pass the parameters? Should I use dtexec? If the service fails or is stopped and the package is still running, it would terminate the package also, correct? Any way to avoid that? Thanks.
View 3 Replies View RelatedHow to find out the SP available for sql server 2000 with win xp
View 8 Replies View RelatedHi
I would like to use SSIS Script for Monitoring Windows Service...
If Windows Service Up / Down. I should be able to Notified by
Using SSIS Script(SQL SERVER 2005).
Please Help me
Thanks & Regards
Deepu M.I
Hi
I am in weired move kindly help me out..I created report using sql server 2005 Reporting services..At one stage it is working fine with proper parameter but due to bad input parameter my report goes in hang mode..so i went to my DB server and restart my reporting service and then MSSQLSERVER I dont remember sequence (may be vice versa) now I am not able to get report when i am passing right parameter..I went to google and only I came to know that due to sequence of restart of services will cause this error..
error like..Application error:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Syste error:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Kindly help me out.
T.I.A
I'm getting Not associated with a trusted SQL Server connectionerrors on a .Net windows service I wrote, when it's running on myapplication server.It's not a problem with mixed mode security. I'm set for mixed mode andI've been running the service on the app server for over a month withno problem. My database is running on a second server and both areunder the same domain.The problem has occurred twice over the last two months.The windows service queries a table every 30 seconds, looking forrecords to process. It's using a connection string and the user id issetup and working in SQL. That when it's generating the error.I've changed the connection string user id to sa and I still get theproblem. (server=xxx;database=yyy;user=sa;pwd=xyz)The windows service is running under the domain/Administrator account.I can run the windows service from a workstation with no problem. Butwhen I start it up on the application server, I get the 'notassociated' error back from Sql Server.I'm trying to figure out where the problem is, and why it'sintermittent. Is it rights, policy, security? Why does it work for awhile then then error out?Any suggestions or help is appreciated.Thanks,Eric
View 2 Replies View RelatedHi,I tried to Develop one Report in SQL Reporting Service. I haveinstalled SQL Reporting Serivice in Windows 2003 machine. SQL ServerDatabase is in another machine, running on Windows 2000. I developedand deployed the report and all went fine.When I tried to see the report through the Report Service Manager WebPage it is comming properly. But When I tried to See the report inanother web page, I'm not able to see the images. But the Data isgetting Displayed and only Image is not comming. When I exported thereport to Excel, the Image is comming over there.I am using Report Viewer control (Which came as Sample Program) inthe ASPX Page to render the report. I'm using SQL Server 2000 with SP3aand SQL Server 2000 reporting Service with SP1.I tried setting the Mime Time for the GIF image and even "*.*" inthe Mime Type settings of IIS 6.0. Even then its not displaying theimage.Can any one help me out in solving the problem?Thanks in Advance.With RegdsKrish
View 1 Replies View RelatedHello,I hope you guys can help me with a problem that I am facing...I have started the MSSqlServer service and SQLServerAgent serviceswith a domain username and password.There are periodic password resets to this user. Security policieswithin the company dictate that the password for this domain accountcannot be permenant.Would there be any way to automatically reset the pwd in theseservices instead of manually changing them each time?Thanks
View 1 Replies View RelatedHi,
On the page http://www.microsoft.com/sql/editions/compact/default.mspx it is recomended that you dont use SQL Server Compact Edition if "you want to run as a service" - is this refering to the host application or to the fact the SQL Server Compact Edition is an embedded database rather than the more traditional SQL Server client/server architecture?
If its the former is this likely to change at any point in the future? Also what sort of problems are likely to occur if we did run it from within a windows service?
Many thanks,
- James
*EDIT [Changed capitalization]
I am using windows authentication to send messages from one server to another.
The user is a domain user that is sysadmin on both servers and db owner of each database.
The errors I see in porfiler are as follows
At target,
An error occurred while receiving data: '10054(error not found)'.
and the following at the initiator:
Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 67.
For what its worth, the script for my target endpoint is below, and access has been granted to public:
CREATE ENDPOINT [BROKER]
AUTHORIZATION [MYDOMAINmssqlssb]
STATE=STARTED
AS TCP (LISTENER_PORT = 4022, LISTENER_IP = ALL)
FOR SERVICE_BROKER (MESSAGE_FORWARDING = DISABLED
, MESSAGE_FORWARD_SIZE = 10
, AUTHENTICATION = WINDOWS NEGOTIATE
, ENCRYPTION = REQUIRED ALGORITHM RC4)
I've actually used these users/objects successfully dozens of times on a seperate server with many clients...I am just re-scripting the objects here on this new server. The new remote machine is an image of one of the original machines that was working fine (with new broker GUIDs).
Thanks for any insight.
John
I would like to use SSIS Script for Monitoring Windows Service...
If Windows Service Up / Down. I should be able to Notified by
Using SSIS Script(SQL SERVER 2005).
Please Help me
Hello
View 4 Replies View RelatedThis error is being displayed in the eventlog every minute. Any ideas on what it is referring too? I reviewed some posts but most point to specific problems of report server not running, or receiving this error during a run. We are receiving no errors at all. However this is jamming up the event viewer to make troubleshooting other issues very diffucult.
Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 3/23/2007
Time: 8:20:16 AM
User: N/A
Computer: SPECTRUM_DB2B
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Hello,
I am my department's Sys Admin and a relativelty Noobie when it comes to SQL server. So I recently Installed SQL Server 2005 on a Win2003 Server. During install I set my domain account as the service account login. After the DB and Web Application were setup and running good I realized that the SQL service accounts were logging in as my domain account. Not a good thing right? So in SQL Server Configuration Manager I changed the services from logging on as my domain account to the local system account instead.
Enter the problem: now I notice in application event viewer the Report Server Windows Service is erroring every minute. The error reads "Report server windows service cannot connect to the report server database." Im sure this was caused by me changing what account the report server service logs in as and local system account not having appropriate permissions. So what account should the report server windows service log in as? I see where to change the windows report service identity in Configure Report Server but I am not able to backup an encryption key? Thanks in advance!
Hi
I am developing a Windows Service product and use SQLCE 3.1 as data store, I found problem, that, when I inserted a record to sqlce data store from within service, I got an hidden window, the name is ms_sqlce_se_notify_wndproc, Could anyone has idea of how to disable this hidden window? Because my product is running as Windows Service, so this hidden window would be a serious security hole.
Thanks a lot!