Newbie Question - Service Manager / Win 2003

Hi,

I'm running a Microsoft Windows 2003 Server computer, which is using a MS SQL server to feed our office application, OfficeTalk.

Due to the extreme size of the database, we have decided to install an external 1TB drive, and move the database to it.

The difficult bit we're finding is how to make it so that the service loads the new data source.

In other words, how do you use Service Manager to parse an argument to dbsvr.exe in order to change the database location?

Regards,
Matthew.Hi Mathew and welcome to TSDN MSSQL forum,

If you have an agreed maintenance slot where you can take the MSSQL server down, I would suggest do the following:

Back everything up
using enterprise manager detach on the database you want to move
copy the database to the new location
using enterprise manager attach the database by browsing to the new location.

If you get problems, backout by detaching the database in the new location and attach the old one.

Suggest you also try it out on a test DB, northwinds etc before you go for it for real..

Regards Purple

Newbie Question

Hi Guys,

I am new to this Reporting Service world. May be its very simple question.

I have create a report in SQL Server 2005 reporting services and want to link this report with aspx page. How I do this. Just want to link report with default.aspx page so when this page open report also open automatically.

Please let me guide how could I do this.

Regards

I would recommend using the ASP.net ReportViewer control. It will make the web app appear much more polished than just linking to the reportmanager.|||If you don not want anything to change programmtically you can also just display the appropiate report in your frame targeting to the URL of you report on the ReportServer interface. (The one that you see if you navigate through the webservice http://Server/reportserver, e.g. http://server/reportserver?Somefolder/Report&Parameter=SomeValue)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Greate!! Thanks for your reply.

I pasted a report control on my aspx page but how I link my report with this page. I used the below code but it giving me error message

ReportViewer1.LocalReport.ReportEmbeddedResource = @.\\Business\Business\RPT825.rdl; (This is my local machine path)

and the Error message is

An error occurred during local report processing.|||

Hi Guys,

Please ignore my previous email. I have fixed the above issue. Now I don't know how to pass a parameter value to a report.

I wrote the below line in my aspx page and when I ran this application it gives me a error message

"The rDate parameter is missing a value"

Below is the code that I wrote in my page_load event

ReportViewer1.LocalReport.ReportPath = @."C:\Business\RPT825.rdl";

Could you please let me know how to pass parameter value to a report.

Regards

|||

ReportViewer1.LocalReport.SetParameters( );

Juran

sql

Newbie Question

I've just started messing around with SQL2K5 and Reporting Service. I loaded SQL Server Reporting Pack for IIS. I can't seam to find any detailed details on the pack. Is there an easy way to repoint the 12 reports from the template db to my live IIS ODBC db? Or is it better to just start from scratch and build the reports?

Thanx

I'm not quite sure what you mean here? Are you saying you have 12 reports pointing to your old DB and now you want to point them to your new db? If so just change the datasource of the reports to your new db.

Make sure however the new db has the same table/column names as the datasets already in the reports otherwise the reports will break.

Newbie Merge replication question

Hi!

I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field.

The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database?

/Magnus

Merge replication permits the agents to have subsets of the data based on how the Publication is programmed. One alternate approach would be to publish individual agent tables, but this gets messy as agents are added and removed.|||Could I use a "translator" table to translate suser_name()'s to applications userid's? Then in the filter query against this table to identify the user? One solution could be to have one Publication for each employee? Yes it would become messy to administer. But my problem can't be unique. How do you all query out data for each employee?|||You could have each user identifying themselves when using the application, and setting their userid as HostName on your replication object. Then you can reference this in your publication filter with HOST_NAME().

Newbie Merge replication question

Hi!

I'm setting up a merge replication for sql ce. Ten guys with windows mobile 5 pocket pc works as service technicians and need to synchronize data in the field.

The backend database is huge and I just want each person to have their own data on the pda and synchronized, they have unique userid's in the database. Is it possible to filter data for each person or do all have to have all data that's in the backend database?

/Magnus

Merge replication permits the agents to have subsets of the data based on how the Publication is programmed. One alternate approach would be to publish individual agent tables, but this gets messy as agents are added and removed.|||Could I use a "translator" table to translate suser_name()'s to applications userid's? Then in the filter query against this table to identify the user? One solution could be to have one Publication for each employee? Yes it would become messy to administer. But my problem can't be unique. How do you all query out data for each employee?|||You could have each user identifying themselves when using the application, and setting their userid as HostName on your replication object. Then you can reference this in your publication filter with HOST_NAME().

Newbie Install question

HI,
I am new to Sql Reporting Service and I have a Newbie question. I have VS.Net installed on one Computer and SQL Server installed on a server. When I install SQL RS, Do I install it on both, my development computer and the SQL Server (windows Server)? And what VER can I put on both computers (if I have to install it on both)? Should I put Enterprise on the Server (Sql server and windows server) and Developer on the VS.Net computer? Or can I put Enterprise on both?
Thank you,
AndreWell, that depends on what you want to do. :) If you want the design app
then you have to install RS on the machine with VS. For the server
components you can install on any machine that has access to a SQL machine.
It is not a requirement that SQL and RS be on the same box.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:7D4A0AF2-17B5-447A-9042-FF56434C6353@.microsoft.com...
> HI,
> I am new to Sql Reporting Service and I have a Newbie question. I have
VS.Net installed on one Computer and SQL Server installed on a server. When
I install SQL RS, Do I install it on both, my development computer and the
SQL Server (windows Server)? And what VER can I put on both computers (if I
have to install it on both)? Should I put Enterprise on the Server (Sql
server and windows server) and Developer on the VS.Net computer? Or can I
put Enterprise on both?
> Thank you,
> Andre
>|||Thanks.
Is there any reason that I would need the Server components on my VS.Net machine? Or installing the Server components on the SQL server will do the trick?
FYI
I have both a Sql server running windows server 2003 and IIS, and a Development machine.|||There is no need to put the server components on the VS.Net machine. Some
companies will not allow IIS and SQL on the same box so they will put RS
server components on another machine.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:EAF2855F-B8D7-4074-999F-BB8EB7BE1E36@.microsoft.com...
> Thanks.
> Is there any reason that I would need the Server components on my VS.Net
machine? Or installing the Server components on the SQL server will do the
trick?
> FYI
> I have both a Sql server running windows server 2003 and IIS, and a
Development machine.
>

Newbie in SQL Server admin

Can you give me the step-by-step procedure to setup some alerts in SQL
2000 to get pager or email notification once the :

1- SQL Server (service) is down
2- Trans log is full"Frank" <soal6570@.yahoo.com> wrote in message
news:42601b2.0404061558.62fda9af@.posting.google.co m...
> Can you give me the step-by-step procedure to setup some alerts in SQL
> 2000 to get pager or email notification once the :
> 1- SQL Server (service) is down
> 2- Trans log is full

For #1, look at the Windows Service manager.

This has a "Recovery" tab, and the ability to run a custom program on
service failure.

...

Steven|||soal6570@.yahoo.com (Frank) wrote in message news:<42601b2.0404061558.62fda9af@.posting.google.com>...
> Can you give me the step-by-step procedure to setup some alerts in SQL
> 2000 to get pager or email notification once the :
> 1- SQL Server (service) is down
> 2- Trans log is full

1. SQL Server Agent can send an alert if the MSSQL process reports a
fatal error, but if it's down as well, it won't be able to alert you.
So you may want to look at it as a general Windows issue - if you
already have a Windows event monitoring system in place, then you can
use that to do something when the MSSQL services stop and start (by
default, they are set to auto restart). You can also use the Control
Panel Services applet to do something (run a script etc.) when a
service fails to start.

2. Email/pager notifications require SQL Mail:

http://support.microsoft.com/defaul...kb;EN-US;263556

After doing that, then you can use Enterprise Manager to create
whatever alerts you need. There is a demo alert already created for a
full log condition, so you can use it as a template.

Simon

Newbee question on Reporting Service

Hi,
I am new to Reporting Service, I came from Crystal Reports background.
Have 2 questions:
(1) The Reports cretated via report designer are not object oriented? They
are not exposed as classes, my concern is that I can not manipulate the
reports programatically.
(2) The Reports do not exposed events? This might sounds related to question
(1), but even in non OO world, reports expose events too, say MS Access.
TIAHi,
Were you able to find out if the reports expose any events? The 'OnInit'
event is the only one I know of. So are there any events similar to MS Access?
Thanks,
Honesto J Manlig
"Danny Ni" wrote:
> Hi,
> I am new to Reporting Service, I came from Crystal Reports background.
> Have 2 questions:
> (1) The Reports cretated via report designer are not object oriented? They
> are not exposed as classes, my concern is that I can not manipulate the
> reports programatically.
> (2) The Reports do not exposed events? This might sounds related to question
> (1), but even in non OO world, reports expose events too, say MS Access.
>
> TIA
>
>

NEWB Question - Runs as a Service?

I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
installation. I have just installed MS SQL Server 2005 and SQL 2005 Server,
SP2. When I open the Management Studio, there are no servers to choose. I
can't make a server show up there! If the software is installed on my machine
(Windows Vista), is there a SQL server running in the background somewhere?
As a service? I don't see a service in the Services control panel. Do I need
to start the server somehow? I have looked everywhere for this information!
Help!SQL Server is comprised of several services. You may have installed the
client tools only. Go to Control Panel | Programs | Uninstall a Program
(used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
Select it and hit Change. You should be able to add the services you
missed.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> installation. I have just installed MS SQL Server 2005 and SQL 2005
> Server,
> SP2. When I open the Management Studio, there are no servers to choose. I
> can't make a server show up there! If the software is installed on my
> machine
> (Windows Vista), is there a SQL server running in the background
> somewhere?
> As a service? I don't see a service in the Services control panel. Do I
> need
> to start the server somehow? I have looked everywhere for this
> information!
> Help!|||Thank you! I figured something like that.
Well, I did as you suggested, but it looks like everything is already
installed. After I opened thecontrol panel, I selected SQL Server 2005 and
clicked on Change. Then I could choose SQL Server 2005 Instances (none have
been installed) or SQL Server 2005 common components (has a sub-button of
Workstation Components). I chose the latter, common components. Was that
right?
In the connectivity components, it looks like everything is already there:
management tools, business intellegence development studio, software
development kit, sqlxml client features, legacy components, and all the
"Documentattion, Samples, and Sample Databases".
Am I still missing something?! I am VERY GRATEFUL for your help!
azanna.
"Geoff N. Hiten" wrote:
> SQL Server is comprised of several services. You may have installed the
> client tools only. Go to Control Panel | Programs | Uninstall a Program
> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> Select it and hit Change. You should be able to add the services you
> missed.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> > Server,
> > SP2. When I open the Management Studio, there are no servers to choose. I
> > can't make a server show up there! If the software is installed on my
> > machine
> > (Windows Vista), is there a SQL server running in the background
> > somewhere?
> > As a service? I don't see a service in the Services control panel. Do I
> > need
> > to start the server somehow? I have looked everywhere for this
> > information!
> > Help!
>|||Instances are the SQL services. Common components is common across the
various SQL subsystems. Go back and install an instance. Default instance
should be what you need.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||Here's what I get: "There are no items to show in this view." Wah!
"Ekrem Ã?nsoy" wrote:
> Will you open up SQL Server Configuration Manager from Configuration Tools
> and look for SQL Server services from SQL Server 2005 Services node?
> It would be good if you send us a list of those services listed in the SQL
> Server 2005 Services window.
> Also, tell us about their statuses (Running\Stopped)
> --
> Ekrem Ã?nsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
valid installation file. I downloaded and installed the SQL Server 2005
full-version trial. I did it two ways; I saved the image file (which doesn't
work for adding a component in the instance dialog) and I also just installed
the .exe that was the Download link. Neither one will let me install an
instance. When I use the Report button, it says that I do have a common
instance installed:
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
level: 9.2.3042 Language: English (United States)]
Thank you!
azanna.
"Geoff N. Hiten" wrote:
> Instances are the SQL services. Common components is common across the
> various SQL subsystems. Go back and install an instance. Default instance
> should be what you need.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> > Thank you! I figured something like that.
> >
> > Well, I did as you suggested, but it looks like everything is already
> > installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
> > have
> > been installed) or SQL Server 2005 common components (has a sub-button of
> > Workstation Components). I chose the latter, common components. Was that
> > right?
> >
> > In the connectivity components, it looks like everything is already there:
> > management tools, business intellegence development studio, software
> > development kit, sqlxml client features, legacy components, and all the
> > "Documentattion, Samples, and Sample Databases".
> >
> > Am I still missing something?! I am VERY GRATEFUL for your help!
> >
> > azanna.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> SQL Server is comprised of several services. You may have installed the
> >> client tools only. Go to Control Panel | Programs | Uninstall a Program
> >> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
> >> Select it and hit Change. You should be able to add the services you
> >> missed.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior SQL Infrastructure Consultant
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
> >> > Server,
> >> > SP2. When I open the Management Studio, there are no servers to choose.
> >> > I
> >> > can't make a server show up there! If the software is installed on my
> >> > machine
> >> > (Windows Vista), is there a SQL server running in the background
> >> > somewhere?
> >> > As a service? I don't see a service in the Services control panel. Do I
> >> > need
> >> > to start the server somehow? I have looked everywhere for this
> >> > information!
> >> > Help!
> >>
> >>
>|||Instance means SQL Service Instance. No other component of SQL is an
Instance.
Workstation components are not part of an instance, They are management
tools, documentation, examples, and config tools.
Unpack the image to a folder and point there when the installer wants the
install folder. You must select SQL Server Database Services (first item on
the Components to Install dialog box) if you want to install the SQL Server
engine.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:17D32179-E8F6-44E0-A67D-AE6F92921610@.microsoft.com...
> Hi, Geoff. Actually, I did try that too, but I apparently can't point to a
> valid installation file. I downloaded and installed the SQL Server 2005
> full-version trial. I did it two ways; I saved the image file (which
> doesn't
> work for adding a component in the instance dialog) and I also just
> installed
> the .exe that was the Download link. Neither one will let me install an
> instance. When I use the Report button, it says that I do have a common
> instance installed:
> Workstation Components
> [Version: 9.2.3042.00 Edition: Enterprise Evaluation Edition Patch
> level: 9.2.3042 Language: English (United States)]
> Thank you!
> azanna.
> "Geoff N. Hiten" wrote:
>> Instances are the SQL services. Common components is common across the
>> various SQL subsystems. Go back and install an instance. Default
>> instance
>> should be what you need.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>
>>|||Will you open up SQL Server Configuration Manager from Configuration Tools
and look for SQL Server services from SQL Server 2005 Services node?
It would be good if you send us a list of those services listed in the SQL
Server 2005 Services window.
Also, tell us about their statuses (Running\Stopped)
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
> Thank you! I figured something like that.
> Well, I did as you suggested, but it looks like everything is already
> installed. After I opened thecontrol panel, I selected SQL Server 2005 and
> clicked on Change. Then I could choose SQL Server 2005 Instances (none
> have
> been installed) or SQL Server 2005 common components (has a sub-button of
> Workstation Components). I chose the latter, common components. Was that
> right?
> In the connectivity components, it looks like everything is already there:
> management tools, business intellegence development studio, software
> development kit, sqlxml client features, legacy components, and all the
> "Documentattion, Samples, and Sample Databases".
> Am I still missing something?! I am VERY GRATEFUL for your help!
> azanna.
> "Geoff N. Hiten" wrote:
>> SQL Server is comprised of several services. You may have installed the
>> client tools only. Go to Control Panel | Programs | Uninstall a Program
>> (used to be Add/Remove programs) and look for Microsoft SQL Server 2005.
>> Select it and hit Change. You should be able to add the services you
>> missed.
>> --
>> Geoff N. Hiten
>> Senior SQL Infrastructure Consultant
>> Microsoft SQL Server MVP
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> > Server,
>> > SP2. When I open the Management Studio, there are no servers to choose.
>> > I
>> > can't make a server show up there! If the software is installed on my
>> > machine
>> > (Windows Vista), is there a SQL server running in the background
>> > somewhere?
>> > As a service? I don't see a service in the Services control panel. Do I
>> > need
>> > to start the server somehow? I have looked everywhere for this
>> > information!
>> > Help!
>>|||It's obviously clear that you have no any installed SQL Server instance.
Will you try to start the SQL Server setup and try to install an instance?
Do not skip checking Database Engine from the Components to Install window
that will appear in setup process.
After the setup, go to Configuration Manager and look for SQL Server
services and tell us what happens.
--
Ekrem Ã?nsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"azanna" <azanna@.discussions.microsoft.com> wrote in message
news:217AB314-58A5-4BA2-B9D8-48082526E886@.microsoft.com...
> Here's what I get: "There are no items to show in this view." Wah!
> "Ekrem Ã?nsoy" wrote:
>> Will you open up SQL Server Configuration Manager from Configuration
>> Tools
>> and look for SQL Server services from SQL Server 2005 Services node?
>> It would be good if you send us a list of those services listed in the
>> SQL
>> Server 2005 Services window.
>> Also, tell us about their statuses (Running\Stopped)
>> --
>> Ekrem Ã?nsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
>>
>> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> news:87D5A3A3-AE61-4F87-9E97-8CB4F9927D2B@.microsoft.com...
>> > Thank you! I figured something like that.
>> >
>> > Well, I did as you suggested, but it looks like everything is already
>> > installed. After I opened thecontrol panel, I selected SQL Server 2005
>> > and
>> > clicked on Change. Then I could choose SQL Server 2005 Instances (none
>> > have
>> > been installed) or SQL Server 2005 common components (has a sub-button
>> > of
>> > Workstation Components). I chose the latter, common components. Was
>> > that
>> > right?
>> >
>> > In the connectivity components, it looks like everything is already
>> > there:
>> > management tools, business intellegence development studio, software
>> > development kit, sqlxml client features, legacy components, and all the
>> > "Documentattion, Samples, and Sample Databases".
>> >
>> > Am I still missing something?! I am VERY GRATEFUL for your help!
>> >
>> > azanna.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SQL Server is comprised of several services. You may have installed
>> >> the
>> >> client tools only. Go to Control Panel | Programs | Uninstall a
>> >> Program
>> >> (used to be Add/Remove programs) and look for Microsoft SQL Server
>> >> 2005.
>> >> Select it and hit Change. You should be able to add the services you
>> >> missed.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior SQL Infrastructure Consultant
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >>
>> >> "azanna" <azanna@.discussions.microsoft.com> wrote in message
>> >> news:F3BCB32A-4E03-479F-8B1B-EF5CDF908FA7@.microsoft.com...
>> >> > I'm a brand new user. I need MS SQL Server 2005 for my DotNetNuke
>> >> > installation. I have just installed MS SQL Server 2005 and SQL 2005
>> >> > Server,
>> >> > SP2. When I open the Management Studio, there are no servers to
>> >> > choose.
>> >> > I
>> >> > can't make a server show up there! If the software is installed on
>> >> > my
>> >> > machine
>> >> > (Windows Vista), is there a SQL server running in the background
>> >> > somewhere?
>> >> > As a service? I don't see a service in the Services control panel.
>> >> > Do I
>> >> > need
>> >> > to start the server somehow? I have looked everywhere for this
>> >> > information!
>> >> > Help!
>> >>
>> >>