SQL 2005 error code = 80004003: Invalid Pointer

2,190 pts.
Tags:
Database
Servers
SQL
SQL Server 2005
After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following error when attempting to launch the client side connection: Error Code = 80004003: Invalid Pointer The Program cannot start. Failed to connect to <databasename.mdf> on server <servername> (provider=SQLOLEDB.1;Initial Catalog = <dabasename.mdf>; Data Source = <servername>; Integrated Security = SSPI) The client is WinXP: the issue started while running SP2, and has persisted with SP3RC2 MDAC is 2.8x (as suggested by the program publisher I have adjusted the client sql.ini file to reflect the appropriate data source and server I have attempted to create a <programname>.udl file, which appears to be configuered correctly, as I receive a successfull connection after configuration and testing. Let me state that I'm not a DBA, but am (I believe) capable of following instructions..... Any and all assistance is appreciated
ASKED: April 24, 2008  9:21 PM
UPDATED: April 25, 2008  1:58 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can you query the tables from with the SQL Server Management tools?

Can you use the management tools locally? Remotely?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Pressler2904
    Mrdenny - (and all interested parties): Thanks for the reply - the issue has been resolved... To answer your questions, the connection was fine when queries were executed via the VM Ware console on the server itself, hence my statement that the database appeared to have been attached successfully. The resolution of the issues was so obvious (even to a non-DBA like me) that I probably should be assaulted with a clue-stick or two... When setting up the sql.ini file, for the "database name", I inserted the actual name of the .mdf file. What I should have done, and what fixed the problem, was enter the name of the .mdf file <alias> as created during initial database configuration. The client side piece of this commercial product leaves the translation between actual file name and alias to the SQL Server. What clued me in to the issue was the creation and configuration of a .udl file: after entering the server instance name, the database alias was made available in the "Select the database" dropdown area of the "Connection" tab. When comparing the SQL.ini file, I noticed the discrepancy, adjusted the .ini file and **poof** connection established. As I mentioned, the issue has been resolved and connectivity confirmed as of about 9:00AM this morning EDT Thanks for the assistance. pressler2904 (AKA poppaman2)
    2,190 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following