Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher

|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error installing SQL Server Management Studio Express on Windows Vista RC1

Hello NG,

After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:

"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."

Where can I find more infos about this error-code?

Anybody knows this problem?

Thank in advance for every help.

You might want to try installing under rasied permissions for the user... Also from memory the install of the express products on vista had not been approved (Supported) and MS were working on it with the Newer SP for the express products. You might want to check it out with one of the guys from MS. Also if you could translate the error message to english it might help some of use read what is going on....

|||I′ve got the same error. I started a cmd-shell as an Administrator and started the MSI package from there. This works.

HTH
Alexej Kucher|||

Hi...

How can I start a cmd_shell as an Administrator.

thanks

|||Just right-click the command shell icon and choose "run as..." .Enter the admin credentials.

Error in SQL Server Management Studio Express when Attach DB

Hello

When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs:

TITLE: Locate Database Files - ORION\SQLEXPRESS


C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

OK - Button

And directly after that error, when I click the OK-Button from the error above, I receive the "Locate Database Files"-Windows. But there I see only one partition G from my harddisk(but I have C, D, E, F, G).

I can not understand, why I should not have the necessary security privileges (The path exists at all events). In the Object Explorer I see all my DB's. And I can access on every DB without problems.

How can I solve this problem and attach an existing Database?

Mike50

Hi,

the service accoutn SQL Server is running on needs the appropiate priviledges to attach the database. Even if you have the rights to access the share, this doesn′t mean that SQL Server has, so make sure that the account which can be seen under the properties of the server (or in the service control panel) is priviledged.

(Make also sure that this isn′t a network drive you are using while loading something, if you want to load from the load you have to use the UNC syntac rather than the mapped drives, that much easier)

HTH, Jens Suessmeyer.

|||Hello,

Thanks for your quick answer.

It isn't a network drive, it's local. In the windows explorer, in the SQL Server folders under properties-->security, there I have acces to all folders for everybody (I changed all folders to give access to "everybody2)! But is this the right place to give the privileges? I tried a lot of things but nothing happend.

Can you please explain me, where exactly I have to look under properties of the server and change?

mike50
|||I solved the problem!

In the SQL Server properties, I had for log-in the account "NT AUTHORITY\NetworkService" and this NetworkService had no rights to access the program files folder! So I changed it to "Local Systemaccount" and now I can attach DB's.
But is this a good idea to start the SQL Server Service with this account?

mike50
|||Ok, wasn′t this what is said ?

HTH, Jens Suessmeyer.|||

Jens:

Yes, it was "close" to what you said. But I am still having this issue.

I have the SQL Server (MSSQLSERVER) account running under an account named ".\mssql".

I have the SQL Server Agent (MSSQLSERVER) account running under the same ".\mssql" account.

I have given this user account full rights on my D:\MsSql\ directory.

I have my default data and logs directory configured for D:\MsSql\Data\

I still get this error popping up when I click "add" in the Attach Database dialog window.

Any other ideas?

It is not wise to run the services under Local System account, as he asks above.

Error in SQL Server Management Studio Express when Attach DB

Hello

When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs:

TITLE: Locate Database Files - ORION\SQLEXPRESS


C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

OK - Button

And directly after that error, when I click the OK-Button from the error above, I receive the "Locate Database Files"-Windows. But there I see only one partition G from my harddisk(but I have C, D, E, F, G).

I can not understand, why I should not have the necessary security privileges (The path exists at all events). In the Object Explorer I see all my DB's. And I can access on every DB without problems.

How can I solve this problem and attach an existing Database?

Mike50

Hi,

the service accoutn SQL Server is running on needs the appropiate priviledges to attach the database. Even if you have the rights to access the share, this doesn′t mean that SQL Server has, so make sure that the account which can be seen under the properties of the server (or in the service control panel) is priviledged.

(Make also sure that this isn′t a network drive you are using while loading something, if you want to load from the load you have to use the UNC syntac rather than the mapped drives, that much easier)

HTH, Jens Suessmeyer.

|||Hello,

Thanks for your quick answer.

It isn't a network drive, it's local. In the windows explorer, in the SQL Server folders under properties-->security, there I have acces to all folders for everybody (I changed all folders to give access to "everybody2)! But is this the right place to give the privileges? I tried a lot of things but nothing happend.

Can you please explain me, where exactly I have to look under properties of the server and change?

mike50
|||I solved the problem!

In the SQL Server properties, I had for log-in the account "NT AUTHORITY\NetworkService" and this NetworkService had no rights to access the program files folder! So I changed it to "Local Systemaccount" and now I can attach DB's.
But is this a good idea to start the SQL Server Service with this account?

mike50
|||Ok, wasn′t this what is said ?

HTH, Jens Suessmeyer.|||

Jens:

Yes, it was "close" to what you said. But I am still having this issue.

I have the SQL Server (MSSQLSERVER) account running under an account named ".\mssql".

I have the SQL Server Agent (MSSQLSERVER) account running under the same ".\mssql" account.

I have given this user account full rights on my D:\MsSql\ directory.

I have my default data and logs directory configured for D:\MsSql\Data\

I still get this error popping up when I click "add" in the Attach Database dialog window.

Any other ideas?

It is not wise to run the services under Local System account, as he asks above.

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?

|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?

|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in Management Studio

Have installed SQL 2008 db engine and client tools. Each time I attempt to return a resultset, I receive the following error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

This error occurs on any data access, such as:

select * from sys.columns

Does anyone know what might be going on?

And if you switch results to text instead of the grid, does everything work?|||

No, I receive the same error:

An error occurred while executing batch. Error message is: Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'.

|||Nope. Do you have more than one machine to do this on, or could you re-install SSMS?|||

Had same exact error message. Tried uninstalling and reinstalling just the client tools with no affect. Then completely uninstalled SQL 2008 (had both June and July instances) and reinstalled all of July. This "fixed" the problem. This is a frustrating one, I'd already submitted it as a bug earlier today. Perhaps it is related to partial uninstalls of just the client tools, since I had to uninstall the June tools to install the July ones the first time around. But doing a total remove of all of SQL 2008 seemed to do the trick.

Have Fun!

Ron

Error in installation SQL 2005 SP2 on 64 Bit Cluster.

I receive the below mentioned error message each time I try to install SP2 on SQL 2005 64 Bit Cluster:

Using PrevRegRootPath: Software\Microsoft\Microsoft SQL Server\MSSQL.2

GetServiceUserGroup failed for PLMCWSM01, 5

Error Code: 0x800706fd (1789)

Windows Error Text: The trust relationship between this workstation and the primary domain failed.

Source File Name: sqlca\sqlcax.cpp

Compiler Timestamp: Fri Feb 9 22:35:02 2007

Function Name: SetInstanceProperty

Source Line Number: 1223

MSI (s) (78!08) [01:05:21:864]: Transforming table Error.

MSI (s) (78!08) [01:05:21:989]: Transforming table Error.

MSI (s) (78!08) [01:05:21:989]: Note: 1: 2262 2: Error 3: -2147287038

MSI (s) (78!08) [01:05:21:989]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

Any Help on this would be highly appreciated.

Thanks

Anurag

Hi Anurag,

did you check this workarount: http://support.microsoft.com/kb/925976/en-us?

CU

tosc

Error in DTS

Hi When I try to convert from Prervasive V8 to SQL using an ODBC connection. I receive the error message..

ParseDisplayName failed: The specified module could not be found.

Could anyone advise what this error is? And/Or how it could be resloved. This is happing when I press actualy try to convert. The wizard will go to that point then stop.

Thanks!

DTS or SSIS? This is an SSIS forum. For DTS questions, please visit:

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

Error in create sp

hi every one

when i want to create a stored procedure that contain character " with a ado component , i receive this error message :

'Parameter object is improperly defined. inconsistent or incomplete information was provided.'

but if i create this procedure from query analyzer , this sp creates successfuly.

whyyyyyyyyyyyyyyyy? :mad:My guess would be that the client side (probably VB) code doesn't properly escape the quotation mark, and since the Transact-SQL doesn't need to escape the quote it isn't a problem there. I'd suggest that you post the VB code you are using so that we can see if that is your problem.

-PatP|||It's the QUOTED_IDENTIFIER setting on connection object vs. your QA. On the client side set this setting to be the same as in QA (in Connection Options menu item in QA).