Showing posts with label couple. Show all posts
Showing posts with label couple. Show all posts

Wednesday, March 28, 2012

Installing full text index on SQL Server

A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.
sp_fulltext_database 'enable'
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:

> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>
|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:

> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E...80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>

Installing full text index on SQL Server

A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:
> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
> > A couple of years ago our ISP installed SQL Server 2000 single
> > processor licence on our server in their data centre.
> >
> > They omitted to turn on indexing, or install full text indexing.
> >
> > This was fine, but now we need to use it.
> >
> > Is there any way that we can install full text indexing on the server
> > remotely using scripts to create the relevent stored procedures etc?
> >
> > Or will we have to send the disk back to the data center so they can
> > put it in the server for us?
> >
> > If this is the case and we re-insert the disk, what would be the effect
> > on the server of putting the disk back in (remembering that this is a
> > live server with several web sites hosted on it)? Would a new instance
> > be created? master databases over written etc? or would it be just fine
> > and the new services be added without any problems?
> >
> > Any help, links, kb refs etc greatly appreciated
> >
> > Paul R.
> >
> >|||Anytime Paul
Check out my site
http://www.mycodekb.com/
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:
> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823E84B-C443-4483-B4A3-CEF80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
> > sp_fulltext_database 'enable'
> > --
> > Paul Zanbaka
> > Sharepoint Adminstrator and DBA
> > www.mycodekb.com
> >
> >
> > "thoades@.hotmail.com" wrote:
> >
> > > A couple of years ago our ISP installed SQL Server 2000 single
> > > processor licence on our server in their data centre.
> > >
> > > They omitted to turn on indexing, or install full text indexing.
> > >
> > > This was fine, but now we need to use it.
> > >
> > > Is there any way that we can install full text indexing on the server
> > > remotely using scripts to create the relevent stored procedures etc?
> > >
> > > Or will we have to send the disk back to the data center so they can
> > > put it in the server for us?
> > >
> > > If this is the case and we re-insert the disk, what would be the effect
> > > on the server of putting the disk back in (remembering that this is a
> > > live server with several web sites hosted on it)? Would a new instance
> > > be created? master databases over written etc? or would it be just fine
> > > and the new services be added without any problems?
> > >
> > > Any help, links, kb refs etc greatly appreciated
> > >
> > > Paul R.
> > >
> > >
>

Installing full text index on SQL Server

A couple of years ago our ISP installed SQL Server 2000 single
processor licence on our server in their data centre.
They omitted to turn on indexing, or install full text indexing.
This was fine, but now we need to use it.
Is there any way that we can install full text indexing on the server
remotely using scripts to create the relevent stored procedures etc?
Or will we have to send the disk back to the data center so they can
put it in the server for us?
If this is the case and we re-insert the disk, what would be the effect
on the server of putting the disk back in (remembering that this is a
live server with several web sites hosted on it)? Would a new instance
be created? master databases over written etc? or would it be just fine
and the new services be added without any problems?
Any help, links, kb refs etc greatly appreciated
Paul R.sp_fulltext_database 'enable'
--
Paul Zanbaka
Sharepoint Adminstrator and DBA
www.mycodekb.com
"thoades@.hotmail.com" wrote:

> A couple of years ago our ISP installed SQL Server 2000 single
> processor licence on our server in their data centre.
> They omitted to turn on indexing, or install full text indexing.
> This was fine, but now we need to use it.
> Is there any way that we can install full text indexing on the server
> remotely using scripts to create the relevent stored procedures etc?
> Or will we have to send the disk back to the data center so they can
> put it in the server for us?
> If this is the case and we re-insert the disk, what would be the effect
> on the server of putting the disk back in (remembering that this is a
> live server with several web sites hosted on it)? Would a new instance
> be created? master databases over written etc? or would it be just fine
> and the new services be added without any problems?
> Any help, links, kb refs etc greatly appreciated
> Paul R.
>|||Many thanks Paul, that was exactly what I needed.
usefull examples also found here
http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
Pr.
Paul Zanbaka wrote:[vbcol=seagreen]
> sp_fulltext_database 'enable'
> --
> Paul Zanbaka
> Sharepoint Adminstrator and DBA
> www.mycodekb.com
>
> "thoades@.hotmail.com" wrote:
>|||Anytime Paul
Check out my site
http://www.mycodekb.com/
Paul Zanbaka
Sharepoint Adminstrator and DBA
"thoades@.hotmail.com" wrote:

> Many thanks Paul, that was exactly what I needed.
> usefull examples also found here
> http://sqljunkies.com/How%20To/E823...F80EB34CB1.scuk
> Pr.
> Paul Zanbaka wrote:
>sql

Monday, March 26, 2012

Installing Exchange Pack for Reporting Services

Has anyone successfully installed the Exchange Pack for Reporting Services?
I've attempted a couple of times and continue to get "Object Reference not
set to an instance of object", which causes the install to rollback.
Does anyone know how to correct this problem?
This question was originally posted in 10\04, but there was never an answer
posted.Do you have a default instance of SQL Server? What OS are you running? We
have never been able to repro this here.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
> answer
> posted.
>|||Yes, I have the default instance running on SQL Server. The Reporting Service
installed fine. We are running Server 2003 STD (ver. 5.2.3790). .NET
Framework 1.1 (ver 1.1.4322.573). No Visual Studio installed.
"Brian Welcker [MSFT]" wrote:
> Do you have a default instance of SQL Server? What OS are you running? We
> have never been able to repro this here.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> > answer
> > posted.
> >
>
>|||I had this error, and it went away once I installed Visual Studio.NET Pro on
the PC, so there must be some object missing without it.
Michael
"winkle60" <winkle60@.discussions.microsoft.com> wrote in message
news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> Has anyone successfully installed the Exchange Pack for Reporting
Services?
> I've attempted a couple of times and continue to get "Object Reference not
> set to an instance of object", which causes the install to rollback.
> Does anyone know how to correct this problem?
> This question was originally posted in 10\04, but there was never an
answer
> posted.
>|||I have not tried installing Visual Studio, but I had a feeling that it might
be the issue even though it is supposed to be optional. I will try it when I
get the chance and see what happens.
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I installed Visual Studio .NET 2003 and was able to complete the install.
Another question, is there anyway to actually pull data from the Exchange
system without installing the SSW softeware extraction piece on the Exchange
server?
"michael@.civis.com" wrote:
> I had this error, and it went away once I installed Visual Studio.NET Pro on
> the PC, so there must be some object missing without it.
> Michael
> "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > Has anyone successfully installed the Exchange Pack for Reporting
> Services?
> >
> > I've attempted a couple of times and continue to get "Object Reference not
> > set to an instance of object", which causes the install to rollback.
> >
> > Does anyone know how to correct this problem?
> >
> > This question was originally posted in 10\04, but there was never an
> answer
> > posted.
> >
>
>|||I'm wondering the same thing. Is the SSQ software piece required? If so, is
that a seperate product you have to buy? I'd be curious to hear from anyone
who made this work. Thanks.
"winkle60" wrote:
> I installed Visual Studio .NET 2003 and was able to complete the install.
> Another question, is there anyway to actually pull data from the Exchange
> system without installing the SSW softeware extraction piece on the Exchange
> server?
> "michael@.civis.com" wrote:
> > I had this error, and it went away once I installed Visual Studio.NET Pro on
> > the PC, so there must be some object missing without it.
> >
> > Michael
> >
> > "winkle60" <winkle60@.discussions.microsoft.com> wrote in message
> > news:22141FD2-86C1-4CBC-87F1-6E09FD77CC94@.microsoft.com...
> > > Has anyone successfully installed the Exchange Pack for Reporting
> > Services?
> > >
> > > I've attempted a couple of times and continue to get "Object Reference not
> > > set to an instance of object", which causes the install to rollback.
> > >
> > > Does anyone know how to correct this problem?
> > >
> > > This question was originally posted in 10\04, but there was never an
> > answer
> > > posted.
> > >
> >
> >
> >

Wednesday, March 21, 2012

Installed SQLServer Express.....now what?

Hi

I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.

So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:

Microsoft SQL Server 2005

>>>Configuration Tools

>>>>>>SQL Server Configuration Manager

>>>>>>SQL Server Error and Usage Reporting

>>>>>>SQL Server Surface Area Configuration

Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?

Thanks


Rich

For one thing, VS provides tools that allow you to create databases and then fill them with all kinds of database goodness. (i.e. Tables, Views, Stored Procedures, you name it.) They pretty much give you everything you need.

If you want to use the SQL Tools to do this, you'll need to download SQL Management Studio Express, which you can get from the SQL Express download page. Once you install SSMSE, you'll see another item on your Start menu.

Mike

Installed SQL Express and Now Front Page won't work.

A couple of weeks ago I installed SQL Express on a system that also has VS 2005, Front Page and other applications. Now the Front Page application can no longer connect to the web server and I keep getting a message:

Server error: Error 2 opening registry key "SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Ports\Port 80".

Has anyone else seen this error? Any suggestions on resolving this.

I did try a reinstall of Front Page and the error is still there.

John

Since the problem you're having is with FrontPage, you should ask the FrontPage experts. I'd suggest starting in the Office Newsgroups and if that doesn't sort it out, call the support organization.

I'm not aware of any changes made by SQL Express that would impact your permissions to that registry hive, it is likely just a coincidents that your FP problems started around the same time that you installed SQL Express.

Mike

|||

For anyone ever looking into a problem like this, the actual issue was a problem on the internet server side. The Front Page extensions had gotten messed up. The solution was to have the hosting provider reinstall the front page extensions on me web site (www.teaminfocenter.com) and that got things working again.

Thanks

John

Installed SQL Express and Now Front Page won't work.

A couple of weeks ago I installed SQL Express on a system that also has VS 2005, Front Page and other applications. Now the Front Page application can no longer connect to the web server and I keep getting a message:

Server error: Error 2 opening registry key "SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Ports\Port 80".

Has anyone else seen this error? Any suggestions on resolving this.

I did try a reinstall of Front Page and the error is still there.

John

Since the problem you're having is with FrontPage, you should ask the FrontPage experts. I'd suggest starting in the Office Newsgroups and if that doesn't sort it out, call the support organization.

I'm not aware of any changes made by SQL Express that would impact your permissions to that registry hive, it is likely just a coincidents that your FP problems started around the same time that you installed SQL Express.

Mike

|||

For anyone ever looking into a problem like this, the actual issue was a problem on the internet server side. The Front Page extensions had gotten messed up. The solution was to have the hosting provider reinstall the front page extensions on me web site (www.teaminfocenter.com) and that got things working again.

Thanks

John