I've been using MS Office Accounting 2007 (free version) and today the application says that the database cannot be connected to. Basically, the SQL service will not start or run. Could it be due to Symatec's firewall? Please help.
I recently installed Office Accounting 2007 Professional on a Windows Server 2003 machine with SQL Server 2005 (installed on an existing instance) and updated Office Accounting with service pack 1. However, after I have created the company file, other users were unable to open it. The error message was "The company could not be opened. Please ensure the SQL Server exists, the service is running and access has been granted."
Below are some of the stuff I had done, but still cannot solve the problem:
- Under "Manage users and roles", I granted full control to all users in the AD. - Made the company.sbc as well as the multiuser.sbc file available to everyone on the server's shared drive. - Granted full control to all users in the AD for the above mentioned shared drive. - Copied the company.sbc and multiuser.sbc files onto all client computers. - Ensured that SQL Server is running. - Checked the security options for the linked database to ensure all users have the necessary rights. - Enabled TCP/IP and named pipes as well as the port 5356 and have restarted the services. - Added port 5356 as an exception in Windows firewall on all client computers. - I even switched off Windows Firewall on the server just to eliminate this possibility! - Tried everything listed in http://support.microsoft.com/kb/910012
I still get that error message on all client computers!!! What else have I left out? God bless me...
Today we moved from 32bit to 64bit computing environment. 64bit Window server 2003 and SQL 2005 are now our playing ground. And 32 bit Office 2003 is also installed. Excel in Office program plays important roll in our mission.
One of our routine task is that step 1. get Excel data files from other websites and step 2. extract specific data from them and step 3. converting them into some type of data that can be compatible with SQL
Our problem occured in step 3. To convert data, we realised taht 64 bit excel driver, which we believe is not yet available, is required.
My questions are:
1. Is 64 bit excel driver (of office 2003 or office 2007) available now?
2. Is there any way OR IS IT POSSIBLE to use 32 bit excel driver with 64bit SQL 2005? If possible, please enlighten me.
I would appreciate it very much if anybody answer my questions.
I recently installed MS Accounting Express 2007 which also installed an instance of SQL Server 2005 but without the standard interface. But I want to install SQL Server Express 2005 as well. Can the two coexist? Is there a way to have both applications running on the same machine? I am asking before trying the standard SQL Express install. Thanks, Jim.
Hi, Is it possible to make Pivottables in Office 2000(Frontpage or Excel) and get data from cubes in Analyses Services SQL server 2005? If it works, are there any problems or do I have full functionality?
I am trying to use a new microsoft add-in for office 2007. I installed the 180 day trial version of SQL Server 2005 and according to the instructions it was suppose to be very easy to connect the add in to SQL. I am receiving an error message which I cannot find a resolution to using the readme file and wonder if you can help. Here is the url to the readme file and a screenshot with a summary of the add in.
ERROR MESSAGE Unable to connect to server 'localhost'. Please make sure user 'ARTIMUSArt McCarty' has at least read permission to some database on the server.
DETAILS ON TH ADDIN The SQL Server 2005 Data Mining Add-ins for Office 2007 allow you to uncover hidden patterns and relationships in your data and then put them to work to enhance the quality of your analysis.
The package you downloaded allows you to install the following add-ins:
Table Analysis Tools for Excel With a couple of mouse clicks you can detect and analyze the key influential factors for values in your data, highlight values that don't fit with the rest of the data. More
Data Mining Client for Excel Go through the full data mining model development lifecycle within Excel by using your spreadsheet data, or by using external data accessible through your Analysis Services database. More
Data Mining Templates for Visio Render and share your mining models as Visio drawings that you can annotate. More Thanks for your help. Art
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
i got this error msg when installing 2005 SQL Server components only on my system:
SQL Server Setup cannot continue because an earlier version of Office Web Components is installed on this computer. Uninstall Office Web Components, and then run installation again.
i could not find any info on this error. any ideas?
after i installed sql server 2005 DM add-ins, i tried using it with office 2007 so i choose (start---->all programs----->microsoft sql 2005 dm add-ins---->getting started) so the getting started wizzard was opened, i selected from it (use an existing instance of microsoft sql server 2005 analysis services that i adminster) because i already had a version of it installed on my computer. then i tried to connect to analysis services by selecting 'server name'=local host, an error appeared which is "unable to discover meta data on the server 'local host' . user noha needs to be adminstrator of the server to run the configuration tool". how can i be the adminstrator of the server?????????.........plz reply me soon,thanks in advance
I am trying to use a new Excel microsoft add-in using SQL server 2005. I installed the 180 day trial version of SQL Server 2005 on my local machine and according to the instructions it was suppose to be very easy to connect the excel add in to SQL. I am receiving an error message which I cannot find a resolution to using the readme file and wonder if you can help.
ERROR MESSAGE Unable to connect to server 'localhost'. Please make sure user 'ARTIMUS' has at least read permission to some database on the server.
I'm configuring now Reporting Services on SQL Server 2005 in Office Sharepoint Server 2007 integration mode. In the beginning of the process, I had already installed SQL Server 2005 with RS and Office SPS 2007. I used following guides to make further steps: How to Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)
How to Configure Service Accounts (Reporting Services Configuration)
How to Configure SharePoint Integration on a Standalone Server How to Configure the Report Server Integration Feature in SharePoint Central Administration
Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services
So I installed RS add-in for SPS, made RS configuration and almost all SPS configuration. I stopped with error
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. " in "Set server defaults" command.
My servers configuration is following: 1. Both RS and SPS are running on the same server. 2. I cannot change port of default web site, so I made different web site "Reporting services" under same web server with port 8086 (http://mtx-sps2007:8086/reportserver)
3. RS Windows service runs under domain system account that is a member of local Administrators group (account name sql2k5sps7) 4. RS Web service runs under NT AuthorityNetworkService account 5. Database connection configured using mentioned above account sql2k5sps7
6. Report Server Web Service URL in SPS is set to http://mtx-sps2007:8086/reportserver 7. Authentication Mode in SPS is set to "Trusted account" 8. My account, under which I make a connections through terminal services to SPS and RS servers and through http to reportingservices page is a member of local administrators group of both my PC and server. 9. I'm not familiar with SPS (honestly speaking, with RS too, but at least I learning this quickly, but SPS is out of my responsibilities scope) 10. ReportServer runs under separated app pool that runs under NT AuthorityNetworkService account
And now I'm fighting with this error on "Set server defaults" command. It's interesting that from my PC there is no credentials prompt when entering SPS administrations page and error is following: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode But from terminal client, connected to SPS and RS server, there is a credentials prompt (I enter my credentials) and error is as mentioned abowe: An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. Also, the same error I got when I tried to add a report to report viewer web part on SPS test page.
Can anyone help me with this? I would be greately appreciated to any help on resolving this issue.
Is there a way, in SQL Server 6.5, to collect information about number of transactions, CPU and memory usage, number of users connected etc. in a certain period?
I'm green on this networking stuff so any help is greatly appreciated.
I have setup my home computer as a server and assigned a static IP to it. I installed SQL Server 2005 Developer and allowed remote connections to it through the Surface Area Config tool, added port 1433 TCP and 1434 UDP to firewall's exception list, and started the SQL Server Browser service.
Now I can't seem to remote connect to this SQL Server from my office network. Is there something I'm doing wrong here?
Hi to all.. Does anyone know about some useful resources of programming Accounting and General Ledger applications..SQL scripts,books..etc. Thanks to all..
I have bcm with outlook 2007 and accounting express. when i create an opportunity in bcm, everything is fine. when i click the convert to quote button, it dumps all of the item information (quantity, name, description, price, tax....) into the description field in accounting. Then I have to copy each piece out of the description field into it's appropriate field in accounting 2007 express. Where is the mapping for these fields, so that I can map each one correctly? Is there something else i should be doing?
Hello, One of our requirements is to use accounting format for money. Samples can be found in Excel, just select "Accounting" from predefined format strings. With this format "$" is aligned to the left of the cell and amount itself to the right side. Unfortunately, I was not able to find "normal" solutions for this. Not "normal" solutions that I can imagine now. 1) Format string with hardcoded spaces. Actually this will not work with Excel export; 2) Add fake column before cell and add "$" here. Same issue, this will work with Excel export. Is there any way to do this without hacks?
I received an error when I tried to install SQL server 2005 enterprise edition trial software with office 2007. My operating system is Windows XP pro SP2. It could not locate an office file and recommended downloading office 2003 sp2. Will this fix the problem?
When I launch Outlook, it takes forever for the program to finally open. With any inbound email, it stops processing whatever is underway at the time....and frequently there is a 2-3 second lag between keyboard input and what appears on the screen. SQLserver is usually consuming upwards of 1-gb of memory....help. Mike
I am having a question as stated in the subject title, yes, when we want to deploy scorecards to reporting services, as the prerequisite, how can we install and register the scorecard custom data processing extension with the Microsoft reporting services server?
I am looking forward to hearing from you shortly and thank you again.
hello, i'm using sql200 and i am attempting to create a table that has an hourly-incrementing 'Date_Time' column, with a corresponding 'Total' column (which keeps a running total of values off of another table) . The code I am using right now is...
declare @date as smalldatetime
set @date = dateadd(yy, -1, cast(convert(char(11), current_timestamp, 101) + '00:00:00' as smalldatetime))
select dateadd(hh, i, @date) as Date_Time, sum(Subtotal) as Total
into #POGtable
from Pivot, OrderGroup
where
i between 0 and 24 and
CreationDate between @date and dateadd(hh, i, @date)
group by i
select dateadd(hh, i, @date) as Date_Time, 0 as Total
into #Ptable
from Pivot
where i between 0 and 24
group by i
select *
from #POGtable
union
select * from #Ptable p
where not exists(
select * from #POGtable pog
where p.Date_Time >= pog.Date_Time)
the solution is ugly, but the problem i'm having is that values for 'SubTotal' don't usually appear before 8 or 9 am. what you see above is me getting all the times (hours) that a subtotal present, creating another table with every possible hour in it (and with a 'Total' column as just zero), and then combining the two tables to create one flowing table over a 24-hour period.
there has GOT to be a better way to do this; the main point being that i want the sum( ) function to start adding up values immediately so i don't have to union two tables
I'm trying to generate a single record that shows the status of an accounting period for multiple groups. For a single accounting period they could all be the same, or all be different (open, closed, hold, etc)
What I want to do is select the accounting period with a group by that says if all the groups are in the same status, then that's the status. But if there are different status' for the period, I just want to have a single line that says 'Mixed' The query below returns 3 records, but I only want 2. I tried a CASE WHEN Having COUNT > 1 but it blew up with an aggregate subquery in a group by error.
DECLARE @AccountingPeriod Table (AccountingPeriod varchar(10), Status char(1), GroupNum int) Insert into @AccountingPeriod Values('2015-03','O',1), ('2015-03','O',2), ('2015-03','O',3), ('2015-02','O',1), ('2015-02','O',2), ('2015-02','C',3) Select AccountingPeriod, Status from @AccountingPeriod GROUP BY AccountingPeriod, Status
I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
I have a SQL 7.0 backend for a new DB of mine. This is the first time I have developed a SQL backend from scratch, so the problem may be my design. The problem may lie with my Access frontend (I have tried both 97 and 2k), but I am inclined to think not considering the behavior. On only one table (the master table no less), I cannot add records during business hours. I can add records to other tables and edit records on this table though. This troublesome table has a field indexed as unique that is not the PK (don't know if that has any bearing, but it is the only table in this DB that has that property). The adding records problem appears to be network traffic related because sometimes records can be added at lunchtime and definitely after hours. I currently only have 3 connected users. I had these problems with only one connected user, so the DB itself is not being strained by traffic. I often have more traffic on the DB after hours to avoid the problems. I have worked on the connection and network traffic angle for awhile, when I stumbled upon the bizarre part. If I add a record via a stored procedure and run this SP on the SQL query analyzer on the server (no network is involved) it is still slow to add the record (30 minutes or more). Needless to say this would equate to an failure on the front end. The same query will run in 0-3 seconds after hours! Does anyone have any clue how this could happen? I am stumped. I do have a budget for a consultant if I need one, but I need to find someone who has a chance to fix this problem. If you don't know the answer but can refer someone in the DFW area, I am in your debt.
Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS?
Help! My network support staff just upgraded my MS Office products from Office 2003 to Office 2007, and now I no longer get the "F5 = Run" option in Microsoft Visual Studio to run any of my SSIS packages that ran just fine yesterday, before the upgrade.
The "Debug" option does not occur in the menu choices across the top of the screen. (They are File, Edit, View, Project, Build, Data, Format, SSIS, Tools, Test, Window, Community, and Help -- no Debug.)
I store my packages in the File System. I can run many of them just fine, even today, with the Execute Package Utility. My problem occurs when I try to run them in Visual Studio.
Even if I make a simple, new package that moves a table from Access 2003 to SQL Server 2005, I see no Debug menu selection option when I am finished with the new package.
I figure it must be something simple -- I just don't know where to find it in the Visual Studio menu.
Most of the packages I am trying to run do not access Office files: they access dBase 5 files (database); they run processes on SQL Server 2005 servers. I realize that I may have to make some adjustments to connections to Access databases, should such databases be upgraded to Office 2007.
I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.
BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : SQL Server Database Services Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. -------------------------------------------------------------------------------- Machine : MICHAELTODD-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_MICHAELTODD-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation. Error Number : 29513 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Can anyone take me through synchronization of contacts within Business Contacts Outlook into Microsoft Small Business Accounts?
I run a stand alone PC with NO network. When SBA came SQL was also installed. Apparently you can synchronise Contacts within Business Contacts with SBA but both SBA & Outlook should work through the same SQL server.