Online Query Tool SQL Server 2005

Feb 18, 2008

Hi,

I was wondering if someone could help advise me.

Basically i have a client who wants to upgrade from a desktop ms
access solution to a web based system using MS SQL Server 2005.

Basically their main concern is in losing the ability to write ad-hoc
queries using the MS Access query manager. I can obviously write
static reports etc but whats the best way to give them some
flexibility ??

Can anyone advise me if there is any product that can do this for SQL
Server 2005 (which im sure there is) but will work in a web
environment.

Or does anyone have any helpful ideas ???

all help / advice greatly appreciated

CG

View 1 Replies


ADVERTISEMENT

Query Tracer Tool For SQL Server Express 2005

Dec 3, 2007

Hi guys,
I am using DLinq with SQL Server Express 2005 and I need to install some kind of user interface which shows me a trace of the SQL statements sent. I would like to see them in real time (I won't like to inspect a log after :-).
I remember that there was something similar in SQL Server 2000 full edition, but I requiere the same functionality in the Express version now.

Could you tell me if there is some tool to do that?
Thanks in advance,
Erich.

View 1 Replies View Related

Recovery :: Server Cluster Resource Fails To Come Online And Pending Online State

Nov 3, 2015

We have SQL cluster installed on top of windows cluster on VM environment. Node1 and Node2 under Windows Failover Cluster. SQL instance is currently on node2 the instance is up and running, but SQL Cluster service remains online pending and it restarts the instance on every 5 minutes.

SQL Browser service are running successfully.TCP/IP ports are enabled and configured.If we start the SQL server agent it is on for seconds and stopped immediately  .Cluster Service is attempt to connect to the SQL service every few minutes (setting in SQL cluster resource) for the IsAlive check, if this fails then the SQL resource is restarted even if the instance was online. Hope this is what happening exactly.

[sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].  (268435455)
00001024.00053314::2015/10/30-19:57:50.772 ERR   [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)
00001024.00053314::2015/10/30-19:57:50.772 ERR   [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] ODBC Error: [08001] [Microsoft][SQL Server

Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books

Online. (268435455)
00001024.00053314::2015/10/30-19:57:50.772 INFO  [RES] SQL Server <SQL Server (SIMAH_COMMDB)>: [sqsrvres] Could not connect to SQL Server (rc -1

View 5 Replies View Related

Books/Online Resources For SQL Server 2005?

Jul 16, 2007

Could some body suggest some good books and online resources for:
1. T-SQL Intermediate level/Advanced
2. SQL Server 2005
Thanks a bunch
Csharplearner

View 1 Replies View Related

Installing Sql Server 2005 Books Online

May 3, 2008

I am trying to install sql server 2005 books online but I am failing and I am getting this message
"This installation pakage could not be opened.Contact the application vendor to verify that this is a valid windows installer package"

am I doing anything wrong or has the version of books online changed? Do I have to install anything else before installing it? or does my operating system not support it?

Thanks


View 4 Replies View Related

SQL Server 2005 Books Online (May 2007)

Nov 6, 2007

I downloaded and tried to install the file "SqlServer2K5_BOL_May2007.msi" and got a message:
"This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows Installer package."
Please advise.

View 3 Replies View Related

SQL Server 2005 Books Online - How To Install?

Oct 23, 2007

Can some one give me detail instruction to installing the SQL Server 2005 Express Books Online.
I am new to SQL Server and want to install the MS training material.

View 3 Replies View Related

Working With An Online And Office SQL Server 2005 Database

Sep 18, 2006

I'm not experienced with SQL Server 2005.I've got a live copy of my database running on the web server.I've got another copy running on my desktop that I make changes to.Whats the best way to sync between the two so:1. I don't have to take the application offline2. I don't loose any data from the live database3. But I can implement changes to tables and/or add new tables 

View 1 Replies View Related

Moving A SQL Server 2005 Database From The Local Network To An Online Server.

Mar 7, 2006

Hi All, first post.

I have done a bit of searching around and cant find a clear answer to this question.

Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)

It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.

The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.

This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.

Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.

So the only thing that would change would be a new connection string in the application preferences?

Or am I living in a dream world, because nothing is ever that simple.

One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.

Thanks for any advise you can give.

Mark

View 2 Replies View Related

Importing Online XML File Into SQL Server 2005 Tables – No Data Transferred

Oct 12, 2006

Does anyone have any great suggestions on how I can import an online XML file into an SQL 2005 table?

So far I tried to accomplish it with SSIS Data Flow Task where my source is XML Source (Data access mode: XML file location; XML location: URL, Use inline schema = True). This set up properly identified the columns to be imported.

I used Copy Column data flow transformation task to load data to OLE DB destination table that has same structure.

When I run the task it does execute with no errors, however the table remains empty. It looks like I am failing to read the actual data.

Do you have any suggestions? I am willing to go around this approach with stored procs/com/you name it €“ just make it work!

Thanks a lot for your help!
LoveDanger

View 6 Replies View Related

Adhoc Query Tool For Sql Server ???

Oct 31, 2005

Hi !!We are developing an application where we need a Query tool which allows customer to do Ad-Hoc or random query.. something similar to lets say http://salebyowner.com/advancedSearch.phpWe have few more options than this on which customer can do search. I don't think dynamic query in C# code or something like that is going to help me. Am I right? Do we have to use any type of query tool or something for doing this?

View 6 Replies View Related

Where Is SQL Server 2005 Diagramming Tool?

May 19, 2005

I currently install SQL server 2005 CTP and I couldn't find the diagramming tool which used to view the conceptual model of the database structure, relationships and entities visually. This diagramming tool feature is available in SQL server 2000, however I couldn't find in SQL server 2005. Anyone would like to give me some recommendations or show me where this feature is hidden?  

View 1 Replies View Related

32 Bit BI-tool Connecting A 64 Bit SQL Server 2005

Mar 28, 2007

Hi,



I have Cognos 8 as BI-tool installed on a Windows 2003 Server, both 32 bit. We are thinking of using a 64 bit SQL Server 2005 with 64 bit Windows 2003 Server as database server for a new data warehouse.

Can I use the 32 bit SQL Native Client on the Cognos server for connecting to the 64 bit database server? If not, how should I set this up?



Thanks in advance for your help.



Kind regards,



Albert de Ruiter.



View 3 Replies View Related

Query/Reporting Tool For SQL Server Tables

Oct 6, 2005

Just a general question about any recommendations for a third party tool that would allow setting up a data-dictionary against SQL Server tables and a user could go in and build their own queries, reports. Perhaps they could save their query/report definitions for reuse. Other nice to haves - ability to output to PDF and export to XLS. Would prefer web interface, but can consider desktop as well. Any immediate recommendations?

Thanks.

View 6 Replies View Related

Cannot Connect To SQL Server 2005 DB From ASP.NET Configuration Tool

Sep 25, 2006

Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: 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) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.

View 4 Replies View Related

SQL Server 2005 && 2000 Tool Compatibility

Jan 31, 2006

Can someone tell me if I can use the Gui tools which come with SQL Server 2005 against 2000 databases ?

View 1 Replies View Related

What Is A Good Tool For Modeling A SQL Server 2005 Database?

Nov 20, 2006

Hello,

I need a tool that will let me model a SQL Server 2005 database and then generate the tables, constraints, etc. from the model. I've never used a modeling tool so my knowledge is quite limited. I don't need to model or reverse engineer an application - my sole concern is on the SQL Server database side. I'm not concerned if the tool integrates with Visual Studio. And, of course, price is one consideration.

Are there any good tools that I should look at?

Thanks,

BCB

View 3 Replies View Related

SQL Server Service Broker Admin Tool For SQL Server 2005 RTM

Dec 27, 2005

Back in July I released the (then) latest version of SsbAdmin. For you who
don'r know what it is; it's a tool which allows you to graphically administer
SQL Server Service Broker.

I have now uploaded a new version which is compiled against the released
versions of SQL Server 2005 and .NET 2.0.

You can download it from here: [0].

After download, un-zip to some directory and read the README.doc file.

[0]: http://staff.develop.com/nielsb/code/ssbadmin.zip

View 2 Replies View Related

To Include Image In SQL Server 2005 Express Reporting Tool

Mar 13, 2007

Hi, I have a field in database that keep the image location. How to display the image in the report ?
Any idea.
Thanks.

View 2 Replies View Related

SQL Server 2005 Express And ASP.NET Web Site Administration Tool Problem.

Mar 31, 2006

I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express.  I ran the aspnet_regsql and it created the aspnetdb database.  But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work.  I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail.  My SQL Server is installed on the Default Instance.  Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?

View 1 Replies View Related

SQL Tools :: How To View MS-Access Query Command In Server Profiled Or In Another Tool

Aug 12, 2015

I would like to be able to view the complete SQL command that is sent from a Microsoft Access query which has linked SQL Server tables through ODBC, and the query also has some VBA functions manipulating and filtering data.I tried using the SQL Profiler to view the sql command send to SQL Server but all I see is the simple query format and some of the fields. I don't see the fields that have a VBA function such as trim(fieldname) etc in the column. And If I use a VBA fucntion in the Criteria then nothing shows up in SQL Profiled under the TextData column.How can I see the complete SQL command sent to SQL Server?

View 2 Replies View Related

Online/Offline Application That Must Synchronize With SQL 2005

Mar 10, 2007

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 3 Replies View Related

Gui Query Tool

May 27, 2004

I'm looking for suggestions on what Query tool to use on SQL DB's for a group
of people who are used to creating ACCESS QUERIES. I'm having trouble running SQL as the backend and ACCESS as the query tool to run ANALYSIS.
TIMEOUT issues and such. So, I thought we might as well use the SQL tools.
Any suggestions...

View 5 Replies View Related

SQL2005 Query Tool

Jul 21, 2007

I had SQL200 query analyzer loadded on a machine but it crashed.

Culd find CD. We decided to load SQl Server Manager sudio express from a sql 2005 CD. THe problem is that wen running queries with it, it puts some strange characters in the output. They arenon-printable characters so you don't see them

when you edit them in notepad. I have an editor that allows you to edit different

modes. I looked at the file in hex mode and found the characters there at the beginning of the first record. I just want the results in the result pane of the query to save as a regular ASCII text file comma delimited. THis same script was used successfully

in SQL2000 query Analyzer. Can anyone help?

View 2 Replies View Related

Free Query Tool From AgileInfoSoftware

Aug 17, 2005

AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.

The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements

To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.

View 1 Replies View Related

Looking For Browser-based Query Tool

Feb 2, 2005

Does anyone know of a vendor who provides a packaged application that allows a user to pass T-SQL commands from a browser, to our IIS web server, to our SQL Server database?

Thanks!!!

View 1 Replies View Related

System Performance Status Using Query Without Any Tool?

Dec 24, 2002

Hello,
I just wanted how we can find the system performance without using tool like performance monitor or profiler.
I just need the query like equalent to peformance monitor for see the systmem status of CPU ,IO ,Memory and etc..
Thanks,
Ravi

View 2 Replies View Related

The Best SQL Query Tool To Visualize Data Relationship

Nov 29, 2005

Another marketing campaign :eek:

View 1 Replies View Related

Register Online Sql Server

Jul 18, 2007

Hi, here is my problem



I am trying to conncet to an SQL Server that is on the net. The name of the server looks like : sqlServer.TheCompanyOwingIt.Com and it listens to port 2433

I am opening enterprise manager and trying to connect ,giving the name of the server and the credentials but no luck. I also tried opening hte client Network utility , created an alias for that server, specifying 2433 as the port but no luck again. Finally i tried to change the port of my sql server to be 2433 (instead of 1433), no luck again !!! Any ideas ? (there is no firewall running on the PC, but there is a router which might (?) cause the problem ? (i tried to port forward 2433 , but i am not sure if i did it correctly).



Any ideas, suggestions will be greatly appreciated

Thx in advance

Theodore

View 5 Replies View Related

Needs A SQL 2005 Data And Schema Compare Tool

Mar 12, 2008

Just wondering if there are any tools available for SQL Server 2005 which allow the comparison and scripting of data and schema between two databases. This is so that I can migrate between Dev, QA, and Live easily.

A free tool would be best please..

Thanks in advance.
Gaj

View 11 Replies View Related

SQL 2005 RS Configuration Tool - Encryption Key Error

Mar 9, 2007

I have SQL 2005, and Reporting Service has been uninstalled and reinstalled,
go through each step of confiugration until Encryption Key, for some reason,
the backup button is grayed out, only "restore" button is clickable, as well
as Delete, but we never backup the key before, so this is really strange
since we do not have backupkey, so we cannot restore.

we tried "Delete", then we got the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
value for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()

Browse report manager and reportserver also got the same error, run
rskeymgmt -d, does not help either

Any suggestion?

Thanks
Don

View 10 Replies View Related

SQL 2005 Express, Studio Management Tool

Sep 30, 2006

I have just downloaded VB Express, that comes with SQL Express



In order to manage and use SQL databases it seems I have to use SQL
Studio Mgt Tool. But, where is it? I can only see Configuration Tools,
but not any Mgt tool or DB Engine......



Maybe my installation is incomplete?



thanks

View 3 Replies View Related

Is There An Online Remote SQL Server I Can Test Against?

Jun 5, 2006

HiI am trying to connect an application to a remote sql server database, however it does not appear to eb configured for remote connections. Does anyone know a connection string of a database I can connect to , soem sort of learnsers database sort of idea ?Thank you.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved