Newbie question here - stored procedures

Hi I just installed sql server 2005 for the first time today. Anyways I have a bunch of stored procs from an application i developed on the SQL 2000 server. Anyways I am having a problem with one of my stored procedures.

CREATE PROCEDURE ProvinceRetrieveAdHoc

(@.whereClause VARCHAR(256))

AS

EXEC("SELECT * FROM tblProvince WHERE " + @.whereClause)

RETURN

GO

However this isn't working, I am getting this error:

Incorrect syntax near 'SELECT * FROM tblProvince WHERE '.

Now I am guessing the EXEC statement must have changed, as every stored proc that uses the exec command errors out with this same error. All my other procedures run just fine. Can anyone please tell me how to fix it?

THanks

oh wow nm, i figured it out.. just replaced double quotes with single.sql

Newbie question about Office version on client machine

Does it matter what version of Office is installed on the clients
machine for opening reports generated by reporting Services?
The reason I am asking is because our users are getting an office
upgrade from 2000 to XP on their machines.No, it does not matter.
"Amit" <amit.gaind@.gmail.com> wrote in message
news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
> Does it matter what version of Office is installed on the clients
> machine for opening reports generated by reporting Services?
> The reason I am asking is because our users are getting an office
> upgrade from 2000 to XP on their machines.
>|||On Mar 20, 10:42 am, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> No, it does not matter.
> "Amit" <amit.ga...@.gmail.com> wrote in message
> news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
>
> > Does it matter what version of Office is installed on the clients
> > machine for opening reports generated by reporting Services?
> > The reason I am asking is because our users are getting an office
> > upgrade from 2000 to XP on their machines.- Hide quoted text -
> - Show quoted text -
thank you.

Newbie question - SP2

We are in a diverse workgroup here and I didn't do the install. How do I
know if I have SP2 installed? I tried to check in VS, but it didn't know.
Thanks!to determine the version you are running just type the url of the
report server (ex..http://<exampleWebServer>/reportserver.
Version info is located at the bottom of the page. The final product
release is 8.00.743.00..service pack 1 is 8.00.878.00, and sp2 is
8.00.1042.00
hope this helps

Newbie question

I have installed MSDE2000 since a couple of weeks on my machine and its
running the database for a forum on the intranet. Could someone please tell
me, how can I make a regular back up of my database please?
Regards
Rahul
hi Rahul,
"Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> I have installed MSDE2000 since a couple of weeks on my machine and its
> running the database for a forum on the intranet. Could someone please
tell
> me, how can I make a regular back up of my database please?
as MSDE does not provide graphical management utilities, you should resort
on Transact-SQL statement execution via oSql.exe, the command line
management tool available and bundled with it...
further info on how to use it can be found at
http://support.microsoft.com/default...;EN-US;q325003
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which porvides a user interface similar to
Enterprise Manager, that includes that feature, graphically
further MSDE management tools, both free and commercial, can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
google for others
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Adrea! That was a great help!
Regards
Rahul
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q3b2oFq9t8lU1@.uni-berlin.de...
> hi Rahul,
> "Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
> messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> tell
> as MSDE does not provide graphical management utilities, you should resort
> on Transact-SQL statement execution via oSql.exe, the command line
> management tool available and bundled with it...
> further info on how to use it can be found at
> http://support.microsoft.com/default...;EN-US;q325003
> for your convenience, you can have a look at a free prj of mine, available
> at the link following my sign., which porvides a user interface similar to
> Enterprise Manager, that includes that feature, graphically
> further MSDE management tools, both free and commercial, can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> google for others
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

newbie question

I am sorry if this question has been posted before, but a search in this
newsgroup has not solved the problem at hand:
I have installed MSDE on a windows xp pro machine with IIS already running.
Later I set up the MS Web data administrator (WDA)
However, it is impossble to log in via WDA.
As username I have tried "sa", my initials, my windows user name and
computername/windowsusername
As pw I have tried the strong pw that I used when making the installation
and leaving the pw field in blank.
As server I have tried "MSSQLSERVER", "Localhost" and my computer name.
Nothing works.
The funny thing is that MS Web Matrix can access MSDE without any problems
(which means that MSDE has been correctly installed, I suppose)
Any suggestions will be greatly appreciated.
Thanks
TB
Servername is "." or (local) or the Name of Your Computer, try this.
HTH, Jens Smeyer
http://www.sqlserver2005.de
"TB" <tbpostbox-googlegroups@.yahoo.com> schrieb im Newsbeitrag
news:O8PCyWbQFHA.4028@.tk2msftngp13.phx.gbl...
>I am sorry if this question has been posted before, but a search in this
>newsgroup has not solved the problem at hand:
> I have installed MSDE on a windows xp pro machine with IIS already
> running.
> Later I set up the MS Web data administrator (WDA)
> However, it is impossble to log in via WDA.
> As username I have tried "sa", my initials, my windows user name and
> computername/windowsusername
> As pw I have tried the strong pw that I used when making the installation
> and leaving the pw field in blank.
> As server I have tried "MSSQLSERVER", "Localhost" and my computer name.
> Nothing works.
> The funny thing is that MS Web Matrix can access MSDE without any problems
> (which means that MSDE has been correctly installed, I suppose)
> Any suggestions will be greatly appreciated.
> Thanks
> TB
>
|||When I open the SQL Server Service Manager, the server name is seems to be
the same as my computer name.
When I open the the log file created during the MSDE installation, I find
two entries which I don't know whether are relevant:
"Property(C): LogonUser = Trym"
"Property(C): USERNAME = tb"
Trym is my windows user name.
But I still can't seem to log in.
Is it possible to check what credentials MS Web Matrix uses to log in?
Thanks again.
TB
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:OdfcmabQFHA.924@.TK2MSFTNGP14.phx.gbl...
> Servername is "." or (local) or the Name of Your Computer, try this.
> HTH, Jens Smeyer
> --
> http://www.sqlserver2005.de
> --
> "TB" <tbpostbox-googlegroups@.yahoo.com> schrieb im Newsbeitrag
> news:O8PCyWbQFHA.4028@.tk2msftngp13.phx.gbl...
>
|||hi TB,
TB wrote:
> When I open the SQL Server Service Manager, the server name is seems
> to be the same as my computer name.
> When I open the the log file created during the MSDE installation, I
> find two entries which I don't know whether are relevant:
> "Property(C): LogonUser = Trym"
> "Property(C): USERNAME = tb"
> Trym is my windows user name.
> But I still can't seem to log in.
> Is it possible to check what credentials MS Web Matrix uses to log in?
please verify your MSDE instance accepts SQL Server (standard) authenticated
connections verifying the Windows registry is set as following..
(named instance)
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
LoginMode=2
(default instance)
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hey, that worked: I changed loginMode from 1 to 2, and now I can log using
sa as the username via WDA.
However, another thing happened. After changing the above value, I rebooted
and now the SQL Server Service Manager is no longer visible in the system
tray. But the the database is clearly running (as I can log in from WDA).
Any suggestions?
Thanks again
TB
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ca3suF6e6b6tU1@.individual.net...
> hi TB,
> TB wrote:
> please verify your MSDE instance accepts SQL Server (standard)
> authenticated connections verifying the Windows registry is set as
> following..
> (named instance)
> HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer
> LoginMode=2
> (default instance)
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi TB,
TB wrote:
> Hey, that worked: I changed loginMode from 1 to 2, and now I can log
> using sa as the username via WDA.
> However, another thing happened. After changing the above value, I
> rebooted and now the SQL Server Service Manager is no longer visible
> in the system tray. But the the database is clearly running (as I can
> log in from WDA). Any suggestions?
>
please verify your autostart folder includes a link to service manager... if
not, please create a link to your service manager adding a final "/n" , like
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Done. Everything is OK now. Molto grazie.
TB
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3cacjaF6knavmU1@.individual.net...
> hi TB,
> TB wrote:
> please verify your autostart folder includes a link to service manager...
> if not, please create a link to your service manager adding a final "/n" ,
> like
> "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
sql

newbie question

Hi,
i've just finished MOC 2779B and i would like to play with the "monster"...
at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
let's say that DB-PC1 is the source DB where a certain application runs
on PC1.
DB-PC2 is a test DB on PC2.
I would like to do the following things :
1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
2- everytime this data view is updated (deleted, inserted or updated
records) i would like to send the complete vdata view to DB-PC2 (test DB)
3- in this test DB, everytime that it receives data from DB-PC1, it
should split data records (fields, ...) into several parts and insert
them into tables availables on DB-PC2.
Like that we totally split data and risks to damage them.
I want to do that because i'm preparing a web portal on test DB-PC2
which should use a partial data information from DB-PC1.
So i do not want this web portal (in case of mistake into code) to
destroy partially DB-PC1.
so i though that for point 1 i could create a view and triggers to
detects update, inserts or delete actions.
However, how can i send this information (data view) from DB-PC1 tp DB-PC2 ?
Do you have any suggestion ?
thanks a lot,
R.A.F.You want me to send my resume' where? What your asking for is not a
small task and is probably out of scope for one posting. Try breaking
your project above down in to individual tasks, do your homework
first, and then post if you can't find the answer.
If you are the one that's going to be doing this...I would start with
Linked Servers and go from there. Also, in my opinion, wipe Views
complete from your chain of thought. Think Stored Procedures!
You have one nice project in front of you! Good Luck!
On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
> Hi,
> i've just finished MOC 2779B and i would like to play with the "monster"..
.
> at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
> let's say that DB-PC1 is the source DB where a certain application runs
> on PC1.
> DB-PC2 is a test DB on PC2.
> I would like to do the following things :
> 1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
> 2- everytime this data view is updated (deleted, inserted or updated
> records) i would like to send the complete vdata view to DB-PC2 (test DB)
> 3- in this test DB, everytime that it receives data from DB-PC1, it
> should split data records (fields, ...) into several parts and insert
> them into tables availables on DB-PC2.
> Like that we totally split data and risks to damage them.
> I want to do that because i'm preparing a web portal on test DB-PC2
> which should use a partial data information from DB-PC1.
> So i do not want this web portal (in case of mistake into code) to
> destroy partially DB-PC1.
> so i though that for point 1 i could create a view and triggers to
> detects update, inserts or delete actions.
> However, how can i send this information (data view) from DB-PC1 tp DB-PC2
?
> Do you have any suggestion ?
> thanks a lot,
> R.A.F.|||thanks Dave.
this is the kind of help i needed : linked servers.
how ? :-)
are there some requirements, or suggestions from MS ?
Dave wrote:
> You want me to send my resume' where? What your asking for is not a
> small task and is probably out of scope for one posting. Try breaking
> your project above down in to individual tasks, do your homework
> first, and then post if you can't find the answer.
> If you are the one that's going to be doing this...I would start with
> Linked Servers and go from there. Also, in my opinion, wipe Views
> complete from your chain of thought. Think Stored Procedures!
> You have one nice project in front of you! Good Luck!
>
>
> On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
>|||SQL Server 2005 Books Online (September 2007)
Linking Servers:
http://msdn2.microsoft.com/en-us/library/ms188279.aspx
Ekrem nsoy
"R.A.F." <noemail@.nospam.com> wrote in message
news:OQncU$FNIHA.5360@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> thanks Dave.
> this is the kind of help i needed : linked servers.
> how ? :-)
> are there some requirements, or suggestions from MS ?
> Dave wrote:

newbie question

Hi,
i've just finished MOC 2779B and i would like to play with the "monster"...
at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
let's say that DB-PC1 is the source DB where a certain application runs
on PC1.
DB-PC2 is a test DB on PC2.
I would like to do the following things :
1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
2- everytime this data view is updated (deleted, inserted or updated
records) i would like to send the complete vdata view to DB-PC2 (test DB)
3- in this test DB, everytime that it receives data from DB-PC1, it
should split data records (fields, ...) into several parts and insert
them into tables availables on DB-PC2.
Like that we totally split data and risks to damage them.
I want to do that because i'm preparing a web portal on test DB-PC2
which should use a partial data information from DB-PC1.
So i do not want this web portal (in case of mistake into code) to
destroy partially DB-PC1.
so i though that for point 1 i could create a view and triggers to
detects update, inserts or delete actions.
However, how can i send this information (data view) from DB-PC1 tp DB-PC2 ?
Do you have any suggestion ?
thanks a lot,
R.A.F.You want me to send my resume' where? What your asking for is not a
small task and is probably out of scope for one posting. Try breaking
your project above down in to individual tasks, do your homework
first, and then post if you can't find the answer.
If you are the one that's going to be doing this...I would start with
Linked Servers and go from there. Also, in my opinion, wipe Views
complete from your chain of thought. Think Stored Procedures!
You have one nice project in front of you! Good Luck!
On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
> Hi,
> i've just finished MOC 2779B and i would like to play with the "monster"...
> at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
> let's say that DB-PC1 is the source DB where a certain application runs
> on PC1.
> DB-PC2 is a test DB on PC2.
> I would like to do the following things :
> 1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
> 2- everytime this data view is updated (deleted, inserted or updated
> records) i would like to send the complete vdata view to DB-PC2 (test DB)
> 3- in this test DB, everytime that it receives data from DB-PC1, it
> should split data records (fields, ...) into several parts and insert
> them into tables availables on DB-PC2.
> Like that we totally split data and risks to damage them.
> I want to do that because i'm preparing a web portal on test DB-PC2
> which should use a partial data information from DB-PC1.
> So i do not want this web portal (in case of mistake into code) to
> destroy partially DB-PC1.
> so i though that for point 1 i could create a view and triggers to
> detects update, inserts or delete actions.
> However, how can i send this information (data view) from DB-PC1 tp DB-PC2 ?
> Do you have any suggestion ?
> thanks a lot,
> R.A.F.|||thanks Dave.
this is the kind of help i needed : linked servers.
how ? :-)
are there some requirements, or suggestions from MS ?
Dave wrote:
> You want me to send my resume' where? What your asking for is not a
> small task and is probably out of scope for one posting. Try breaking
> your project above down in to individual tasks, do your homework
> first, and then post if you can't find the answer.
> If you are the one that's going to be doing this...I would start with
> Linked Servers and go from there. Also, in my opinion, wipe Views
> complete from your chain of thought. Think Stored Procedures!
> You have one nice project in front of you! Good Luck!
>
>
> On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
>> Hi,
>> i've just finished MOC 2779B and i would like to play with the "monster"...
>> at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
>> let's say that DB-PC1 is the source DB where a certain application runs
>> on PC1.
>> DB-PC2 is a test DB on PC2.
>> I would like to do the following things :
>> 1- create a view on DB-PC1 to retrieve only the necessary data for DB-PC2.
>> 2- everytime this data view is updated (deleted, inserted or updated
>> records) i would like to send the complete vdata view to DB-PC2 (test DB)
>> 3- in this test DB, everytime that it receives data from DB-PC1, it
>> should split data records (fields, ...) into several parts and insert
>> them into tables availables on DB-PC2.
>> Like that we totally split data and risks to damage them.
>> I want to do that because i'm preparing a web portal on test DB-PC2
>> which should use a partial data information from DB-PC1.
>> So i do not want this web portal (in case of mistake into code) to
>> destroy partially DB-PC1.
>> so i though that for point 1 i could create a view and triggers to
>> detects update, inserts or delete actions.
>> However, how can i send this information (data view) from DB-PC1 tp DB-PC2 ?
>> Do you have any suggestion ?
>> thanks a lot,
>> R.A.F.
>|||SQL Server 2005 Books Online (September 2007)
Linking Servers:
http://msdn2.microsoft.com/en-us/library/ms188279.aspx
--
Ekrem Önsoy
"R.A.F." <noemail@.nospam.com> wrote in message
news:OQncU$FNIHA.5360@.TK2MSFTNGP03.phx.gbl...
> thanks Dave.
> this is the kind of help i needed : linked servers.
> how ? :-)
> are there some requirements, or suggestions from MS ?
> Dave wrote:
>> You want me to send my resume' where? What your asking for is not a
>> small task and is probably out of scope for one posting. Try breaking
>> your project above down in to individual tasks, do your homework
>> first, and then post if you can't find the answer.
>> If you are the one that's going to be doing this...I would start with
>> Linked Servers and go from there. Also, in my opinion, wipe Views
>> complete from your chain of thought. Think Stored Procedures!
>> You have one nice project in front of you! Good Luck!
>>
>>
>> On Dec 1, 4:34 am, "R.A.F." <noem...@.nospam.com> wrote:
>> Hi,
>> i've just finished MOC 2779B and i would like to play with the
>> "monster"...
>> at work we have 2 MS SQL server 2005 RDBMS installed on 2 PCs.
>> let's say that DB-PC1 is the source DB where a certain application runs
>> on PC1.
>> DB-PC2 is a test DB on PC2.
>> I would like to do the following things :
>> 1- create a view on DB-PC1 to retrieve only the necessary data for
>> DB-PC2.
>> 2- everytime this data view is updated (deleted, inserted or updated
>> records) i would like to send the complete vdata view to DB-PC2 (test
>> DB)
>> 3- in this test DB, everytime that it receives data from DB-PC1, it
>> should split data records (fields, ...) into several parts and insert
>> them into tables availables on DB-PC2.
>> Like that we totally split data and risks to damage them.
>> I want to do that because i'm preparing a web portal on test DB-PC2
>> which should use a partial data information from DB-PC1.
>> So i do not want this web portal (in case of mistake into code) to
>> destroy partially DB-PC1.
>> so i though that for point 1 i could create a view and triggers to
>> detects update, inserts or delete actions.
>> However, how can i send this information (data view) from DB-PC1 tp
>> DB-PC2 ?
>> Do you have any suggestion ?
>> thanks a lot,
>> R.A.F.

Newbie Q setting up MSDE

Hello. I've installed MSDE (Win2k machine, running asp.net on localhost),
and it says 'Not Connected' when I mouseover the icon in the system tray. I
opened the SQL Server service manager, and there are two empty fields-
Server and Services. Please, what do I put in these fields? Also, what
connection string would I use with MSDE. Thanks a lot
Justin Dutoit
hi Justin,
"Justin Dutoit" <anon@.anon.com> ha scritto nel messaggio
news:%23Gr48BqqEHA.3988@.tk2msftngp13.phx.gbl
> Hello. I've installed MSDE (Win2k machine, running asp.net on
> localhost), and it says 'Not Connected' when I mouseover the icon in
> the system tray. I opened the SQL Server service manager, and there
> are two empty fields- Server and Services. Please, what do I put in
> these fields? Also, what connection string would I use with MSDE.
> Thanks a lot
> Justin Dutoit
please verify, using the services applet (control panel->performance and
maintenance->administrative tools->services [on XP] , control
panel->administrative tools->services [on Win2k]) that your MSDE instance is
currently up and running...
you can then try typing in the service name of your MSDE instance to manage
it...
MSDE installs by default disabling network protocols and this can be an
issue for some ODBC related functions and, sometime, the SQL Server
instances are not enlisted by the Service Manager, as reported in
http://support.microsoft.com/default...b;EN-US;814132
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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 IIS & MS SQL connection problem ;-(

Have successfully installed MS SQL on my Win XP Pro machine, created tables,
and a dsn, which is working fine in Dreamweaver. So far so good.

When I run the page on IIS I get the following:-

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
requested in login 'MenuPlanner'. Login fails.

I think it's permissions - anyone got any clues as to where to look?

TIA

GrantBuzby wrote:
> Have successfully installed MS SQL on my Win XP Pro machine, created
tables,
> and a dsn, which is working fine in Dreamweaver. So far so good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

You could see if the login MenuPlanner has got permissions to the
database you are logging in to. That would be a start.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

> TIA
> Grant|||"dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> Buzby wrote:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables,
>> and a dsn, which is working fine in Dreamweaver. So far so good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> You could see if the login MenuPlanner has got permissions to the
> database you are logging in to. That would be a start.

This is what has got me - permissions are set up. I've created a dsn, which
I can run queries in Dreamweaver and filter results just fine. I'm having
trouble when running the page on my webserver (IIS which is working fine)

Stumped ;-(|||Buzby wrote:
> "dbmonitor" <dbmonitor_support@.hotmail.com> wrote in message
> news:1107519068.678569.226760@.o13g2000cwo.googlegr oups.com...
> > Buzby wrote:
> >> Have successfully installed MS SQL on my Win XP Pro machine,
created
> > tables,
> >> and a dsn, which is working fine in Dreamweaver. So far so good.
> >>
> >> When I run the page on IIS I get the following:-
> >>
> >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
database
> >> requested in login 'MenuPlanner'. Login fails.
> >>
> >> I think it's permissions - anyone got any clues as to where to
look?
> > You could see if the login MenuPlanner has got permissions to the
> > database you are logging in to. That would be a start.
> This is what has got me - permissions are set up. I've created a dsn,
which
> I can run queries in Dreamweaver and filter results just fine. I'm
having
> trouble when running the page on my webserver (IIS which is working
fine)
> Stumped ;-(

Is MenuPlanner the database name or the login name?

If it is the database name, are you connecting to the database via a
userid/password or are you connecting with Windows interactive UserID?
--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com|||Buzby (gb@.pumpupthe.net) writes:
> Have successfully installed MS SQL on my Win XP Pro machine, created
> tables, and a dsn, which is working fine in Dreamweaver. So far so
> good.
> When I run the page on IIS I get the following:-
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
> requested in login 'MenuPlanner'. Login fails.
> I think it's permissions - anyone got any clues as to where to look?

Sounds like the login has a default db which does not exist, or the login
does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
Sommarskog" <esquel@.sommarskog.se> wrote:

> Buzby (gb@.pumpupthe.net) writes:
>> Have successfully installed MS SQL on my Win XP Pro machine, created
>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>> good.
>>
>> When I run the page on IIS I get the following:-
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>> requested in login 'MenuPlanner'. Login fails.
>>
>> I think it's permissions - anyone got any clues as to where to look?
> Sounds like the login has a default db which does not exist, or the login
> does have access to. Use sp_helplogins to check, use sp_defaultdb to change.

Yea, but a DSN is being used so we have to believe that MenuPlanner is the
name of the DSN Connection. I am assuming that the DSN was created on the
IIS server and connects successfully when you "test connection" in the ODBC
dialog.

I highly recommend using a DSN-less connection in your ASP pages. There is
lots of documentation on ADODB.

If you need some sample connection strings let me know.|||Gregory Dean (gdean@.datapex.com) writes:
> On 2/4/05 5:37 PM, in article Xns95F3F003A2514Yazorman@.127.0.0.1, "Erland
> Sommarskog" <esquel@.sommarskog.se> wrote:
>> Buzby (gb@.pumpupthe.net) writes:
>>> Have successfully installed MS SQL on my Win XP Pro machine, created
>>> tables, and a dsn, which is working fine in Dreamweaver. So far so
>>> good.
>>>
>>> When I run the page on IIS I get the following:-
>>>
>>> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>>> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
>>> requested in login 'MenuPlanner'. Login fails.
>>>
>>> I think it's permissions - anyone got any clues as to where to look?
>>
>> Sounds like the login has a default db which does not exist, or the
>> login does have access to. Use sp_helplogins to check, use sp_defaultdb
>> to change.
> Yea, but a DSN is being used so we have to believe that MenuPlanner is
> the name of the DSN Connection. I am assuming that the DSN was created
> on the IIS server and connects successfully when you "test connection"
> in the ODBC dialog.

Not sure what you mean, but since SQL Server does not know what a DSN
is, MenuPlanner cannot be the name of the DNS. But it can be the
login name specified in the DSN.

> I highly recommend using a DSN-less connection in your ASP pages.

I echo that. DSN is a concept that I never understood the point with.
An extra layer that only causes hassle.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks one and all - it turned out it was an IIS permissions issue - however
I've taken on board what you have suggested and dsn less is the way we are
going!

Cheers

Buzby

newbie can't connect

Windows XP pro, SQL Server 2000 developers edition installed on the =
client computer.
Installed SQL Server using all defaults except changed detination drive =
and folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that =
when I log onto my Windows computer that that's the only login =
information that SQL server needs (that's how it seemed to work on my =
notebook).
What do I start to look for to solve this problem?
TIA.Is the SQL Service actually running ? If you run the following from the
command line does it connect
osql -S(local) -E
This assumes you installed a default instance. You can check this by running
Start>Run services.msc
Check for services starting with MSSQL. If you have one called MSSQLServer
then you have a default instance, if the service has a dollar ($) sign in it
e.g. MSSQL$INST01 then you have a named instance and connect like so
osql -S(local)\INST01 -E
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karl" <kthompson@.pine-grove.com.nospam> wrote in message
news:eER5eb5$DHA.1036@.TK2MSFTNGP10.phx.gbl...
Windows XP pro, SQL Server 2000 developers edition installed on the client
computer.
Installed SQL Server using all defaults except changed detination drive and
folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that when I
log onto my Windows computer that that's the only login information that SQL
server needs (that's how it seemed to work on my notebook).
What do I start to look for to solve this problem?
TIA.

Newbie Authentication

Have Server2003, IIS6 with multiple websites, sql2000, and just installed
reporting services. After making my first simple report with graph to see how
this works (XP pro), I published to the server. But, I was the only one able
to see it using the server name. So, I changed the permissions on the
reportServer and reports under IIS Default website to allow IUSR_serverName
to read/execute and enabled anonymous access with IUSR_serverName.
Now, if I want to deploy update to report to web I have to take off the new
IUSR permissions and then put them back. And, only folks within the company
could get to the report - dns is done at the firewall.
So, I made a virtual directory under IIS within the web called Reports, and
made sure the permissions on the virtual directory were set to read/execute.
Now, if I use a dial-up and a url similar to below, I'm told the user
doesn't have permissions to view the page.
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
I've probably done a thousand things wrong - anybody willing to enlighten me?
Thanks so much.Have you found the answer to the issue? I'm interested to hear what
your status is because I'm having the same problem as well.
Thanks
janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see how
> this works (XP pro), I published to the server. But, I was the only one able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the new
> IUSR permissions and then put them back. And, only folks within the company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports, and
> made sure the permissions on the virtual directory were set to read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten me?
> Thanks so much.|||Angela,
Nope. I've tried a bunch of different settings at this point. Including
the
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExternalURL>
setting, but nothing has worked. I've posted at: aspfree; sqlteam,
sqljunkies, ms, sqlmagazine - nobody is answering. Even watched a few more
ms webcams. Frankly, I probably won't be able to use the product if I can't
find a solution.
I'll do my best to come back and let you know if somebody helps me out.
jb
"Angella" wrote:
> Have you found the answer to the issue? I'm interested to hear what
> your status is because I'm having the same problem as well.
> Thanks
> janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see how
> > this works (XP pro), I published to the server. But, I was the only one able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the new
> > IUSR permissions and then put them back. And, only folks within the company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports, and
> > made sure the permissions on the virtual directory were set to read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> > http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten me?
> >
> > Thanks so much.
>|||"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see
how
> this works (XP pro), I published to the server. But, I was the only one
able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow
IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the
new
> IUSR permissions and then put them back. And, only folks within the
company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports,
and
> made sure the permissions on the virtual directory were set to
read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
>
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten
me?
> Thanks so much.
>
Having the same problem, too. Any updates?
Thanks!
Ken|||Ken,
Nothing concrete yet, but I'm at least talking to folks on the Minsasi
website and on SQL magazine. If I get anything concrete, I'll post here for
both you and Angela.
Thanks,
Janet
"Ken" wrote:
> "janetb" <janetb@.discussions.microsoft.com> wrote in message
> news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see
> how
> > this works (XP pro), I published to the server. But, I was the only one
> able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow
> IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the
> new
> > IUSR permissions and then put them back. And, only folks within the
> company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports,
> and
> > made sure the permissions on the virtual directory were set to
> read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> >
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten
> me?
> >
> > Thanks so much.
> >
> Having the same problem, too. Any updates?
> Thanks!
> Ken
>
>|||Great! I'll certainly do the same. Thanks so much, Janet!
Ken
"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:3FAAD6BF-4273-46B9-BF2D-285C92824312@.microsoft.com...
> Ken,
> Nothing concrete yet, but I'm at least talking to folks on the Minsasi
> website and on SQL magazine. If I get anything concrete, I'll post here
for
> both you and Angela.
> Thanks,
> Janet
> "Ken" wrote:
> > "janetb" <janetb@.discussions.microsoft.com> wrote in message
> > news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > > Have Server2003, IIS6 with multiple websites, sql2000, and just
installed
> > > reporting services. After making my first simple report with graph to
see
> > how
> > > this works (XP pro), I published to the server. But, I was the only
one
> > able
> > > to see it using the server name. So, I changed the permissions on the
> > > reportServer and reports under IIS Default website to allow
> > IUSR_serverName
> > > to read/execute and enabled anonymous access with IUSR_serverName.
> > >
> > > Now, if I want to deploy update to report to web I have to take off
the
> > new
> > > IUSR permissions and then put them back. And, only folks within the
> > company
> > > could get to the report - dns is done at the firewall.
> > >
> > > So, I made a virtual directory under IIS within the web called
Reports,
> > and
> > > made sure the permissions on the virtual directory were set to
> > read/execute.
> > >
> > > Now, if I use a dial-up and a url similar to below, I'm told the user
> > > doesn't have permissions to view the page.
> > >
> > >
> >
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> > >
> > > I've probably done a thousand things wrong - anybody willing to
enlighten
> > me?
> > >
> > > Thanks so much.
> > >
> >
> > Having the same problem, too. Any updates?
> >
> > Thanks!
> > Ken
> >
> >
> >

Newbie Alert !

Dear Folks,

First time here.

Have just installed a 120-day evaluation copy of MSSQL 2000.

In the 'blur' and confusion of installing this on my WinXP Laptop, I
forgot to record the password.

Finally, I got into the 'logins' tab on the Enterprise Manager, and
modified the 'sa' password to 'ivlem1', and I think it was recorded
properly.

I tried to test my installation with the following at the Command
Prompt:

osql /Usa /P ivlem1

It failed saying I wasn't 'Trusted'

I would appreciate any help offered !

TIA,

-Mel SmithDid you select "mixed" mode for authentication. I would test this
differently...fire up QA and use your SA account/passwd to account.
There are too many things that could go wrong with establishing a
connection using osql.

HTH

MJKulangara
http://sqladventures.blogspot.com|||Mel Smith (medsyntel@.aol.com) writes:
> Have just installed a 120-day evaluation copy of MSSQL 2000.
> In the 'blur' and confusion of installing this on my WinXP Laptop, I
> forgot to record the password.
> Finally, I got into the 'logins' tab on the Enterprise Manager, and
> modified the 'sa' password to 'ivlem1', and I think it was recorded
> properly.
> I tried to test my installation with the following at the Command
> Prompt:
> osql /Usa /P ivlem1
> It failed saying I wasn't 'Trusted'

SQL Server have to means of authentication: Windows authentication (a.k.a
Integrated Security or Trusted Connection) and SQL Server authentication.
Windows authentication is always there, SQL authentication is optional,
and usually referred to as "mixed mode".

Windows authentcation means that you log into SQL Server with your
Windows credentials. This is very simple, you just say "osql /E" and
you are on the air. No need for password, as you are already logged
into Windows.

By default, only Windows authentication is enabled. This is because
SQL Server authentication is less secure. However, many enable
SQL authentiation for various reasons. For instance, if you are a
developer you may work with Windows authentication as long as you
develop and have sysadmin rights. But when you need to test, you
want a low-priv user, and testing different users is much easier
with SQL authentication.

You can change authentication mode from Enterprise Manager. Right-
click the server, select Properties, and then use the Security tab.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland and MJK,

Thank you both for your advice !

Erland:

I tried "osql /E" and it worked ! (i.e., I got correct correct results
for the two queries: select @.@.servername and select @.@.version)

(now I'm going to go blind reading all there is on Books Online to get
myself up to speed )

btw, I'm fairly expert in xBase databases (my job is tech support for a
structural steel company that uses my software, but is now moving to MSSQL)
and I have to show that I'm up to the task to help them make that move. In
fact, they have purchased AccPac for Windows, and have installed MSSQL 2000.
But I'm at a remote location from the headquarters of this company and must
get used to MSSQL all by myself in the 'sunny south'.

Thanks again.

-Mel Smith
Mesa, Arizona, USA

Newbie - Subscription problem

I know this has probably been asked many many times, but
can someone please help me.
Recently, I installed the evaluation version of RS (and
SP1). I have been trying to test out the subscription
feature, but can't seem to get it working. When I store
the credentials as a Windows login, I get an error
stating that the login failed. If I store the sa login
under the credentials I do not get a login failed error,
but nothing happens. The report is never delivered. Can
anyone tell me how to make subscriptions work?
I am running RS on a Window 2000 server and am trying to
send email through and Exchange 2000 server.
Thanks in advance for your help.When using sa after the subscription fires, what is in the log files? Does
the status of the subscription ever change?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim" <tim@.discussions.microsoft.com> wrote in message
news:2d93d01c46b4b$965ad170$a601280a@.phx.gbl...
> I know this has probably been asked many many times, but
> can someone please help me.
> Recently, I installed the evaluation version of RS (and
> SP1). I have been trying to test out the subscription
> feature, but can't seem to get it working. When I store
> the credentials as a Windows login, I get an error
> stating that the login failed. If I store the sa login
> under the credentials I do not get a login failed error,
> but nothing happens. The report is never delivered. Can
> anyone tell me how to make subscriptions work?
> I am running RS on a Window 2000 server and am trying to
> send email through and Exchange 2000 server.
> Thanks in advance for your help.
>

Newbie - sa password error after ACT! install - Need pro's help!!!

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

The default sa password is blank. Is it complaining that this is not acceptable and you need to change it ?

What version of SQL Server do you have ? It sounds like SQL Server Express 2005 ? You may well have two instances installed now, one that came with ACT, and one that you've installed.

Overall, I'd say ACT are the people to talk to, you're using SQL Server with ACT, right ?

|||Yes, it is saying that the sa password is empty...specifically: "A strong sa password is required for security purposes. Please us SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit." That is what is says when I attempt to run ANY installation version of SQL ... attempting to correct the sql error that I get when I run ACT!. Is there a way to repair or rebuild the sql server? I have only one instance, from the ACT! install... Thanks for the reply.. !!|||By the way.. that was the install error for SQL Server 2000 version A specifically... I installed SQL Server 2005 Express... or tried to... it would run either..|||

ACT will support either one ? I'm not sure that you don't have two instances running now ( SQL Server can have more than one version, or multiple instances of the same version, running on a machine ). If I were you, I'd uninstall the lot, including SQL Server, and reinstall ACT. To set the password, you run the installer for SQL Server from the command line and specify SAPWD="whatever", which will set the SA password. If the version of SQL Server you have installed has a management console, or whatever it was called in SS2000, you can go into it, find the Users section, and change the password there.

However, I would be more inclined to do a reinstall from scratch and then try the ACT site:

http://www.act.com/support/technicalsupport/index.cfm

I've looked and I can't see anything specific there, but the problem obviously relates to ACT, and if you've paid for it, they would be the ones who know what's going on, and should be supporting you to get their program working.

|||Sounds great... as for ACT! I called them already.. since I bought this version a while ago,. they stopped supporting it a couple months ago! Nice huh?! As for uninstalling them, I'm all for it.. how do I uninstall SS2000 and all the other instances of SQL Server? It's not in my remove programs dialog....... Thanks again for the help... look for to hearing back from you|||

If SS2000 is not in your list, perhaps MSDE is ( that's the free version ). Otherwise, maybe it uninstalls with ACT. If you go to Control Panel/Administrative Tools/Services, the list is alphabetical, if there are any listings that start with SQL Server, you still have SQL Server installed :-)

Your question is right on the edge of what is on topic here, and that means you're unlikely to find people with direct, first hand experience of the problem. If an uninstall/reinstall doesn't solve it, then I'd suggest looking for a forum populated with people who use ACT. I'm happy to try and help, but I'm pretty much in the dark, all I can do is comment based on what I know of SQL Server.

newbie - empty result set for all queries?

I am a newbie and have installed SQL Server myself on my home machine,
where I'm having problems. When I run the Query Analyzer, I get an
empty result set for all queries, with the message, "The command(s)
completed successfully." So, for instance, if I were to go to
Northwind and type "SELECT * from Employees", which we KNOW isn't
empty, all I see is "The command(s) completed successfully." How do I
get query results?

I thought maybe the problem was permissions. I'm logged into my local
server, which is the computer on which I'm running. The owner is just
"ZIPPY/Owner", ZIPPY being my machine name; since I'm the only one who
uses the computer, I don't even log in, I just take the default "Owner"
account. I start up the SQL analyzer with Windows credentials.

Anyone have a clue what I'm doing wrong?shelah (shelah2@.verizon.net) writes:
> I am a newbie and have installed SQL Server myself on my home machine,
> where I'm having problems. When I run the Query Analyzer, I get an
> empty result set for all queries, with the message, "The command(s)
> completed successfully." So, for instance, if I were to go to
> Northwind and type "SELECT * from Employees", which we KNOW isn't
> empty, all I see is "The command(s) completed successfully." How do I
> get query results?

You are not even getting an empty result set. Apparently you are in some
sort of noexec mode where the query is sent to SQL Server for validation
only.

There are a couple of ways to get this behaviour. First make sure that
you press the green arrow to run the query. The blue tick is for validation
only.

If the problem is not that simple, check Tools->Options->Connection
properties. If any of SET NOEXEC ON or SET PARSEONLY ON are checked,
uncheck them.

If this does not help, send these commands to SQL Server:

SET PARSEONLY OFF
SET NOEXEC OFF
SET FMTONLY OFF

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thank you, that was an enormous help. You were right; I was clicking
the check and not the green arrow. A great relief to know that I have a
usable database and don't have to do some wierd chown gyrations.

*** Sent via Developersdex http://www.developersdex.com ***|||thanks it was a great help even to me
Erland Sommarskog wrote:
> shelah (shelah2@.verizon.net) writes:
> > I am a newbie and have installed SQL Server myself on my home machine,
> > where I'm having problems. When I run the Query Analyzer, I get an
> > empty result set for all queries, with the message, "The command(s)
> > completed successfully." So, for instance, if I were to go to
> > Northwind and type "SELECT * from Employees", which we KNOW isn't
> > empty, all I see is "The command(s) completed successfully." How do I
> > get query results?
> You are not even getting an empty result set. Apparently you are in some
> sort of noexec mode where the query is sent to SQL Server for validation
> only.
> There are a couple of ways to get this behaviour. First make sure that
> you press the green arrow to run the query. The blue tick is for validation
> only.
> If the problem is not that simple, check Tools->Options->Connection
> properties. If any of SET NOEXEC ON or SET PARSEONLY ON are checked,
> uncheck them.
> If this does not help, send these commands to SQL Server:
> SET PARSEONLY OFF
> SET NOEXEC OFF
> SET FMTONLY OFF
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||To avoid this in the future just hit F5

http://sqlservercode.blogspot.com/

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!
>> >>
>> >>