TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server
Reload this Page Error executing extended stored procedure: Invalid Parameter
Register Forum Rules Getting Started! - Guide Blog Videos Gallery Members List Mark Forums Read

Notices

Error executing extended stored procedure: Invalid Parameter

Microsoft SQL Server


Reply
 
Thread Tools Display Modes
Old 10-12-2007, 06:24 PM   #1
nikolakg
Guest
 
Posts: n/a
Error executing extended stored procedure: Invalid Parameter
When I try to connect to sql server instance I received this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Error executing extended stored procedure: Invalid Parameter
Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
Server, Error: 22001)


when i click refresh button i am able to see my schema, but i can't see the
properties of my base and any table properties. I receive error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

Error executing extended stored procedure: Invalid Parameter
Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
Server, Error: 22001)


------------------------------
BUTTONS:

OK
------------------------------


also the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
locked and can not be opened.

After a reboot the key is now readable and the 2005 instance can be
connected to without these messages.
But after a while it does it again.

does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 03:53 PM   #2
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 03:53 PM   #3
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 04:04 PM   #4
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 04:04 PM   #5
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 04:31 PM   #6
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 04:45 PM   #7
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Old 11-12-2007, 05:14 PM   #8
John Bell
Guest
 
Posts: n/a
RE: Error executing extended stored procedure: Invalid Parameter
Hi

My guess is that you have some group policy or Anti-virus/ISD system that is
locking down this registry key.

John

"nikolakg" wrote:

> When I try to connect to sql server instance I received this error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> when i click refresh button i am able to see my schema, but i can't see the
> properties of my base and any table properties. I receive error:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot show requested dialog.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Cannot show requested dialog. (SqlMgmt)
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Error executing extended stored procedure: Invalid Parameter
> Error executing extended stored procedure: Invalid Parameter (Microsoft SQL
> Server, Error: 22001)
>
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
> also the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names is
> locked and can not be opened.
>
> After a reboot the key is now readable and the 2005 instance can be
> connected to without these messages.
> But after a while it does it again.
>
> does anyone have any idea what is going wrong?
  Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



< Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT +5.5. The time now is 08:20 AM.

Contact Us - TechTalkz.com Technology & Computer Troubleshooting Forums - Top

vBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2009, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional