473,386 Members | 1,679 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Could not find stored procedure 'master.dbo.sp_get_ptaai'

1
Hello there

I am loosing my time since a few days trying to install a CRM (ACT! 2008 version 10) software on a brand new HP notebook with Vista prof OS.

Ths installation do not show any troubles and works fine; the software installs also Microsoft SQL Server Express 2005 (the different services installed are SQL Server for ACT7, SQL server Active Directory Helper, SQL Server Browser and SQL Server VSS Writer).
SQL Service for ACT7 is in automatic mode and well started as vista starts (for local)
SQL Browser is in automatic mode also and starts as well as vista starts but in network mode.

Immediatly after ACT! installation (after restart), I want to chek the proper installation and wants to open the ACTDemo Database installed during installation and the following error appears Could not find stored procedure 'master.dbo.sp_get_ptaai'

If I want to create a new database I have the following SQL error message :
Act. D ata .ActDb.ActDb Exception: Could not find stored procedure 'imaster.dbo.sp_get_ptaai'. ---> Systenn.Data.SqlClient.SqlException: Could not find stored procedure 'rnaster.dbo.sp_get_ptaai'.

a System.Data.SqlClient.SqlCcnnecticn.OnError(SqlExc eption exception, Boolean breakConnection]

a Systenn.Data.SqlClient.SqlInternalConnection.OnErr or(SqlException exception, Boolean breakConnection)

a System. D ata. Sq ICI i ent.Td sP a rser.T h rowExc epti o nAndWa rn i n g (Td sP a r: erStateO bj ect stated bj]

a System.Data.SqlClient.TdsPa-rser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj]

a System. D ata. Sq ICI i ent. Sq I Data Rea d er. C o n su m eM eta Data Q

a System. D ata .Sq ICI i ent. Sq ID ata Rea d er. g et_M eta D ata Q

a System. Data. SqICIient.SqICommand. FinishExecuteReaderfSqlDataReader ds, RunB-ehavior run Behavior, String resetOptionsString]

a System.Data.SqlClient.SqlCcmmand.RunE^ecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean a sync)

a System. Data. SqICIient.SqICommand. Ru n Exec uteReader(Comrn and Behavior cmdBehavior, RunBehavior run Behavior, Boolean return Strea.rn, String method, DbAsyncResult result]

a System.Data.SqICIient.SqICommand.RunExecuteReaderf CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method]

a System.Data.SqICIient.SqICommand.ExecuteReader(Com mandBehavior behavior, String method]

a System. Data .Sq ICI i ent. Sq IC o m m a n d. Exec uteDb Data Rea d er(C om rn a n d B eh avi o r b eh avi o r]

a System.Data.Co mm on.DbCommand.Sys-tem.Data.IDbCommand.ExecuteReader(CommandBehavior behavior]

a Act. Data. ActD b. ActDbC o m m a n d. ExecuteRea d er(C o m m a n d B eh a vi o r beh avior]

--- Fin de la trace de la pile d'exception interne ---

a Act.Framewcrk.Security.SeionManager.GetActAccessPa ssword(String host, ProviderType provider]-

a Act.Frarnework.ActDatabaEe.ActDatabaseManager.Clas EicRestoreDatabaseAstString databaseName, String databaseHost, String databaseType, String newTargetFolder, String userLogOn, String userPas:^crd, String zipFile, String zipPassword, ProgressEventHandler prcgressHandler, Boolean shareDataba-se]

a Act.Framevyiork.ActDataba5e.ActDatabaseManager.Res toreDatabaseAs(String databaseMame, String databaseHost, String databaseType, String newTargetFolder, String userLogOn, String userPa^^word, String zip File, String zipPass-word, SupplementalFileManagersfMgr, ProgressEventHandler progressHandler, Boolean shareData-base]

a Act.Framework.ActFramework.RestoreDatabaseAs(Strin g databaseMame, String databa-seHost, String databaseType, String newTargetFolder, String userLogOn, String u^erPassword, String zipFile, String zipPasswc-rd, ProgressEventHandler progressHandler, Boolean shareDatabase]

a Act.UI.MaintenanceManager.RestoreData-baseAsTas-k.DoTaskQ

IS ANY OF YOU CAN BE OF ANY HELP !!!!

Thanks in advance for your time and comprehension,

Regards

Zaza
Oct 10 '08 #1
0 2733

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Norman Scheinin | last post by:
I have an Access 2000 database connected to a SQL Server and am trying to execute my first stored procedure. I created the stored procedure and verified that it works, but when I try to execute it...
1
by: Alvin | last post by:
Hi All I need opinions on how to approach my task. I currently have 3 tables: the master table, the archive and a temp table. MASTER: has 3 fields ProductID and ProductNo and Released ARCHIVE:...
4
by: Bruce | last post by:
I need to create a stored procedure in the master database that can access info to dynamically create a view in another database. It doesn't seem like it should be very hard, but I can't get it to...
1
by: Micah Gentry | last post by:
Is there any way to allow a user to use the xp_cmdshell extended stored procedure without giving that user execute permissions to xp_cmdshell in SQL server 6.5? Let me clarify. Lets say I (as the...
7
by: pkruti | last post by:
Below is a stored procedure i am working with and i am trying to drop the yesno_holding table if it exists but how do i add it back? Meaning i want it to drop if it exists but i want to add it back...
5
by: purushneel | last post by:
Hi, I work primarily on Oracle databases. I am trying to convert a recursive stored procedure written in Oracle to DB2. Does DB2 UDB v8.2 (Windows/AIX) supports recursive stored procedures ??...
6
by: Shiller | last post by:
I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database named "budget". When I run the stored procedure, it...
2
by: qwedster | last post by:
Folk! How to programattically check if null value exists in database table (using stored procedure)? I know it's possble in the Query Analyzer (see last SQL query batch statements)? But how...
3
by: Mirku | last post by:
Hello! I have this stored procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE . AS BEGIN
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.