Using A Windows Application To Connect To An Online Access DB.
Hi all,
I'm working on a project where I have to create a password protected form for teachers to submit reports about students.
Originally I was going to use asp.net to create the form, but unfortunately the server I'm working with will not be granted asp functionality in the allotted timeframe.
To solve this issue I have another idea. So I will ask a few questions to help with research before I begin coding.
Is it possible to create a windows application that can connect to an access database hosted online? The windows app will need to be be able to update, insert, and select information from the database.
There is only going to be about 30-40 people using this windows application once or twice a week.
Thus I envision taking a password protected access database and dropping it onto a server.
The windows application will have the online location of the database embeded into the code. (connection string)
From there on out coding for the windows application should be the exact same as if the database was hosted locally on the computer, correct?
Also,
1. What is a good way to check and make sure the computer is connected to the internet before my application tries to access the database?
2. Are there any drastic security issues with this process that I should think about. The database will only be password proected, and the windows application will take a username/password from the user and check it against a table before they are able to submit info to the database.
I just need to be pointed in the right direction for this project.
Thanks.
View Complete Forum Thread with Replies
Related Forum Messages:
Connect DtSearch From Windows Application
I have to search the keyword from windows application using dtSearch. when user enter the list of keywords in UI, i have to connect to dtSearch tool and based on the output return, the matched keyword should be added to database table. Now, i have problem in connecting this tool from my application. Thanks in advance.
View Replies !
Any One Tell Me The Code To Connect To .sdf File In C# Windows Application?
Hi, Any one tell me the code to connect to .sdf file in c# windows application?And tell the requirments to conncet.My sdf file path is this C:\Documents and Settings\koti\My Documents\Example.sdf I write this code.It is not working string str = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Documents and Settings\koti\My Documents\Example.sdf;SSCE:Encrypt Database=True"; SqlCeConnection cn = new SqlCeConnection(str); cn.Open(); Ant one help me Plz... Regards, venkat.
View Replies !
Can't Connect To SQL2000 On Windows 2003 Server Through UDL Of VB6 Component Of ASP Application
I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000. I'm using UDL as connection string. IIS and SQL2000 hosted on the same machine with Windows 2003 OS. This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security. Request your input to solve this problem. Sunandajit Ray Infrasoft Technologies Limited
View Replies !
Remote Access For Windows Form Application
I have a windows based software application that connects remotely to a sql server 2005 and calls stored procedures. There is someone that I work with that is cautioning the company strongly that this is a bad thing to do in terms of security. Isn't this a very common thing to do? Assuming that the SQL Server installation is setup appropriately. Is this a bad practice?
View Replies !
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Here is the Environment: App Server: Windows Server 2003 Standard Edition Inside Company's Firewall/ Network Database Server: Windows Server 2000 Advanced Edition SQL Server 2000 SP4 Remote Connections to the Server is checked Enable Protocols: Named Pipes & TCP/IP TCP/IP Port: 1402 (I don't know why it isn't the default of 1433) The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition. I can ping the db server from the app server using the IP address. I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server). I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP? What do I tell the network admin to change? Any help would be appreciated. Thanks, Oran
View Replies !
Online/Offline Application That Must Synchronize With SQL 2005
Hi ! I must developp a WPF Application with online and offline capabilities! First I think to use XML file on the local application and transfer these XML files to a webservice that will synchronize them with the SQL 2005 Server BUT I read about "Replication"... and I think it will be much simpler to implement!!! Do you think it is a good idea to have a "local" SQL Express database and replicate it (when connection available is) with the principal database that will run a standard SQL 2005 version! Do you have another suggestion to make such an application?? Thanks for help!!! PlaTyPuS PS: when the sql express solution a good idea is, does it give a simple solution to programm an automatic synchronization every hour?
View Replies !
Package Execution Fails In Windows Service But Runs Fine As A Windows Application.
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()
View Replies !
&"SQL Server Does Not Exist Or Access Denied&" Error When Trying To Connect From A Windows Service
Hi! I understand that this topic is one of the most discussed topics ever. However i could not find the relevant information after going through (almost) all the posts so far. Hence this post. I am getting the 'SQL Server does not exist or access denied' error when I am trying to access SQL Server from a WINDOWS SERVICE. SQL Server and the Windows service are running on two different machines. (When they are on the same machine, it works). All the solutions I found so far are related to web apps. What should I do in the case of a windows service? My connection string uses SQL server authentication. (I tried with windows authentication. Its not working either.). Under what login does windows services run and how can I add it to valid SQL server logins?
View Replies !
Concurrency Issue On A Single Database User For An Online Read/write Application
Hi to all DBAs, I would like to ask if there will be a write and concurrency issue if i would create an online application with just one user connecting to the database, just like most open source php/mysql that can be downloaded i.e Setup 1. I will grant a single user that will connect to a database and will be set to a config.inc.php file and then create a table users (userid, username, password) and this table will be used for the application authentication and access control. Setup 2. or is it much better to grant users that will connect to the database and have the table users for access control of the application? to further illustrate my query: Setup 1 would be: ###################Table: Users user a@ipadd --> db1 --> userid mary --> myOnlineApp user a@ipadd --> db1 --> userid john --> myOnlineApp user a@ipadd --> db1 --> userid paul --> myOnlineApp and Setup 2 would be: #####################Table: Users user mary@ipadd --> db1 --> userid mary --> myOnlineApp user john@ipadd --> db1 --> userid john --> myOnlineApp user paul@ipadd --> db1 --> userid paul --> myOnlineApp will Setup 1 be enough if I will use SQL Server as database? or Setup 2 is better user/database architecture? This application will be online enrollment for a school with 16,000 students very much appreciated for the feedbacks and suggestions ^_^x
View Replies !
Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...
Hallo there, I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available. My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs. I enabled all the protocols and all the ports I disabled windows firewall and antivirus (eset nod32) I installed all service packs available I have also installed Visual Studio 2005 without installing sqlexpress But nothing happens! Please i am very desperate, any information will be gratefully accepted. This is my installation Information Code Snippet Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000 Microsoft .NET Framework 2.0.50727.1434 Operating System 6.0.6001 Thank you in advance, Patonios
View Replies !
Online Connection Between Access And SQL Server
Hello,I am trying to develop a database solution for an organisation inIndonesia.This organization has a number of offices and users throughout thecountry. They all need to maintain their own data, but I also need tocreate a central database, to store all of the data, and share databetween the individual users. The problem is that the internetconnections are not reliable, so a online solution isn't possible. Iam planning to implement stand alone databases in Access, which "sync"with the central server. This sync could happen automatically (maybedaily), or could be initiated by the user. This Sync would/could takeplace when the internet connection is working.I am very familiar with Access, but I suspect that I will need to useSQL Server for the central database. I have not used SQL Serverbefore, and have a few questions:Is it possible to host a SQL Server, so that it is "Online"? What do Ineed to do for this? Does this need to be hosted by an ISP, or couldit been hosted on a computer in our office? What are the securityconsiderations?Is it then possible to connect to this SQL Server from the Accessdatabases in the various locations to "Sync" the data? If I could runSQL statements from the stand alone databases which could access theonline SQL Server I could write the code for the Sync procedure. Thebit that I am unsure of is how to connect to the SQL Server?Could anyone point me in the right direction? Examples? References?What sort of technology to use?I know VB and how to write SQL statements, it's just the connectivitythat I am unsure of.Thanks in advance.CheersMichael
View Replies !
Windows Application With MSDE
I am developing a windows application that will run on every client station. This application will refer to a database located on a server station. Can I use MSDE for such application and if so how many remote concurrent connection can be open simultaneously? Eric
View Replies !
Windows Application Log Settings
Is there a way to control some of the windows application log settings from within the logging process of a package. Specifically the 'source' parameter which comes out as 'SQLISPackage' which i'd like to be the actual name of the package which wrote to the log, and similarly 'Category' which comes out as 'none' and I'd prefer to assign something more meaniful ? THX
View Replies !
VS2005 And C# Windows Application
I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI. The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) . I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the projects Reference dialog. These were also copied to the bin folder of the project sqlceca30.dll The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access. sqlcecompact30.dll Provides the compact database functionality. Required if your application will use compaction. sqlceer30[language].dll Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications. sqlceme30.dll Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications. sqlceoledb30.dll Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database. sqlceqp30.dll The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications. sqlcese30.dll I also added using System.Data.SqlCE to the form and the dataset designer.cs From this code in the dateset.Designer.cs file after the run is started the eroror occurs. [System.Diagnostics.DebuggerNonUserCodeAttribute()] private System.Data.SqlServerCe.SqlCeDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); Error on this line.... } return this._adapter; Already tried this http://msdn2.microsoft.com/en-us/library/ms171861.aspx Is it possible to fix this? Or work around it? Thanks Jon Stroh
View Replies !
My SQL Application On Windows Mobile 5
Hi My application : On PC : Access application + Access DB On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB I synchronise my DBs through ActivSync. It runs good before Windows Mobile 5. My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported. So what are my solutions ? My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now. My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc .... Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ? Joël
View Replies !
Reporting Services For Windows Application
Hi We are looking at some options for reporting on our windows application. Is it possible to work with RS and a windows application? We are Not interested in having a server to store the reports rather having it as part of our application, is this option possible? Wondering whether RS would offer additional capabilities than Crystal Report. Any input on this will be much appreciated. Regards, -Vicky
View Replies !
Windows Mobile 5.0 Application &&> Xml File &&> Sql Ce 3.5
Hi there, i am building a mobile app using vs 2008, the app has about 8 - 12 forms that collect data.. i am thinking of i am trying to decide how i want to save the temporary work data while the user fills the data collection forms. when the user selects to create a new report, i will create a new xml file... as user moves from form to form, i will update the file when the user has finished filling up all the data i will create a transaction and insert the data into the sql ce database and delete the file... i will be using sql ce 3.5 i think it supports transactions i think it also supports identity.... i am using sql management studio 2005 standalone , so i cannot visually modify the 3.5 sdf.,..,. is there a tool for 2008 that will let me visually modify the table(s)? i dont want to use the 2008 feb community edition... is there a better way to do this? should i skip the xml and go directly into sql ce insert (for the first record creation) and updates? i think this will be a performance killer on a win mob devilce (5.0) p.s. i cannot store data in a class, and then commit the class to the transaction because if the application crashes i will loose class data, so xml file will be needed., suggestions?
View Replies !
Can't Connect From Web Application
Hello, For my application, I need to consult a database located on a server on the local network. The application is located on my pc. I use the connection string Code: "Integrated Security = SSPI;database=dbName;data source=serverName" (I program in C# and connect with ADO.NET) When I compile my project as a windows application, this works fine. But when I compile as a web application in ASP.NET and try the same connection, it won't connect. How can this be solved? Thanks
View Replies !
Web Application Cannot Connect To SQL
My web host has moved my website from one server to another at my request. The web application is .net and works with an sqlexpress database. Everything was fine on the old machine. But following the move I can connect to the database using Server Management Studio Express. But the web application throws-up the following message: 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) I am a liitle out of my depth here and my host is saying that the above is caused by a scripting error wheras it appears to me the copied sqlexpress databases need something doing to them. I would be extremely grateful for a steer in the right direction. Thanks in anticpation. Chris
View Replies !
Windows Application - How Can I Save The Values In Table?
HelloI use vs2008 and i try to make a simple windows program with add records to a database. The problem is the database don't store the values that i add. When i run my program (in design mode) everythynf looks fine, but if i close vs2008 and restart it again the database is empty. Why? Thank you
View Replies !
SQL Server 2005 - Windows Application And Website
Hi there, I have a question which I put the company that host my website but I didnt get a conclusive answer. Maybe someone here will be able to advise or help me with my situation. I want to build a database that I will run on my local server and the front end of this will be run using a windows application. I have a website which I run the database on the remote server. What I would like to do is to be able to synchronize certain tables between the two databases (such as updating products table, or orders table). I am using sql server 2005 and I am using the sql server management studio to access my database on the remote server. I did notice there is a synchronzie button. I also came across some 3rd party tools. Not sure if that is the way to go. If anyone as done this before or can give me any suggestions, I would be delighted. Thanks Anthony
View Replies !
Application Connection String Using Windows Auth
OK We have always used sql servwer login to the servers for all our applications for out intranet apps And we use windows auth to do development So when we do that we logon to wuindows, and then just connect, with no password required But how does an application "logon" to connect to a database Is it just in the connection string just like sql server auth or is it different?
View Replies !
Authenticating An Application Using Windows Integrated Authentication
Hi all, My work is using a shared application which accesses a MSSQL 2000 database. To access the application, the folder on the Windows 2003 Server is shared and users can access the folder through a shared drive. For the application to access the database, it uses an ODBC connection to the MSSQL server which originally used the SA password. We have recently switched to using Windows Integrated Authentication because we believe it offers a higher level of security. However the only way in which we have been able to enable this is to add the windows users to the SQL server. The problem with this is that the application sets permissions for individual users on what records they can see within the database. We have found that by adding the windows users to the SQL Server, they can bypass the permissions the set by the application by simply using any application that can use an ODBC connection, such as Enterprise Manager, and see all the database. One way around this would be to set up domains of users with access privileges to the tables which reflect the permissions set by the application, and configuring a view of the data so they may only see the records that they have permissions to. However to do this would require a high administrative cost to ensure that changes made in the application are reflected in the privileges of the SQL server. Instead, is there a way the SQL server can authenticate that the ODBC connection is coming from the correct application using Windows Integrated Authentication? This would allow the applcation to determine security, and stop users from connecting to the SQL server using other applications. Alternatively, can the SQL server, using Windows Integrated Authentication, also ask the application to supply a username and password? Any help with this matter would be greatly appreciated. Thanks!
View Replies !
SQL Server Vs Windows Application Project Maintenance?
I'm a database newbie, trying to decide whether to create an SQL Server or Windows Application project that uses SQL Server 2005 Express. As I understand it, the advantage of an SQL Server project is that the app deploys somehow as part of the database. If that's the case, how would I handle the scenario where the database has been updating at customer site and I need to install just a new release of the software? Would I be better of creating a Windows Application project and connecting to the database explicitly? Thank you.
View Replies !
How To Avoid That My Application Writes To Windows' EventLog?
Hi everyone, Every time that my application throws an .DTSX file I don't know who or what is writing on eventviewer.application if failed or successful. Execute method implements a customized class which implements IDTEVENTS but I promise that in any place of my code I'm writing that information. app.execute(nothing,... MYEVENTS) Public Class MYEVENTS Implements IDTEVENTS .. .. .. .. All the methods are declared although empty but OnQueryCancel which is customized. How to disable this behaviour? I'm concerned for that because of we could launch (when it's gonna in live) 300 or 400 packages on-daily basis!!! Thanks in advance and regards,
View Replies !
Windows Application With Connection To Database On A Server
Hi all, I think I can do this, just want to check Can I have an sql server database (mdf file) on a server and allow windows applications at different site manipulate the database. As far as I am concerned the only thing that needs to be configued is the connection string..is this correct. [i would rather use windows applications rather than asp pages] If I can, the best way to manipulate the database is to use stored procedures. How would I do the following to create and execute the following proposed procedure: Insert data into a table Update another table as a result Execute the store procedure on a form to execute these two statements Thanks in advance Peter
View Replies !
Windows Application Connection To SQL Server - Best Practices?
Hi all... I am looking for the best way to connect an application to a SQL Server 2005 database. It looks like creating an application role is the way to go.... to start things off I have a NT group which will restrict which users can do initially connect to the database (with no other access), and then onces they are connected the application will execute the "sp_setapprole" to connect to the application role. No matter which way I look at it, it seems that I have to store a password within the application..... something which I am not very comfortable with. This means that a person could potentially get their hands on the application role username and password. Does anyone have any suggestion regarding this? I am open to other techniques... Here is the MS security note:"The Microsoft ODBC encrypt option is not supported by SqlClient. If you must store credentials, encrypt them with the crypto API functions. The parameter password is stored as a one-way hash." Thanks! Forch
View Replies !
Connection From Windows Application To Mobile Device(*.sdf)
Hi, I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code: Dim cnn As New SqlCeConnection cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf" cnn.Open() But I get the following error: The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ] Any help would be greatly appreciated! Leila
View Replies !
Handling SQLServerCE DataBase By Windows Application ?
Hi i have the following problem : i attempted to connect with a SQLServerCE DataBase to Insert and update its rows, but i noticed that i want the reference : System.Data.SqlServerCe i went to (Add references) but i didn't find it .. what should i do to break this problem ? please help me !
View Replies !
How To Deploy SQL Server Everywhere With My Windows Form Application?
Hello! I've been creating a vb.net 2005 windows form application using Everywhere and it has been going pretty well. However, I haven't had much luck finding any help on how to deploy my Everywhere database file(s) and Everywhere itself. To install redistribute Everywhere, can I just add the the 8 .dlls found in the Everywhere directory into my VS setup project? Also, what database file(s) do I need to deploy in my windows setup? Thanks!
View Replies !
Data Application Blocks For Windows Mobile
I've read that microsoft.applicationblocks.data for .net v2 can't be deployed to a mobile app, and my experience bears that out. So I 'm wondering if there are application blocks for windows mobile 5 that would know how to both talk to sql server mobile and sql server 2005. I see OpenNetCF has a port but as far as I can tell, they only address sql server mobile and not talking to a sql server 2005 remote database. I can use the OpenNetCF version for my sql server mobile requirements, but I'm hoping there is an encapsulation of sqlclient calls for communication with my server db. thanks braden
View Replies !
Deploying Windows Based Database Application
Hi, I am developing a application which is dependent on Sql database (mdf). I want to know how should i need to deploye or Package the database along with my application , would i need to instal the sql server exp on to the client system, or there is any other way to do it , I know that an Access file can be accessed through the application even the client system dont hav Office, Is there any such type of mechanism , through which we can do the same with sql database
View Replies !
Cannot Connect To SQL Express From My Application
Hey everyone, I'm having trouble connecting to my sql express instance through my vb.net application. I can connect to it from Visual Studio and the management tools, but get an error when connection with a connection string. What should my connection string look like? I'm using the a default SQLEXPRESS instance.
View Replies !
Asp.net Application Connect To SQL Through A Firewall
Hi guys. We have an external webserver(server1 on domain1) is a DMZ, and sql server7(server2 on domain2) inside the firewall. Domain1 trusts domain2 but domain2 does not trust domain1. Our firewall hosting by outside vendor and they told me they already opened up the port 1433 for server2. I put a small asp.net application on server1(this application works fine in intranet. 2000 server,iis5,virtue directory, and .net frameword were well installed and configured), and I got S'QL server does not exist or login fail error'. Any idea about that? And how to test the port was opened? Any input appreciated.....
View Replies !
Connect To SQL Server From ASP.Net Application
Hi I developped an ASP.Net application (with Web Dev Express ) wich attempt to connect to SQL Server Express (installed in the local machine) using Windows authentication.When i launch my application within Web Dev or from IE navigator i receive the following error message : Cannot open the database 'MyDB' login failed for user ServerNameASPNet.I use SQL Server Management Studio Express to give the user ServerNameAspNet permission to connet to the database but i still receive the same error message.I created a user with strong password within Management Studio with connect permission and attempt to connect from my application using SQL Server authentication i receive the error message : The user 'UserName' is not associated with a trusted connection for SQL Server.Note that when i use the Connect to Database tool in Visual web dev the connection success when i use Windows authentication but fails when i use SQL Server authentication with the same error message above.My OS is WXP Pro SP2 Thanks for any help
View Replies !
SQL Server Events Logged In As Windows Application Event
Hello Everyone, I am backing up my all the databases (around 50 servers and 500 database) using scheduled jobs. I backup my transaction log files at every two hours of interval and databases on daily basis. I have set option of "Write to Windows Application Event Log" - When job fails during the creation of job in the "Notification Tab" of Create New Job. As per documentation SQL server automatically records some of the events to windows application event log. After succesful completion of Log backup and DB backup, event gets logged in Windows Application Event Log. And when job fails, I get two events logged in the Windows Application Event Log file, one due to my setting and other automatically by SQL Server. Due to this Windows event log file is growing much faster and I have to clear it in every 3-4 days. My quesiton - Is there a way such that to get only failures event logged in Windows Application event log file and any successful backup jobs should not go to Windows application event file? Can any suggest some idea what should I do? I am using SQL Server 2000 with SP3 on Windows 2000 Advanced server. Some of my databases are still using Version 7.0/6.5 on NT. Thanks.
View Replies !
Is Possible To Let Windows Frame Work Call Your Application's OnQueryEndSession Last?
Hi All, When user logs off the machine, windows will send the WM_QUERYENDSESSION to every application, usually the application launched first will handle that message first. My question is if that is possible to let my particular application get the message last (handle it last) no matter when this application is launched. Since Explorer.exe is launched earlier than any user applications and it get the message last(?), I guess we should have a way to do it with our applications but don't know how. Any hint will be appreciated! Thanks - Gordon
View Replies !
SSIS Package Permissions (Windows Application Log) Question
Hello all, I have an issue where the DBAs have informed my group that they need to get to a model where an SSIS package which presently needs Admin perms on a box in order to write to the Windows Application Log, no longer needs those perms to write to the log. I am new to SSIS packages, though familiar with DTS packages (and ETL), so I'm wondering if their concerns (1) can be verified; and (2) if so, is there a better way to allow the package to write to the log without Admin perms (on the box). At the moment, the preference would be to do so without using .Net, in an effort to keep the implementation simple. Scenario: A single package is scheduled to run at a predetermined time. Once complete it writes to the Windows Application Log. Thanks in advance, Henry
View Replies !
How Can I Include SQL EXPRESS Sources In Windows Application Using VS2005
Hi, I have written a C# Windows application with VS 2005 using SQL Express which I included the SQL express in my project. I could publish the application. But when I try to run the application in a new computer which does not have SQL Express, it came back with a warning that says 'SQL EXPRESS needed Downloading the SQL Express' and starts downloading the SQL Express, and when it finishes the download then the application runs fine. My question is how could I inculde SQL express sources with VS 2005. Thanks. MK
View Replies !
How To Lauch Report Builder Tool From Windows Application.
Hi, We know that Report Builder can lauched in the following 2ways. 1. Using the following url http://localhost/ReportServer/reportbuilder/reportbuilder.application 2. Through Report Manager We have windows application (.net) and we would like to integrate and launch Report Builder from this application. What other ways you suggest. thnaks, ravi
View Replies !
Viweing Sql Server 2005 Reports In Windows Application
Hi, I want to show sql server reports in windows application. i code like this, ReportViewer1.ProcessingMode= ProcessingMode.Remote Dim userCredentials as New System.Net.NetworkCredential (€œdomain username€?,€? domain user password€?,€? Domain name€?) ReportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials= userCredentials ReportViewer1.ServerReport.ReportPath=€?folder name eport name€? ReportViewer1.ServerReport.ReportServerUrl = New Uri (http://servername/reportserver) ReportViewer1.RefreshReport() If i don't use network credentials it gives me unauthorized error. But exactly which credentials should we give for network credentials? We can not get domain user password at run time right? Or is any other way without using network credentials? Regards, Harshada
View Replies !
Application Cannot Connect To SQL Server 2005.
I am having a strange problem. I have an application that to connects to SQL Database in SQL Server 2005. When I run the application with Visual Studio everything works fine but when I deploy the application on my web server and then to access the site . I get an error : Login failed for user ''. The user is not associated with a trusted SQL Server connection. For some reason the application is not passing the user name . I have checked the IIS and authentication is set to Integrated Windows Authentication . My connection string is correct as well <add name="xxxxx" connectionString="Data Source=xxxxxx;Initial Catalog=xxxx;Integrated Security=SSPI" providerName="System.Data.SqlClient"/> I will appreciate any kind of assistance in this matter. Thanks
View Replies !
Connect A Report To An Application Database
I added a database named appdata to the app_data folder to hold temporary application data. I want to show this data in a report. I created a dataset and an object to select the data. I then created an report.fdlc and a report.aspx with a ReportViewer on it pointing to the dataset object. If I right click on the report.aspx and View in Browser, it work perfectly. But when I upload it to the server I get and browse to it I get (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified). The server does allow remote connections. So I am thinking it's my connection string of the fact that the server doesn't have Sql Server Express.? Here's my connection string. What am I missing here? <add name="appdataConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|appdata.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
View Replies !
Can't Connect To Sql Server 2005 From My Asp.net Application
Hi I can't connect to sql server 2005 from my asp.net web page. I seem to be able to connect to it when i run the application from within visual studio but i can't connect to it when i run the application from IIS.I am new to sql server 2005 express so please bear with me.The error message i get is: Cannot open database "Vets" requested by the login. The login failed.Login failed for user 'OSCAR2K4ASPNET'.I don't know where this user OSCAR2K4ASPNET came from but i looked in sql server 2005 and there he is. In the left hand pane I went to Security and then logins and found oscar2k4asp.net there. I went to the properties for this user and went to User Mappings. There was no tick next to my Vets database so I added one and ran the application from IIS. I also added the user to every single role in the vets database (including dbowner). I also went into the vets database itself and found the oscar/aspnet user and made sure he was added to every role. I ran the application again. This time i got a lots of different errors. If the page was trying to run a select procedure I got the error user does not have select permission. If the page was running an SP i got the error or user does not execute permission I have never had this problem before so I don't understand.Where did this user come from? Was he created automatically when i configured my database for membership and roles? How do i set up this user so he can access the databsae from IIS. The only way I could get the application to run from IIS was to go to Security - Logins for sql server and add the oscar2k4asp.net user to the sysadmin role. I find this very strange. Naturally i don't want to leave oscar2k4 in sysadmin. Please help :) I can't upload my website until i fix this Thanks, andrea
View Replies !
Connect To SQL Server 2000 Through An ASP.NET Web Application
Hi!I am going to connect to "SQL Server 2000" through an "ASP.NET Web Application". My development environment is "Visual Studio .NET 2003". In my "Toolbox" -> "Data", I drag a "SqlConnection" and drop on the page. It would automatically be named "SqlConnection1". In its "Properties" -> "ConnectionString" -> "<New Connection...>", I would enter my Server Name (SAMIEI), select "Use Windows NT Integrated Security" and Select the Database on the Server (Northwind). Then such Connection String would automatically be generated: "workstation id=SAMIEI;packet size=4096;integrated security=SSPI;data source=SAMIEI;persist security info=False;initial catalog=Northwind" Now, I may see "SAMIEI.Northwind.dbo" in the "Data Connections" row of "Server Explorer" with its all "Database Diagrams", "Tables", "Views", "Stored Procedures" and "Functions".Please take a look at the following code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try SqlConnection1.Open() Catch ex As SqlException Response.Write(ex.Message) End Try End Sub It would unexceptedly encounter such error: "Login failed for user 'NT AUTHORITYNETWORK SERVICE'" Please tell me the reason. I am much obliged to you for your attention. Regards!M.Sadegh Samiei
View Replies !
|
TRACKER
