I have a bunch of reports that I need to display. I've designed the reports using the Report Designer. Basically what I want to happen is to view the reports in local mode with the report viewer, but have them hit the database to get the values. I've designed them all with the database, I just don't want to go through all the hassle of setting up a report server. Plus, I've got a demo later this week so time is kind of a factor. Is what I'm trying to do possible? I really need help as the demo is this week
Thanks for the info but I am interested in designing and running local reports in a windows form. I have not been able to find correct documentation on how you define a schema that can be used to create an rdlc file for design of a report that uses a datasource that is set at runtime. Specifically, I would like to use business objects that return a data table in a get method.
Hi, My reports are deployed on reporting server installed on my machine. Now i want to access the reports on other machines which are on local LAN along with my machine. When i try to access reports from some other machine browser gives error page not found. Can any one tell me how to do this.
I'm having a nightmare issue with an application we sell.
The system is a three tier system. We have world wide about 40 installations.
The system uses MS reporting services to produce reports. All bar one of the reports are server based reports. While the remaining one is kept local for performance reasons, as it prints a small label in high quantities.
Now this local report is working fine except in one sistuation.
One of our customers has 8 of our systems. All 8 are clones. The client machines were ghosted to ensure everyone got the same. The databases all started off identical. The Server software is all identical.
However.. one of these systems is about once a week throwing an exception when it goes to print this local report. "An error occured during local report processing."
99% of the time it prints fine. Once the exception is thrown, the only way to make it work again is to quit out of the application and reopen it, where upon it will start to work again.
All other information returned is soley stack traced from our program, pointing out the button that caused the report to attempt to render and fail.
Here in lies my problem.
I have had the client machine rebuilt from ground up. The server software has been checked and is definitely identical to everyone else's.
I've taken a copy of their database and spent days trying to reproduce the exception with no success on our machines. I've logged in remotely and spent hours working on their system to force the issue with no success.
I've also tried cutting the label down so that no fields are displayed, but the exception still remains...
The developers of the system have not been very useful. The store staff are very fed up of ringing me and saying that big red error message is up again!
Any ideas would be highly appreciated. This has been going round in circles since december.
Do local reports show any more detailed logs anywhere, like the Server based ones?
I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
Being a very novice SQL Server administrator, I need to ask the experts a question.
How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?
I have database on localhost and i want to show this data on my website. I want to create a database online and want to sync with Local Host. Can it be possible syncing data automatically after some interval?
I am trying to use the Import Wizard to setup a daily job to import new records based on an ID field (PK). The source database is remote and a replica. I am inserting new records to update my table called the same thing. Both are SQL Native Client
Code Snippet select * from [CommWireless].[dbo].[iQclerk_SaleInvoicesAndProducts] as S1 join [IQ_REPLICA].[dbo].[iQclerk_SaleInvoicesAndProducts] as S2 on S1.SaleInvoiceID = S2.SaleInvoiceID where S1.SaleInvoiceID > S2.SaleInvoiceID
When I parse the query, I keep getting an error message.
Deferred prepare could not be completed. Statement(s) could not be prepared. Invalid object name 'IQ_REPLICA.dbo.iQ_SaleInvoicesAndProducts'. (Microsoft SQL Native Client)
Anyone know an easy why to get this to work? Or should I add a create table to verify new records?
I'm using SQL Server Management Studio Express and I'm trying to figure out how to copy a table(s) from my local database to my web hosting database. I know how to do it in 2000, but it's completely different now. Is this feature not allowed on SSMSE? If so, then how do I deploy database tables to a web host?Also, how do you add local database(s) to SSMSE? I tried to use 'attach database' in SSMSE and it wouldn't allow me to navigate to My Documents folder where the database resides. Thanks...
I have my first small SQl Server 2005 database developed on my localserver and I have also its equivalent as an online database.I wish to update the local database (using and asp.net interface) andthen to upload the data (at least the amended data, but given thesmall size all data should be no trouble) to the online database.I think replication is the straight answer but I have no experience ofthis and I am wondering what else I might use which might be lesscomplicated. One solution is DTS (using SQL 2000 terms) but i am notsure if I can set this up (1) to overwrite existing tables and (2) notto seemingly remove identity attributes from fields set as identities.I know there are other possibilities but I would be glad of advice asto the likely best method for a small database updated perhaps onceweekly or at less frequent intervals,Best wishes, John Morgan
We have a SQLSERVER database that is replicated to many users.We are currently in an expansion phase where we need to make changesto the server database. Each time we rollout a new release, we aredeleting the local replicating database and recreating.Is there any way to automatically transfer the changes from the serverto existing local database without deleting?
How do I insert data that I have collected in a local database onto a table on my online ie hosted database which is on a different server?
At the moment I am just uploading all the data to the hosted DB but this is wasting bandwith as only a small percentage of data is actually selected and used.
I thought that if i used a local DB and then update the table on my hosted DB this would be much more efficient, but I am not sure how to write the SQL code to do this!
Scenario: In general user will take database backup from database server to local system. User perform some changes to his local database based on his requirement. Again user connects to database server and click on update, local database should update to server database by informing each record status to the user. ex: record 1 updated / call closed do you want to update?
Here local database is going to be Pocket pc database and server database is on SQLDatabase. Can any one suggest best way to implement this feature in Windows Pocket pc, c#. I would appreciate your reply.
I use this way to call my connecting string , but I can't connect to my local DataBase , I trid to modify the propetry.config to coneect to other DataBase on other Server it works only when Connecting with my Local DataBase , it not work...
this problem have been troble me more than 3 weeks... ask many people no one can resolve this problem... when I am at home . I can't work... because I can't connect to the Server when I'm in office..
After restarting the machine, the sql 2000 won't start.
- I'm using local (no domain) - administrator account - sql agent is started, but cannot connect
a connection could not be establish to (local) please verify the sql server is running and check your...
sql log below:
2008-02-07 11:34:53.04 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2008-02-07 11:34:53.04 server Copyright (C) 1988-2002 Microsoft Corporation. 2008-02-07 11:34:53.04 server All rights reserved. 2008-02-07 11:34:53.04 server Server Process ID is 3088. 2008-02-07 11:34:53.04 server Logging SQL Server messages in file 'C:Arquivos de programasMicrosoft SQL ServerMSSQLlogERRORLOG'. 2008-02-07 11:34:53.06 server SQL Server is starting at priority class 'normal'(2 CPUs detected). 2008-02-07 11:34:53.14 server SQL Server configured for thread mode processing. 2008-02-07 11:34:53.17 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2008-02-07 11:34:53.17 server Attempting to initialize Distributed Transaction Coordinator. 2008-02-07 11:34:55.21 spid4 Starting up database 'master'. 2008-02-07 11:34:55.48 spid4 Server name is 'SUPORTE_SERVER'. 2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 23 2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 31 2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 32 2008-02-07 11:34:55.48 spid4 Skipping startup of clean database id 34 2008-02-07 11:34:55.48 spid5 Starting up database 'msdb'. 2008-02-07 11:34:55.48 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2008-02-07 11:34:55.48 spid6 Starting up database 'model'. 2008-02-07 11:34:55.49 spid8 Starting up database 'pubs'. 2008-02-07 11:34:55.49 spid10 Starting up database 'Northwind'. 2008-02-07 11:34:55.49 spid11 Starting up database 'Umuarama'. 2008-02-07 11:34:55.49 server SQL server listening on 192.168.0.101: 1433. 2008-02-07 11:34:55.51 server SQL server listening on 127.0.0.1: 1433. 2008-02-07 11:34:55.51 spid12 Starting up database 'adm_clube'. 2008-02-07 11:34:55.51 spid13 Starting up database 'Geracao'. 2008-02-07 11:34:55.51 spid14 Starting up database 'Sim_Externo'. 2008-02-07 11:34:55.51 spid15 Starting up database 'OPEN'. 2008-02-07 11:34:55.53 server SQL server listening on TCP, Shared Memory, Named Pipes. 2008-02-07 11:34:55.53 server SQL Server is ready for client connections 2008-02-07 11:34:56.25 spid6 Error: 9003, Severity: 20, State: 1 2008-02-07 11:34:56.25 spid6 The LSN (5:348:1) passed to log scan in database 'model' is invalid.. 2008-02-07 11:34:56.84 spid10 Starting up database 'SISCONTACOR'.
I have installed SQL Sever 2000 on my Windows XP Pro machine from theEnterprise Edition setup and it prompts you that only the client toolscan be installed. I wanted to have a local database as well So whatinstall should I have used to do so. Any information would greatly beappreciated.
I have SQL Server Management Studio. I can access some databases to which I have been given access to. How can I create a sample database to which I can upload excel files as data fields.
This is for testing purposes. Any help appreciated.
I have SQL database hosted by my ISP. Every now and again we log on and create new tables using user XXX1. After getting a backup of the database, I have restored it on my local machine. When running the application on local, I get an error because there is a new user in database called XXX1.
I would like to change the user from XXX1 to dbo on my local machine for all tables, stored procedures and views. How do I do this easily?
Hello, I need help with the setup of my sql server express 2005 and more specifically, with the location of the database files. Normally, database files are located on the c: drive. In my situation, being in a high school environnement, I need to have the database files on the network drive ... lets call it g:drive. The reason why it cannot be on c:drive is because this drive is protected using DeepFreeze. Now, I was able to change the location of the new drive as I went into the properties window of the sql server instance but when I try to create this new database, sql gives me grief ;-| I am from the group of people that thinks that to anything, there is a solution and am hoping that to this problem, there is hope of a solution. Can anyone help? Thank you
I have a local SQL Server database installed with Visual Studio .NET. I'm trying to create a SQL Server login ID to access a database on this local database. I gave it access to all of the databases with public (the one I'm using it also has DBO and execute permissions on all procs). When I try to login to it through SQL Server Query Analyzer (and also using an ASP.NET application), I get the following error:
Login failed for 'dbuser'. Reason: Not associated with a trusted SQL Server connection.
How do I set up a SQL Server login to access the database?
I dont know how this happened but my (local) SQL Server wont start. I cant access any of the databases. I just get this error:
'A connection could not be established to (local).
Reason: SQL Server does not exist or access denied. ConnectionOpen (Connect())
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.'
If I go to check the properties I get the same error. Im completely locked out. I looked at the folder and the database files are there, but I cant get to them through Enterprise Manager.
I have no idea how this problem could have happened. It just seemed to have stopped working. All my other databases can be reached (they are external). Could this be a virus or something? Can someone help me out on this one? I dont have a clue what the problem is, much less how to fix it.
I have an installation script and want to create a database based on some data in a table (config). Testing the script though I get a message:
Msg 170, Level 15, State 1 Line 12: Incorrect syntax near '@DBData'.
The relevant sql is:
declare @DBName varchar (40) declare @DBData varchar (40) declare @DBLog varchar (40) declare @DBSize int select @DBName = obj_txt from config where obj_nm='DBName' select @DBData = @DBName + '_Data' select @DBLog = @DBName + '_Log' select @DBSize = obj_int from config where obj_nm='DBSize' raiserror('Creating Database %s ....',0,1,@DBName) with nowait
Create Database @DBName on @DBData = @DBSize Log on @DBLog = @DBSize
I don't think there's anything wrong, apart from the fact I am using the local variables. Is this allowed on a Create Database statement? I haven't found anything in Technet that may help.
I have a bak file backup of my database which is a database backup done via SSMS 2008.I have imported this bak file to SSMS 2014 and working currently. The bak file is about 4 gb size.I need to transfer the entire database to remote server which is also sql server 2014. How can i do this efficiently?
Server Error in '/QuickStartv20/aspnet/samples/data' Application.
This is the error i am getting when i was going through the asp .net quickstart tutorials to learn using the databases. I have installed sql server 2005 on windows xp along with asp .net framework 2.0 on my system. i am student, so i dont how to configure a database. i went through a lot of tutorials of microsoft and macromedia but was unable to get the information requirred to create and access the database on asp .net and sql servers. they assumed that all know how to configure the database to work with the dynamic pages.
|||||||||||||||||||||||||
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "pubs" requested by the login. The login failed. Login failed for user 'MLHPRASPNET'.
|||||||||||||||||||||||||
this was another line from the error page.i need help in configuring the sql (and asp .net) server to use the database. i have been getting a lot these error pages when i tried to open (local)database related pages on my system.
i am very much thankful to any help given in this regard.
This is regarding general protection of a database hosted on a network. I am developing a database application for my college library using VB.NET, that will reside on a network. For some reasons, I did not want to hardcode the Database location in the application. Instead, when a user logs in, he can choose the database location using a folder browser control, if the location has changed.
Now, I realize that for this, I have to put the database in a shared folder, which makes it quite vulnerable. Having pondered over the problem for sometime, a solution that comes to my mind is to place a Text file in the same shared folder that always contains the correct path of the database. When a user chooses that folder, I will read the actual path of the database from the text file, and move the database to a non-shared folder. I haven't yet implemented this approach, but felt it better to consult someone before. So, would this approach work, and is it a good idea. For information purposes, I consider it important to mention that the database is in MS Access. I know this is not a place for discussing it, but this is a general security concern. So, I thought people would not mind answering it....
I am trying to run MS SQL Server Management Studio Express. According to what I read, I can connect by selecting Database engine, then on server name, I put my computer name sqlexpress. I am using Windows Authentication. Every time, I get:
TITLE: Connect to Server ------------------------------ Cannot connect to kennethsqlexpress. ------------------------------ ADDITIONAL INFORMATION: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------
What am I doing wrong? Thanks for helping me to stop pulling my hair out.
I'm having a problem right now. I'm trying to create an offline copy of a database(live) in my local machine. The database is maintained in a different server machine and I want a copy of the particular DB as an offline copy.
The problem is there's DTS feature in SQL Server 2000 but I don't find any such tool in SQL Server 2005 edition. Can anyone please guide me on how to do this process?
