Migrating A SQL 7 DB to SQL 2005

We are planning on upgrading a SQL 7 Server to 2005 SP1. I ran the Update Advisor and one of the issues listed was that the Database Maintenance Plan would not work in Server 2005. The Advisor mentions a tool to use but not which one, which is my first question.

I went online and found some documentation regarding copying the database etc., however, when attempting to copy from the SQL 2000 (DB in SQL 7) to 2005 (I have SQL 2000 and 2005 on my machine) when I try and connect to the 2005 box, its listed as one of the instances but will not connect.

For grins and kicks I backed the database up in the 2000 environment and restored it on a test machine which is in 2005. The Advisor was correct, I am unable to create a Database Maintenance Plan, which I find odd. The Database shows up under the databases but will not show up in the list of db's to create a plan for. So, I attempted to create the jobs and alerts manually.

There has to be an easier way to do this, can anyone help?

Carolyn,
Try the Setup and Upgrade forum instead. You'll have better luck there.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1|||Thread moved from SSIS forum...|||I figured out how to get around this issue. I copied the databases using the wizard in 2000 between sql 7 and 2000, than I migrated the sql 7 db's into 2000. Once the db's are in 2000, open the server management suite in 2005 create a move package and move the dbs into 2005. If the package is created in 2005, you can create a db maintenance plan. I had test servers set up in both the 2000 and 2005 environment so switching wasn't a hassle.

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Migrate from old SQL ce Version in to new SQL Server/mobile

Hi all,

I'm in a middle of a server migration,

Old server:

SBS 2003 sp1 with SQL server 2000 and SQL server CE

New server:

SBS R2 with SQL server 2005 and SQL server mobile

I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.

In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?

If some one can point me on good way i appreciate.

Cheers,

For upgrading from SQL CE 2.0 to SQL Compact 3.1, this MSDN article might be useful:

http://msdn2.microsoft.com/en-us/library/bb286906.aspx

(Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition)

|||

Hi tks, for the replay,

But my problem is not on pocket pc side but server side.

On my old sever i use SQL CE so my pockets can get data from SQL server, now on this new SQL server version; we have this new option "SQL Mobile".

How cold i backup databases from old SQL server 2000 and how to restore on the new SQL server 2005.

If possible to backup and restore, were do i have to restore in Mobile or in SQL server 2005.

Regards,

|||

This 350 page document should keep you happy for a while (including "Upgrading replicated databases"):

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the following
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob

Microsoft.VC80.CRT.mui

I have SQL 2005, 64bit version installed with SP1. I am seeing the followin
g
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesnt have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:

> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bi
t
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs an
d
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesn’t have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Serve
r
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications
> <[url]http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx" target="_blank">http://msdn.microsoft.com/subscript...ps/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscript...rt/default.aspx>.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.

|||the copying worked for me aswell, thanks guy
|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.

|||the copying worked for me aswell, thanks guy
|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.ReportingServices.Designer

Hello all,

After reinstalling several times the MSSQL 2005 express, and the SP1 when I'm trying to create a project with the BIDS I've got an error:
Could not load file or assembly
Microsoft.ReportingServices.Designer
Version=9.0.242.0
..
or one of its dependencies. System cannot find the file.

But it exists!!!What can I do?

Many thx!

I've to inform that it looks like this file is already on my machine, and with the same version.

I tried to uninstall all SQL Server instances, NET framework 2.0 and all Vstudio (even 2003 version), restarted my machine and reinstall everything. The order was:

Vstudio for web developers Express

SQLExpress2005 Advanced

SQLExpress 2005 SP1

The installation was fine but the BIDS is causing me problems.

Sugestions?

|||

Finally solved by myself!

The order which I've done it is....

Uninstall all VStudio + SQLServer
Install .NET Framework 2.0
Install SQL Server 2005 Advanced in the default path (C:\)
Install SQL Server 2005 SP1 in the default path (C:\)
Install VStudio 2005 WebDeveloper in the default path (C:\)

Hope this helps to someone

|||

Hi:

Well, I guess the problem is the path of installation...

As most of us seems to be running out of space on 'C' Drive;

we tend to change the default path of installation...

During installation, if one sets all path to be the same drive; then the problem should disappear...

HTH,

|||

hi, i have encountered this same error message. I'm using VS 2005 Professional, it is a mature installation with several plugins and additional components, everything is customised the way i want it.

I cannot accept that i must uninstall VS2005 just to get the BI Dev Studio plugin working. That would represent a total failure of the VS integration in my opinion. all my SQL 2005 components are installed on C: so that solution wouldn't be relevant for me.

is there a response from MS on why this error message happens? and a proper way to resolve it?

hoping for an informative response :)
tim.

|||

hmmm. I have the same issue as you. I cannot uninstall my SQL server as it has production data running on it. I DID go through the painful process of uninstalling the VS 2005 installation and reinstalling it. It did not change a single thing. I am right back to the same error message.

Hope someone figures this out soon. Nothing on MS sites so far that I can find.

Brian King

|||

I had the same problem. I did my install on D: drive, but surprisingly it seems Reporting Services was installed on C: drive.

I solved the problem by copying the content of C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to the same directory on the D: drive. Seems to work fine.

|||I've had the same problem and re-installed VS2005 from scratch, tried to repair .NET 2.0 but all in vain. Confirm that the above copy solution worked for me. Thanks for info Guy.|||the copying worked for me aswell, thanks guy|||

Microsoft documents it's solution here http://support.microsoft.com/?id=823245 but it didn't work for me. After repairing I found the copy
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE to
D:\Program Files\Microsoft Visual Studio 8\Common7\IDE and it worked a treat!

Thanks!!

Microsoft.Jet.OLEDB.4.0 has not been registered. ?

Hi folks,
We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg,

: Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed. I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box. I am stucked. Any advice would be appreciated.

Sunny

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft|||

Does MS have some kind of plans for x64 based 64-bit .net apps to connect to Access 2007 or this a permanent solution?

|||

David Sceppa - Microsoft wrote:

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft

Would this also be revelant for OPENROWSET queries that use the driver? For example, the following select runs fine on my dev box (32bit SQL 2005), yet fails on our live box ((SQL 2005 64 bit)) .(it is part of a greater process that *should* bein in SSIS, but is being pushed in as a 'quick fix')

select [User Name],[Password], [Store Number] ,getdate(),''2008-12-31 00:00:00.000'',''1980-01-01 00:00:00.000''

from OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=c:\Username and passwords v1.1.xls'',''SELECT * FROM [staff login details$]'')

version info from live:

7 FileDescription SQL Server Windows NT - 64 Bit
8 FileVersion 2005.090.2153.00

Microsoft.Jet.OLEDB.4.0 has not been registered. ?

Hi folks,
We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg,

: Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed. I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box. I am stucked. Any advice would be appreciated.

Sunny

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft|||

Does MS have some kind of plans for x64 based 64-bit .net apps to connect to Access 2007 or this a permanent solution?

|||

David Sceppa - Microsoft wrote:

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft

Would this also be revelant for OPENROWSET queries that use the driver? For example, the following select runs fine on my dev box (32bit SQL 2005), yet fails on our live box ((SQL 2005 64 bit)) .(it is part of a greater process that *should* bein in SSIS, but is being pushed in as a 'quick fix')

select [User Name],[Password], [Store Number] ,getdate(),''2008-12-31 00:00:00.000'',''1980-01-01 00:00:00.000''

from OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=c:\Username and passwords v1.1.xls'',''SELECT * FROM [staff login details$]'')

version info from live:

7 FileDescription SQL Server Windows NT - 64 Bit
8 FileVersion 2005.090.2153.00

Microsoft.Jet.OLEDB.4.0 has not been registered. ?

Hi folks,
We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc). Last week, one of developer sent me an email with error msg,

: Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed. I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box. I am stucked. Any advice would be appreciated.

Sunny

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft|||

Does MS have some kind of plans for x64 based 64-bit .net apps to connect to Access 2007 or this a permanent solution?

|||

David Sceppa - Microsoft wrote:

Sunny,

It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider. There is no 64-bit OLE DB Provider for Jet databases. Your developer would need to use a 32-bit application.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft

Would this also be revelant for OPENROWSET queries that use the driver? For example, the following select runs fine on my dev box (32bit SQL 2005), yet fails on our live box ((SQL 2005 64 bit)) .(it is part of a greater process that *should* bein in SSIS, but is being pushed in as a 'quick fix')

select [User Name],[Password], [Store Number] ,getdate(),''2008-12-31 00:00:00.000'',''1980-01-01 00:00:00.000''

from OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=c:\Username and passwords v1.1.xls'',''SELECT * FROM [staff login details$]'')

version info from live:

7 FileDescription SQL Server Windows NT - 64 Bit
8 FileVersion 2005.090.2153.00

Microsoft Update & SP1

Hi,
I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
+ SP2 by using the Microsoft Update service.
No issues were noted during the upgrade process, and EXEC master..xp_msver
returns 9.00.2047.00 in the ProductVersion column.
However, subsequent running of Microsoft Update still shows SQL Server 2005
SP1 (KB913090) as needing to be installed.
Is this a bug with Microsoft Update, or does it mean that SP1 isn't
installed properly?
Any assistance gratefully received.
MarkHi Mark
It looks like you are on SP1 on that instance! Do you have multiple
instances on this machine? Did you check the installation's log files
(hopefully this is going to be in the same place as a manual installation!).
Have you rebooted since the upgrade?
If you are confident that it is upgraded then you could choose the option to
not show the update again when the update details are expanded.
John
"Mark Rae" wrote:

> Hi,
> I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pr
o
> + SP2 by using the Microsoft Update service.
> No issues were noted during the upgrade process, and EXEC master..xp_msver
> returns 9.00.2047.00 in the ProductVersion column.
> However, subsequent running of Microsoft Update still shows SQL Server 200
5
> SP1 (KB913090) as needing to be installed.
> Is this a bug with Microsoft Update, or does it mean that SP1 isn't
> installed properly?
> Any assistance gratefully received.
> Mark
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:34B375F1-9334-4141-B282-2FB06C8D4A44@.microsoft.com...

> Do you have multiple instances on this machine?
No.

> Did you check the installation's log files (hopefully this is going to be
> in the same place as a manual installation!).
Yes.

> Have you rebooted since the upgrade?
Yes. And reapplied the upgrade. And rebooted after that.

> If you are confident that it is upgraded
I'm as confident as I can be, I suppose. Other than master..xp_msver /
SELECT @.@.VERSION, is there anything else I can try...?

> then you could choose the option to not show the update again
> when the update details are expanded.
Yes, but I was loathe to do that until I'd at least asked in here. I've done
a Google search, and there doesn't seem to be anything about this specific
issue. Lots about SP1, of course, but nothing relating to problems with
applying it through Microsoft Update.
I should receive SP1 on DVD any day now as part of my MSDN Universal
subscription, so I'll reinstall it from that and then remove the option from
Microsoft Update if that doesn't fix it.

Microsoft Update & SP1

Hi,
I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
+ SP2 by using the Microsoft Update service.
No issues were noted during the upgrade process, and EXEC master..xp_msver
returns 9.00.2047.00 in the ProductVersion column.
However, subsequent running of Microsoft Update still shows SQL Server 2005
SP1 (KB913090) as needing to be installed.
Is this a bug with Microsoft Update, or does it mean that SP1 isn't
installed properly?
Any assistance gratefully received.
MarkHi Mark
It looks like you are on SP1 on that instance! Do you have multiple
instances on this machine? Did you check the installation's log files
(hopefully this is going to be in the same place as a manual installation!).
Have you rebooted since the upgrade?
If you are confident that it is upgraded then you could choose the option to
not show the update again when the update details are expanded.
John
"Mark Rae" wrote:
> Hi,
> I recently upgraded to SQL Server 2005 SP1 (developer edition) on WinXP Pro
> + SP2 by using the Microsoft Update service.
> No issues were noted during the upgrade process, and EXEC master..xp_msver
> returns 9.00.2047.00 in the ProductVersion column.
> However, subsequent running of Microsoft Update still shows SQL Server 2005
> SP1 (KB913090) as needing to be installed.
> Is this a bug with Microsoft Update, or does it mean that SP1 isn't
> installed properly?
> Any assistance gratefully received.
> Mark
>
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:34B375F1-9334-4141-B282-2FB06C8D4A44@.microsoft.com...
> Do you have multiple instances on this machine?
No.
> Did you check the installation's log files (hopefully this is going to be
> in the same place as a manual installation!).
Yes.
> Have you rebooted since the upgrade?
Yes. And reapplied the upgrade. And rebooted after that.
> If you are confident that it is upgraded
I'm as confident as I can be, I suppose. Other than master..xp_msver /
SELECT @.@.VERSION, is there anything else I can try...?
> then you could choose the option to not show the update again
> when the update details are expanded.
Yes, but I was loathe to do that until I'd at least asked in here. I've done
a Google search, and there doesn't seem to be anything about this specific
issue. Lots about SP1, of course, but nothing relating to problems with
applying it through Microsoft Update.
I should receive SP1 on DVD any day now as part of my MSDN Universal
subscription, so I'll reinstall it from that and then remove the option from
Microsoft Update if that doesn't fix it.

Microsoft SQL Server, Error: 87 17march

Source computer: SQL server 2005 SP1
Remote computer : SQLEXPRESS
When I try to register/connect with remote server (named instance) using sql
server management studio I am getting following error:
TITLE: New Server Registration
--
Testing the registered server failed. Verify the server name, login
credentials, and database, and then click Test again.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not
valid) (Microsoft SQL Server, Error: 87)
Thanks
Ontario, canadaSource computer: SQL server 2005 SP1 (Microsoft windows nt 5.1)
Remote computer : Microsoft SQL server express edition (Microsoft windows
nt 5.1)
-
ontario, canada
"db" wrote:
> Source computer: SQL server 2005 SP1
> Remote computer : SQLEXPRESS
>
> When I try to register/connect with remote server (named instance) using sql
> server management studio I am getting following error:
> TITLE: New Server Registration
> --
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 25 - Connection string is not
> valid) (Microsoft SQL Server, Error: 87)
>
> Thanks
> Ontario, canada