Hi,
I am trying to install an evaluation copy of Dynamics GP on my laptop but it keeps giving me the following error:
msde failed to install. Return code 1603
Any idea what I need to do. I am not a techy so you'll have to be gentle with me.
Thanks
Raju
hello,
I was storing data on sql server with license for 60 days. before license expired I did:
in enterprise man. selected DB, right click, selected All Tasks,
selected Backup. Backed up to MSSQL7BACKUP DIR using same name.
then went to other machine installed sql server and from the enterprise manager did a restore DB with "restore on existing DB" option
the problem is that I try to give a user rights to the DB and I get error message: error 15023 user or role already in DB
any hints,
thanks
I downloaded the SQL Server Evaluation Edition from Microsoft.com in ISO form and burned a CD using Nero 7. I have tried to install the program, but I keep getting the error:
"the procedure entry point_create_locale could not be located in the dynamic link library MSVCR80.dll"
I have tried to reinstall Native Client and Setup Support Files with no effect... I have .NET 2.0 installed along with VB Express 2005 and VWB Express 2005... I am running on Windows XP Home SP2.
If anyone could help me, I would greatly appreciate it... I am stuck and can't get any work done until I get this program installed...
Hi,
Our front-end GUI person changed the system date one month back to avoid the expiration of the Servelet Exec software. After rebooting the system, MSSQL refuses to come up and the errorlog has the following message: "The evaluation period has expired". The version we had was never an evaluation version!
What's making it think that and is there a way to correct the situation?
Any help/suggestions would be greatly appreciated.
Thanks in advance,
Nishi
Hi,
I m using SQL Server 2000's 120 days evaluation copy for testing my application. The prob i am facing is that whenever the rows in one of the table increses beyond 10K it gets cleared up.
I could not trace the reason for this. Plz some one suggest a possible solution for the same.
Thanks in advance.
I've downloaded the enterprise evaluation copy of sql server 2005, patched it to sp2. I've fired up visual studio 2005 and opened a connection to my local database okay, (I've used windows authenication - though I'm not sure how to check whether I've got SA rights..).
When I open a stored procedure up, the breakpoints options are greyed out.
When I look in control panel/add programs, the version of Visual Studio is "Premier Partner Edition - ENU", if I look in the about of vs: it has installed products of sql server analysis services, integration services and reporting services
Looking on the web it says that I need visual studio 2005 professional to be able to debug sp's but on the features list for Premier Partner Edition, under the debug section it says "SQL"
Can anyone shed some light on this? Or is it the case that the eval copy of sql server 2005 ships with a version of vs2005 that precludes sp debugging !!!
ta
I installed the evaluation copy remotely and wish to register the product by entering its product key, would that possible since I don't have the cd in the box.
Matt
I can't deploy reports on Visual Studio2005 anymore. I say "anymore", because a few months ago, this went well.
After building correctly, VS Studio asks for a Login for Reporting Services via a popup window. I don't know what to enter...
In IIS ( version 5.1) , I configured Reports and ReportServer for integrated Windows Authentication.
In Reporting Services Configuration, I have the Windows Security set on Windows Account, with a username and password that I also use (withoud success) to deploy the reports from Visual Studio. Since the user is a domain user, I tried as login also the complete domain name : domainusername. Nothing helps, the popup "Login for Reporting Servies" appears again and again.
If I change the settings in IIS to allow for anonymous access ( machinenameIUSR_machinename), I get the error message that the permissions granted to that user are insufficient.
I also changed the Windows Service Identity into "Local System" and "Local Service"; with the same result.
In the Log file of Reporting Services, I also find following phrase :
"ReportingServicesService!resourceutilities...INFO: Evaluation copy:0 days left"
I don't know of there is a link between this and my problems
Can anyone help me in this ?
hi all
i'm currently installing MS Dynamics CRM 3.0. on the check page before installing is an error:
The Web Site for Installing SQL Server Reporting Services {0} uses an application pool of non-supported identity. Supported identity is Network Service.
so, when i open the properties (tab identity) of the reportserver under application pools in iis manager prefered "Network Service" is choosen, this should by right. do i made any failure? have anyone an idea, tanks
dear
riv
Hello Guys
can anyone please tell me where can i download a trial version of Microsoft Dynamics GP because i lost my cd , and microsoft.com tells me that the shipping will take about 6 weeks.
thanks in advance
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dsGP10FA'. (rsErrorOpeningConnection)
Setuser failed because of one of the following reasons: the database principal 'domainusername' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
I have a Table say
Table1
Col 1 Col2 Col 3
A X1 1
A X2 2
B Y1 3
C Z1 4
C Z2 5
( Col1 represents Entity names, Col2 represents there respective field name and Col3 represents the values of those field name)
How can i use the above Table1 and update table A, B, C
Ex:
Table A
X1 X2
1 2
Similarly Table B
Y1
3
and Table C
Z1 Z2
4 5
2 Question:
I was trying to use for each loop container. I am getting this error:
Error: Variable "User::ADOVar" does not contain a valid data object
I followed all the steps in the links
http://www.whiteknighttechnology.com/cs/blogs/brian_knight/archive/2006/03/03/126.aspx
and check out other sources but unable to track where the problem is?
Can some body help me out please
so we been running on a decent server now for a couple years. we just bought a new proliant dl380... faster, more ram, etc.
are there documents to reference to how to make the move successful?
-how to copy the log files and db data files onto the new partitions on the new server.
the actual solomon db is on an MSA 1000 and we plan on keeping it there.
so far on the new server...
-installed sql 2005
-dynamics sl 6.5
any documentation about taking solomon from old server to new server is greatly appreciated
i hear of a feature called TEMPLATES where you can save the data thats entered into any particular Dynamics SL screen and paste the data in to the same screen at a later time (saves time if there is data that is constantly inputed into the same screen over and over). my question is, where are the templates saved at on the hard drive? and can it be opened/edited in notepad or something else if say we want to make changes to the data before pasting/loading it back?
View 3 Replies View RelatedJust finished my first upgrade of 9.0 GP Dynamics and SQL 2005 - I am having lots of trouble with my users and there passwords. I have tried deleting them in SQL and GPS and start over but still cannot log in for the user - can you help me?
Thanks
cscheible
Hi,I have(had) an old Win2k Server server with about 30 web site databases(SQL 2000) that just went under due to hardware problems. Thankfully, Ihave backups of all the databases plus the MDF and LDF files from thehard drive.I want to move all of these sites and their data to a newer server(Win2003) running SQL2000.What's the best way to copy the database from the old server hard drive(now mounted as an extrnal drive to a local machine; I'm currentlyFTPing all of the web site directories from it to the new server)?Just upload the original data to the new server and then mount the MDFand LDF files within the new SQL server? Or do I restore the backupfiles in the new SQL2000?All of my previous data migrations have been DTS operations from onelive server to another, so no experience with either of the abovescenarios. I'll certainly have a lot more experience at one of them bythe time this weekend is through.Thanks for any help you can offer.
View 1 Replies View Relatedcan someone explain or link me to some reading material regarding best practice for setting up a sql server (solomon dynamics server)... we are using windows server 2003 R2 and SQL Server 2005. We have partitioned two drives... one 36GB for solomon Log files and 36GB for solomon Data files... our actual solomon database will be hosted on a huge MSA1000 device. Just wondering if this is the best practice for setting it up
View 5 Replies View RelatedHow to Add Reporting Services in Microsoft Dynamics CRM 3.0
View 8 Replies View RelatedHas anyone tried mirroring any of the Dynamics GP databases yet?
I am looking at using this and what to see if anyone has had any problems or even know if it can be done.
Thanks
I've noticed that indexes in my AX 2012 database get very fragmented very quickly. Is this normal and that I should just defragment them regularly or is there a possible issue here that needs investigated?
View 6 Replies View RelatedI have view something like
Create view All_employee
AS
SELECT Emp_Name, Emp_code FROM dbo.Employee
UNION ALL
SELECT Emp_Name, Emp_code FROM Emp_201402.Employee
But we have a different "Schema" for same table because we have archive table with same table name but with different schema name. Now we have req to make view which contain data of all table. But I can't seem to figure out how to do it in a view.
SET NOCOUNT ON
DECLARE @Count INT, @TotalCount INT, @SQL VARCHAR( MAX )
DECLARE @Schema TABLE ( ID INT, NAME VARCHAR(512) )
INSERT INTO @Schema
SELECT ROW_NUMBER() OVER (ORDER BY SCHEMA_ID), Name FROM sys.schemas where name like '%emloyee%' ORDER BY schema_id ASC
[Code] ....
Don' think that works.
Is this possible with a view or it other way to do it?
I can't find a Dynamics CRM topic and I'm hoping someone here will recognize the problem that we are having with integration between Dynamics and SRS.
Dynamics CRM server deployed fine. But we are having this problem when trying to install the Dynamics SRS Data Connector (an additional component that is supposed to be installed locally on the SRS server):
http://support.microsoft.com/kb/947060/en-us
Trouble is, the SQL server is a default instance, and SRS is hosted on a default web site listening on port 80. In fact, this is just a plain default install of SQL 2005 and SRS 2005 on one server. Nothing has been customized. And yet we get this error when we try to install SRS Data Connector on the local SRS machine:
"Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."
But the SRS is installed and running fine! I can even see and run reports that the Dynamics CRM Server install had created on the SRS server! And yet the setup program insists that SRS is not installed and it won't proceed with installation. It obviously runs some strange prerequisite check. (Devs: Why not just run a connect test to the SRS Web service?)
Environment: Win 2003 native domain on server A, Dynamics CRM 4.0 Pro on server B (Win 2003 VM 32bit), SQL 2005 SP2 and SRS 2005 SP2 on server C (Win 2003, physical server, 64bit). Data Connector failing to install on server C. I've even tried using a domain admin account, and went as far as running the installer in SYSTEM context. Still it fails.
I've also tried every variation of SRS and IIS configs that I know of (disabling SSL, enabling anon auth, etc etc etc etc...) I've gone as far as setting up a separate domain, separate SQL and SRS, and making a local Dynamics install, and STILL I got the same error while installing the Data Connector.
This is most frustrating. There's obviously something wrong with the method Dynamics CRM setup program uses to determine whether or not SRS is installed. But how come there isn't any info about this except for that one KB article that doesn't apply to us?
Please if you know anything post a reply! Thanks.
Doing a data migration from one CRM to another and need to get a listing of all entities in current CRM, together with fields and field types. OK, I got the XRMToolBox which gives me that, but I'm hoping there is a sql tool out there that will do the same, plus give me a count on each field of the number of entries in that field in the database.
View 0 Replies View RelatedI am running into a problem where Excel 2010 is freezing when I try to work with data coming from a Microsoft Dynamics AX 2012 R3 pre-built cube.
What is happening is that when I go to add a second dimension to my pivot table, excel locks up and becomes completely unresponsive for at least 2 hours. If I add the dimension to the table before the measure though, everything is fine.
For Example, I am trying to build a sales report with the product name and customer name as dimensions, and Sales as the measure. If I add the product name to my pivot table as a column and then sales as a measure, Excel will freeze when I try to add the customer dimension. However, if I add both dimensions to the pivot table first and then the measure, Excel seems to work fine.
I have created a stored procedure for retrieving column name, as shown below
CM_id, CM_Name, [Transaction_Month], [Transaction_Year], [Invoice raised date],[Payment Received date],[Payout date],[Payroll lock date]
Now I am trying to create a temporary table using the above generated coluimns from Stored Procedure with datatype.
Hi,
I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:
******************************************************************
Your current SQL Server is not a supported version.
Req: Microsoft SQL Server 8.0
Act: Microsoft SQL Server code name "Katmai" (CTP) - 10
You need to upgrade to SQL Server 8.0 before continuing.
******************************************************************
Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?
Assad
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
why I'm getting this installation error.
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
View 3 Replies View RelatedPlease help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
View 1 Replies View RelatedI get an error when trying to install the SQL Native Client. It
says it cannot find the installation package and to use a valid copy of
'sqlncli.msi'. I've downloaded the Express setup twice and get
the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced
Server. I am trying to test my installation and setup
procedures. This is not a production setup, just install testing
and documentation. I have allocated only 272MB to the VMWare
session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : SQL Native Client
Error : An
installation package for the product Microsoft SQL Server Native Client
cannot be found. Try the installation again using a valid copy of the
installation package 'sqlncli.msi'.
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Failed
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the
product Microsoft SQL Server Native Client cannot be found. Try the
installation again using a valid copy of the installation package
'sqlncli.msi'.
Error Number : 1706
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_MSXML6_1.log
--------------------------------------------------------------------------------
/* goal: dynamic evaluation of table rowplatform: sql 2000*/use northwind;declare @tbl sysnameset @tbl = 'customers'EXEC('select count(*) from ' +@tbl)/*Why the following dynamic evaluation would failIF EXEC('select count(*) from ' +@tbl) = 0PRINT 'no rows'Its variant,IF exists (EXEC('select count(*) from ' +@tbl)) = 0PRINT 'no rows'*/Do I know more sleep :)TIA.
View 31 Replies View RelatedWe're going to set up a demo of an Analysis and Reporting server. Does the Evaluation Edition of 2005 come with things like the BI studio, Management Studio and other client-side tools?
Also, does anyone know if the Eval Analysis Services is the full product (e.g. semi-additive measures, ...?)
Thanks a bunch
Hello,
Is there a way to find out many days you have left on the trial period or is there a way to find out when it was created. I get the feeling it will just not work one of these days and I'll have to figure out something on the fly.
Thank in advance