components installation

I am just a novice, and am curious.I

I was trying subscription, but an error occured: "Microsoft Server Management Studio is un able to accessreplication components because replication is not installed on this instance.

I went to change, located my setup exe, installed. but at the end, I get this message: No selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine......

I downloaded the Express edition via MSDN download.

May somebody please help? What wrong did I do? What did I miss to do?

SQL Server 2005 Express does not include Microsoft SQL Server Management Studio. But SQL Server 2005 SQLEXPRCOMP does.|||There is also a separate download for the Management Express Studio. See this link here for more details:

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Compatible?

I have been doing some research on SQL Server 2005 Express. We have recently purchased Visual Studio 2005 Professional Edition which comes with a copy of SQL Server 2005 Developer Edition. My question is this: Once we complete development using VS Pro + SQL Server DE, will we be able to load SQL Server Express on the client's machines and be able to have full functionality of the database that we have created to be used with the program? I have read that SQL Server Express IS in fact compatible and fully integrated with VS Express, but i have not read any information saying wheather or not it is integrated with VS Pro/SQL Server DE. Does anyone know if it is or not, and either way know the difficulty in converting it (ie. loss of data, tables, etc)?

Short answer: Yes, they are compatible.

Long answer: SQL Express has a smaller feature set than SQL Dev. If you've used functionality in your application that is not included in SQL Express, then it will fail on SQL Express. As far as the database though, the files are exactly the same and can be transfered from one Edition to another.

You can check out the SQL Server Feature Comparison to determine if you're using any features that are not available in SQL Express.

Compatibility with SQL 2000

I have moved a database from SQL 2000 to SQL 2005 Express. I have modified the structure in 2005 Management Studio Express.

Now I cannot attach to the modified dataabse in SQL 2000 Enterprise Manager. I get "Error 602: Could not find row in sysindexes for database ID.... Run DBCC CHECKTABLE on sysindexes".

This occurs despite the fact that I have kept the database at Compatibiluty Level SQL Server 2000, as reported in 2005 Management Studio Express.

Are 2005 and 2000 databases not compatible?

Many thanks.

As you discovered, once you attach a database to SQL 2005, you cannot move it back to SQL 2000.

Moving a database is a one-way operation, and cannot be reversed.

|||

Compatability Mode has nothing to do with the database format, it has to do with how commands are run by the database engine. Databases are automatically converted to the 2005 file format when they are attached, there is no way to convert the database format back. You should be able to manage SQL 2000 database from SSMS if that is the tool you would prefer to use, but you can not bounce databases back and forth between SQL 2000 and SQL 2005.

Mike

|||Thanks.

Compatibility issue

When I start "SQL Server Business Intelligence Development Studio" I am
getting the following message:
This program has known compatibility issue
Program: Visual Studio 2005
Publisher: Microsoft
Location: ...................\ide\devenv.exe
I am running Vista and SQL 2005 Express edition.
ThanksOn Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> When I start "SQL Server Business Intelligence Development Studio" I am
> getting the following message:
> This program has known compatibility issue
> Program: Visual Studio 2005
> Publisher: Microsoft
> Location: ...................\ide\devenv.exe
> I am running Vista and SQL 2005 Express edition.
> Thanks
Are you running SQL Server 2005 Express Edition Service Pack 2? If
not, this will be the problem.
Regards,
Enrique Martinez
Sr. Software Consultant|||I tried to install SP2 but setup said there were no components to upgrade.
Can you help?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> When I start "SQL Server Business Intelligence Development Studio" I am
>> getting the following message:
>> This program has known compatibility issue
>> Program: Visual Studio 2005
>> Publisher: Microsoft
>> Location: ...................\ide\devenv.exe
>> I am running Vista and SQL 2005 Express edition.
>> Thanks
>
> Are you running SQL Server 2005 Express Edition Service Pack 2? If
> not, this will be the problem.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> I tried to install SP2 but setup said there were no components to upgrade.
> Can you help?
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> When I start "SQL Server Business Intelligence Development Studio" I am
> >> getting the following message:
> >> This program has known compatibility issue
> >> Program: Visual Studio 2005
> >> Publisher: Microsoft
> >> Location: ...................\ide\devenv.exe
> >> I am running Vista and SQL 2005 Express edition.
> >> Thanks
> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> > not, this will be the problem.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I had the same problem a little while back. You want to backup your
databases and uninstall the original Express Edition and install the
SP2 version.
Regards,
Enrique Martinez
Sr. Software Consultant|||I see.
Do I need to uninstall everything (Visual Studio 2005 part as well) ?
Which download from MS site do I use to have SQL 2005, Reporting Services,
and Business Intelligence for report creation installed?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> I tried to install SP2 but setup said there were no components to
>> upgrade.
>> Can you help?
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> When I start "SQL Server Business Intelligence Development Studio" I
>> >> am
>> >> getting the following message:
>> >> This program has known compatibility issue
>> >> Program: Visual Studio 2005
>> >> Publisher: Microsoft
>> >> Location: ...................\ide\devenv.exe
>> >> I am running Vista and SQL 2005 Express edition.
>> >> Thanks
>> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
>> > not, this will be the problem.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> I had the same problem a little while back. You want to backup your
> databases and uninstall the original Express Edition and install the
> SP2 version.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> I see.
> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
> Which download from MS site do I use to have SQL 2005, Reporting Services,
> and Business Intelligence for report creation installed?
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> I tried to install SP2 but setup said there were no components to
> >> upgrade.
> >> Can you help?
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> >> When I start "SQL Server Business Intelligence Development Studio" I
> >> >> am
> >> >> getting the following message:
> >> >> This program has known compatibility issue
> >> >> Program: Visual Studio 2005
> >> >> Publisher: Microsoft
> >> >> Location: ...................\ide\devenv.exe
> >> >> I am running Vista and SQL 2005 Express edition.
> >> >> Thanks
> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> >> > not, this will be the problem.
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> > I had the same problem a little while back. You want to backup your
> > databases and uninstall the original Express Edition and install the
> > SP2 version.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you have just the Express Editions, you just need to uninstall SQL
Server Express Edition and the Express Edition Toolkit (not VB.NET
Express or C#.NET Express, etc). The latest Express Edition downloads
are located here:
http://msdn.microsoft.com/vstudio/express/sql/download/
You will want to download and install: MS SQL Server Express Edition w/
Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
Toolkit (SP2 Edition).
Both of the SP2 Editions are here at this link. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||After I reinstall everything I still get "Compatibility ..." message when I
start Business Intelligence Studio.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
> On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> I see.
>> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
>> Which download from MS site do I use to have SQL 2005, Reporting
>> Services,
>> and Business Intelligence for report creation installed?
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
>> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> I tried to install SP2 but setup said there were no components to
>> >> upgrade.
>> >> Can you help?
>> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
>> >> > wrote:
>> >> >> When I start "SQL Server Business Intelligence Development Studio"
>> >> >> I
>> >> >> am
>> >> >> getting the following message:
>> >> >> This program has known compatibility issue
>> >> >> Program: Visual Studio 2005
>> >> >> Publisher: Microsoft
>> >> >> Location: ...................\ide\devenv.exe
>> >> >> I am running Vista and SQL 2005 Express edition.
>> >> >> Thanks
>> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
>> >> > not, this will be the problem.
>> >> > Regards,
>> >> > Enrique Martinez
>> >> > Sr. Software Consultant
>> > I had the same problem a little while back. You want to backup your
>> > databases and uninstall the original Express Edition and install the
>> > SP2 version.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
>
> If you have just the Express Editions, you just need to uninstall SQL
> Server Express Edition and the Express Edition Toolkit (not VB.NET
> Express or C#.NET Express, etc). The latest Express Edition downloads
> are located here:
> http://msdn.microsoft.com/vstudio/express/sql/download/
> You will want to download and install: MS SQL Server Express Edition w/
> Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
> Toolkit (SP2 Edition).
> Both of the SP2 Editions are here at this link. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 16, 6:16 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> After I reinstall everything I still get "Compatibility ..." message when I
> start Business Intelligence Studio.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
> > On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> I see.
> >> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
> >> Which download from MS site do I use to have SQL 2005, Reporting
> >> Services,
> >> and Business Intelligence for report creation installed?
> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >>news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
> >> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
> >> >> I tried to install SP2 but setup said there were no components to
> >> >> upgrade.
> >> >> Can you help?
> >> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
> >> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
> >> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
> >> >> > wrote:
> >> >> >> When I start "SQL Server Business Intelligence Development Studio"
> >> >> >> I
> >> >> >> am
> >> >> >> getting the following message:
> >> >> >> This program has known compatibility issue
> >> >> >> Program: Visual Studio 2005
> >> >> >> Publisher: Microsoft
> >> >> >> Location: ...................\ide\devenv.exe
> >> >> >> I am running Vista and SQL 2005 Express edition.
> >> >> >> Thanks
> >> >> > Are you running SQL Server 2005 Express Edition Service Pack 2? If
> >> >> > not, this will be the problem.
> >> >> > Regards,
> >> >> > Enrique Martinez
> >> >> > Sr. Software Consultant
> >> > I had the same problem a little while back. You want to backup your
> >> > databases and uninstall the original Express Edition and install the
> >> > SP2 version.
> >> > Regards,
> >> > Enrique Martinez
> >> > Sr. Software Consultant
> > If you have just the Express Editions, you just need to uninstall SQL
> > Server Express Edition and the Express Edition Toolkit (not VB.NET
> > Express or C#.NET Express, etc). The latest Express Edition downloads
> > are located here:
> >http://msdn.microsoft.com/vstudio/express/sql/download/
> > You will want to download and install: MS SQL Server Express Edition w/
> > Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
> > Toolkit (SP2 Edition).
> > Both of the SP2 Editions are here at this link. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Are you running different versions of either SQL Server or Visual
Studio on the same box?|||I am not really sure. I am not installing any VS components. Whatever SQL
installs that is what I have.
In the message about "Compatibility ..." problem it says that it is a known
issue and offers me to check MS site for the solution. When I select that it
takes me to VS 2005 download site with different SP1s. There is one for
Express Edition and another for Vista. This one is not specific to a SQL
2005 version. At least how I understand it. Which one do I need to install
assuming that it is the fix?
Thanks
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176728887.064188.163410@.e65g2000hsc.googlegroups.com...
> On Apr 16, 6:16 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> After I reinstall everything I still get "Compatibility ..." message when
>> I
>> start Business Intelligence Studio.
>> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> news:1176659212.272895.185390@.n76g2000hsh.googlegroups.com...
>> > On Apr 15, 8:00 am, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> I see.
>> >> Do I need to uninstall everything (Visual Studio 2005 part as well) ?
>> >> Which download from MS site do I use to have SQL 2005, Reporting
>> >> Services,
>> >> and Business Intelligence for report creation installed?
>> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >>news:1176615560.558980.50040@.n76g2000hsh.googlegroups.com...
>> >> > On Apr 14, 7:16 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com> wrote:
>> >> >> I tried to install SP2 but setup said there were no components to
>> >> >> upgrade.
>> >> >> Can you help?
>> >> >> "EMartinez" <emartinez...@.gmail.com> wrote in message
>> >> >>news:1176588226.825762.155530@.w1g2000hsg.googlegroups.com...
>> >> >> > On Apr 14, 12:31 pm, "Mark Goldin" <markgoldin_2...@.yahoo.com>
>> >> >> > wrote:
>> >> >> >> When I start "SQL Server Business Intelligence Development
>> >> >> >> Studio"
>> >> >> >> I
>> >> >> >> am
>> >> >> >> getting the following message:
>> >> >> >> This program has known compatibility issue
>> >> >> >> Program: Visual Studio 2005
>> >> >> >> Publisher: Microsoft
>> >> >> >> Location: ...................\ide\devenv.exe
>> >> >> >> I am running Vista and SQL 2005 Express edition.
>> >> >> >> Thanks
>> >> >> > Are you running SQL Server 2005 Express Edition Service Pack 2?
>> >> >> > If
>> >> >> > not, this will be the problem.
>> >> >> > Regards,
>> >> >> > Enrique Martinez
>> >> >> > Sr. Software Consultant
>> >> > I had the same problem a little while back. You want to backup your
>> >> > databases and uninstall the original Express Edition and install the
>> >> > SP2 version.
>> >> > Regards,
>> >> > Enrique Martinez
>> >> > Sr. Software Consultant
>> > If you have just the Express Editions, you just need to uninstall SQL
>> > Server Express Edition and the Express Edition Toolkit (not VB.NET
>> > Express or C#.NET Express, etc). The latest Express Edition downloads
>> > are located here:
>> >http://msdn.microsoft.com/vstudio/express/sql/download/
>> > You will want to download and install: MS SQL Server Express Edition w/
>> > Advanced Services (SP2 Edition) and MS SQL Server 2005 Express Edition
>> > Toolkit (SP2 Edition).
>> > Both of the SP2 Editions are here at this link. Hope this helps.
>> > Regards,
>> > Enrique Martinez
>> > Sr. Software Consultant
> Are you running different versions of either SQL Server or Visual
> Studio on the same box?
>

Compatability : SQL Server 2005 Management Studio

Hello Everyone,

I have a Web Host which uses SQL Server 2000. I can use their interface and make tables and procedures, but I wanted to use some sort of graphical tool...Is it possible to use SQL Server 2005 Studio with SQL 2000.

I'm really new to SQL Server as my past experience is largely with Oracle....and there for the same purpose I can use SQL Navigator or TOAD....

IF SQL Server 2005 Studio wont work can someone please suggest a tool I can use to create tables and procedures on the remote server..

Thanks,

Harsimrat

Hi,

yes you can use SQL Server 2005 Management Studio for administring SQL2k databases, I do that also with my host databases in the web. If you don′t have SQL Server 2005 Management Studio you can also use one of the tools mentioned here:

http://www.aspfaq.com/2442

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Awesome,

Thanks

Harsimrat