Hi Joe,
The little server icon is called Service Manager and it does not list the
named instances.
To check the status of the named instance that you have installed, you can
type the server name in the Severbox. It is a dropdown cum text box. So you
will be able to type the SQL Server Name.
For a named instance, the SQL Server name would be
<computername>\<Instancename>.
In your case it would be <computername>\JoesDB01.
After typing the server name, click on Refresh Services button and it
should show you the state of the different services, like the SQL Server,
SQL Server Agent, Distributed Transaction Coordinator.
You can control the state of each Service,
1. Start - Click on this to start/Continue the service, if it is Stopped or
Paused
2. Stop - Click on this to stop the Service.
3. Pause - Click on this to pause the service. Pausing, will allow the
current users to work and will not allow new users to connect to the SQL
Server.
You can also installed the SQL Web Data Administrator, to create and manage
Database from
http://www.microsoft.com/downloads/d...798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Great! This helped a lot. Things seem to be working fine now
Thanks Ashish!
-- Joe
sql
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Installing Delphi 2005 Gives Security Exception..
After installing delphi 2005 I am getting a security exception when trying
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>
Wednesday, March 21, 2012
Installed SQL Server 2005 CTP.. wheres enterprise manager?
Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murray
There is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluat...0/default.mspx
http://www.microsoft.com/sql/evaluat...5/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murray
There is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluat...0/default.mspx
http://www.microsoft.com/sql/evaluat...5/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
Installed SQL Server 2005 CTP.. wheres enterprise manager?
Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evalua...00/default.mspx
http://www.microsoft.com/sql/evalua...05/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evalua...00/default.mspx
http://www.microsoft.com/sql/evalua...05/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on Windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
Installed SQL Server 2005 CTP.. wheres enterprise manager?
Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.mspx
http://www.microsoft.com/sql/evaluation/sysreqs/2005/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
installed the configuration tools menu in start > programs. But i cannot
find enterprise manager. am i missing something?
Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
about the actual server software, not the client tools).
Thanks!
cheers, murrayThere is no Enterprise Manager in SQL Server 2005. EM functionality is
included in Sql Server Management Studio.
SQL 2000 Developer and Evaluation editions can be installed on XP but not
Standard or Enterprise. SQL 2005 Developer, Express and Workgroup editions
can be installed on XP but not Standard or Enterprise. For the complete
lists of system requirements, see:
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.mspx
http://www.microsoft.com/sql/evaluation/sysreqs/2005/default.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>|||Hi
SQL Server 7.0 is not supported on Windows XP
SQL Server 2000 and 2005, developer and personal editions are installable on
Windows XP. Standard and Enterprise Editions are not.
SQL Server Management Studio is the replacement for Enterprise Manager. If
it is not there, it means you did not select it during the install.
SQL Server 2005 Express does not ship with a UI until 2006.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"j.murray" <j.murray@.telco.com.au> wrote in message
news:uAdVXw81FHA.3568@.TK2MSFTNGP15.phx.gbl...
> Hi I installed SQL Server 2005 CTP on my win XP pro sp2 machine. It has
> installed the configuration tools menu in start > programs. But i cannot
> find enterprise manager. am i missing something?
> Also, am i rightin saying that SQL 7 & SQL 2000 Server cannot be installed
> on windows XP Pro, BUT SQL 2005 can be installed on XP Pro? (im talking
> about the actual server software, not the client tools).
> Thanks!
> cheers, murray
>
Installed SQL Server 2005 but Enterprise Manager is missing and so are the databases like
Gurus,
Installed SQL 2005 for the first time. I noticed Enterprise Manager is
missing. So I went into Configuration Manager since it sounded similar and
low and behold I discovered that all the databases that get created in SQL
Server 2000 like Master, Model, Northwind, etc are missing. My question is
are they actually missing or do I need to install an add-on to see them?
Spin
> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
> missing.
It is not Enterprise Manager anymore. EM & Query Analyzer have been
combined into a single GUI tool called Management Studio. It should be
under the program files folder for SQL Server 2005, and if not, perhaps you
didn't pay close attention during install. You need to specify that
Management Studio is to be installed by going into Workstation Components.
> low and behold I discovered that all the databases that get created in SQL
> Server 2000 like Master, Model, Northwind, etc are missing.
Well, master and model are certainly there. What does "missing" mean? I
think you need to get Management Studio up and running before you can make
any judgment calls on what's there and what's not.
Oh, and Northwind is no longer a database that ships with SQL Server (same
as pubs). You can install AdventureWorks which is found under Sample
Databases in setup.
|||> What is the name of the file that I click on to bring up the Management
> Studio tool?
The executable is sqlwb.exe. However, the full name should be in a shortcut
on your start menu.
|||I do not have this executable. So I put the CD back in and do what?
Why does Microsoft have to make this so hard?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OY4FPGFfHHA.1244@.TK2MSFTNGP04.phx.gbl...
> The executable is sqlwb.exe. However, the full name should be in a
> shortcut on your start menu.
>
|||>I do not have this executable. So I put the CD back in and do what?
Since you already have the server installed, then open the CD, go to the
tools folder, run setup.exe, and when you get to the screen that asks which
components you want to install, slow down. First you'll go through these
steps:
(a) check "I accept the licensing terms and conditions"
(b) hit " Next > "
(c) wait for prerequisites to be installed (yes it will have to do this
every time)
(d) hit " Next > "
Now you will be at "Welcome to the Microsoft SQL Server Installation Wizard.
(a) hit " Next > "
(b) as long as you don't have any errors on the config check, hit " Next > "
(c) enter your name and company (or leave blank if desired)
(d) hit " Next > "
(e) on the feature selection page, expand Client Components
(f) I would select Connectivity Components and Management Tools (you may
choose others if you wish)
(to select a component, you click on the down arrow next to a component,
and choose "Will be installed on local hard drive")
(g) if you want sample database and/or Books Online, expand the
Documentation, Samples... node
(h) hit " Next > " ... I assume you'll be okay without assistance from here?
> Why does Microsoft have to make this so hard?
I don't think they made it as hard as you make it out to be. And be honest,
did you read "ReadmeSQL2005.htm" and setup instructions, and pay attention
to all screens while you were installing the product?
|||Thank you!
To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
simply expect the products to have the same tools in the same places as the
previous versions. We're all too busy in this life to have company software
throw us curveballs. I think MS should recognize that everyone is busy and
have products be intuitive enough to the point where you don't have to RTM.
Well, maybe RTM is a good thing b/c it keep us IT people in a job! Well,
it's off to the manual and this thing now.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucElrmKfHHA.2376@.TK2MSFTNGP04.phx.gbl...
> Since you already have the server installed, then open the CD, go to the
> tools folder, run setup.exe, and when you get to the screen that asks
> which components you want to install, slow down. First you'll go through
> these steps:
> (a) check "I accept the licensing terms and conditions"
> (b) hit " Next > "
> (c) wait for prerequisites to be installed (yes it will have to do this
> every time)
> (d) hit " Next > "
> Now you will be at "Welcome to the Microsoft SQL Server Installation
> Wizard.
> (a) hit " Next > "
> (b) as long as you don't have any errors on the config check, hit " Next >
> "
> (c) enter your name and company (or leave blank if desired)
> (d) hit " Next > "
> (e) on the feature selection page, expand Client Components
> (f) I would select Connectivity Components and Management Tools (you may
> choose others if you wish)
> (to select a component, you click on the down arrow next to a
> component, and choose "Will be installed on local hard drive")
> (g) if you want sample database and/or Books Online, expand the
> Documentation, Samples... node
> (h) hit " Next > " ... I assume you'll be okay without assistance from
> here?
>
> I don't think they made it as hard as you make it out to be. And be
> honest, did you read "ReadmeSQL2005.htm" and setup instructions, and pay
> attention to all screens while you were installing the product?
>
|||> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
> simply expect the products to have the same tools in the same places as
> the previous versions.
I don't think this expectation is very realistic. If a product does not
evolve, then don't bother upgrading beyond v1.0.
A
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> I don't think this expectation is very realistic. If a product does not
> evolve, then don't bother upgrading beyond v1.0.
> A
You're right, I was just b%tching and moaning, trying to get my voice heard
by Microsoft. Thanks for listening.
|||Aaron, that tip worked btw! Nice job!
"Spin" <Spin@.spin.com> wrote in message
news:586md5F2ftkduU1@.mid.individual.net...
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> You're right, I was just b%tching and moaning, trying to get my voice
> heard by Microsoft. Thanks for listening.
Installed SQL 2005 for the first time. I noticed Enterprise Manager is
missing. So I went into Configuration Manager since it sounded similar and
low and behold I discovered that all the databases that get created in SQL
Server 2000 like Master, Model, Northwind, etc are missing. My question is
are they actually missing or do I need to install an add-on to see them?
Spin
> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
> missing.
It is not Enterprise Manager anymore. EM & Query Analyzer have been
combined into a single GUI tool called Management Studio. It should be
under the program files folder for SQL Server 2005, and if not, perhaps you
didn't pay close attention during install. You need to specify that
Management Studio is to be installed by going into Workstation Components.
> low and behold I discovered that all the databases that get created in SQL
> Server 2000 like Master, Model, Northwind, etc are missing.
Well, master and model are certainly there. What does "missing" mean? I
think you need to get Management Studio up and running before you can make
any judgment calls on what's there and what's not.
Oh, and Northwind is no longer a database that ships with SQL Server (same
as pubs). You can install AdventureWorks which is found under Sample
Databases in setup.
|||> What is the name of the file that I click on to bring up the Management
> Studio tool?
The executable is sqlwb.exe. However, the full name should be in a shortcut
on your start menu.
|||I do not have this executable. So I put the CD back in and do what?
Why does Microsoft have to make this so hard?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OY4FPGFfHHA.1244@.TK2MSFTNGP04.phx.gbl...
> The executable is sqlwb.exe. However, the full name should be in a
> shortcut on your start menu.
>
|||>I do not have this executable. So I put the CD back in and do what?
Since you already have the server installed, then open the CD, go to the
tools folder, run setup.exe, and when you get to the screen that asks which
components you want to install, slow down. First you'll go through these
steps:
(a) check "I accept the licensing terms and conditions"
(b) hit " Next > "
(c) wait for prerequisites to be installed (yes it will have to do this
every time)
(d) hit " Next > "
Now you will be at "Welcome to the Microsoft SQL Server Installation Wizard.
(a) hit " Next > "
(b) as long as you don't have any errors on the config check, hit " Next > "
(c) enter your name and company (or leave blank if desired)
(d) hit " Next > "
(e) on the feature selection page, expand Client Components
(f) I would select Connectivity Components and Management Tools (you may
choose others if you wish)
(to select a component, you click on the down arrow next to a component,
and choose "Will be installed on local hard drive")
(g) if you want sample database and/or Books Online, expand the
Documentation, Samples... node
(h) hit " Next > " ... I assume you'll be okay without assistance from here?
> Why does Microsoft have to make this so hard?
I don't think they made it as hard as you make it out to be. And be honest,
did you read "ReadmeSQL2005.htm" and setup instructions, and pay attention
to all screens while you were installing the product?
|||Thank you!
To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
simply expect the products to have the same tools in the same places as the
previous versions. We're all too busy in this life to have company software
throw us curveballs. I think MS should recognize that everyone is busy and
have products be intuitive enough to the point where you don't have to RTM.
Well, maybe RTM is a good thing b/c it keep us IT people in a job! Well,
it's off to the manual and this thing now.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucElrmKfHHA.2376@.TK2MSFTNGP04.phx.gbl...
> Since you already have the server installed, then open the CD, go to the
> tools folder, run setup.exe, and when you get to the screen that asks
> which components you want to install, slow down. First you'll go through
> these steps:
> (a) check "I accept the licensing terms and conditions"
> (b) hit " Next > "
> (c) wait for prerequisites to be installed (yes it will have to do this
> every time)
> (d) hit " Next > "
> Now you will be at "Welcome to the Microsoft SQL Server Installation
> Wizard.
> (a) hit " Next > "
> (b) as long as you don't have any errors on the config check, hit " Next >
> "
> (c) enter your name and company (or leave blank if desired)
> (d) hit " Next > "
> (e) on the feature selection page, expand Client Components
> (f) I would select Connectivity Components and Management Tools (you may
> choose others if you wish)
> (to select a component, you click on the down arrow next to a
> component, and choose "Will be installed on local hard drive")
> (g) if you want sample database and/or Books Online, expand the
> Documentation, Samples... node
> (h) hit " Next > " ... I assume you'll be okay without assistance from
> here?
>
> I don't think they made it as hard as you make it out to be. And be
> honest, did you read "ReadmeSQL2005.htm" and setup instructions, and pay
> attention to all screens while you were installing the product?
>
|||> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
> simply expect the products to have the same tools in the same places as
> the previous versions.
I don't think this expectation is very realistic. If a product does not
evolve, then don't bother upgrading beyond v1.0.
A
|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> I don't think this expectation is very realistic. If a product does not
> evolve, then don't bother upgrading beyond v1.0.
> A
You're right, I was just b%tching and moaning, trying to get my voice heard
by Microsoft. Thanks for listening.
|||Aaron, that tip worked btw! Nice job!
"Spin" <Spin@.spin.com> wrote in message
news:586md5F2ftkduU1@.mid.individual.net...
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
> You're right, I was just b%tching and moaning, trying to get my voice
> heard by Microsoft. Thanks for listening.
Installed SQL Server 2005 but Enterprise Manager is missing and so are the databases like
Gurus,
Installed SQL 2005 for the first time. I noticed Enterprise Manager is
missing. So I went into Configuration Manager since it sounded similar and
low and behold I discovered that all the databases that get created in SQL
Server 2000 like Master, Model, Northwind, etc are missing. My question is
are they actually missing or do I need to install an add-on to see them?
--
Spin> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
> missing.
It is not Enterprise Manager anymore. EM & Query Analyzer have been
combined into a single GUI tool called Management Studio. It should be
under the program files folder for SQL Server 2005, and if not, perhaps you
didn't pay close attention during install. You need to specify that
Management Studio is to be installed by going into Workstation Components.
> low and behold I discovered that all the databases that get created in SQL
> Server 2000 like Master, Model, Northwind, etc are missing.
Well, master and model are certainly there. What does "missing" mean? I
think you need to get Management Studio up and running before you can make
any judgment calls on what's there and what's not.
Oh, and Northwind is no longer a database that ships with SQL Server (same
as pubs). You can install AdventureWorks which is found under Sample
Databases in setup.|||What is the name of the file that I click on to bring up the Management
Studio tool?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uGwi7MEfHHA.1220@.TK2MSFTNGP03.phx.gbl...
>> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
>> missing.
> It is not Enterprise Manager anymore. EM & Query Analyzer have been
> combined into a single GUI tool called Management Studio. It should be
> under the program files folder for SQL Server 2005, and if not, perhaps
> you didn't pay close attention during install. You need to specify that
> Management Studio is to be installed by going into Workstation Components.
>> low and behold I discovered that all the databases that get created in
>> SQL Server 2000 like Master, Model, Northwind, etc are missing.
> Well, master and model are certainly there. What does "missing" mean? I
> think you need to get Management Studio up and running before you can make
> any judgment calls on what's there and what's not.
> Oh, and Northwind is no longer a database that ships with SQL Server (same
> as pubs). You can install AdventureWorks which is found under Sample
> Databases in setup.
>|||> What is the name of the file that I click on to bring up the Management
> Studio tool?
The executable is sqlwb.exe. However, the full name should be in a shortcut
on your start menu.|||I do not have this executable. So I put the CD back in and do what?
Why does Microsoft have to make this so hard?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OY4FPGFfHHA.1244@.TK2MSFTNGP04.phx.gbl...
>> What is the name of the file that I click on to bring up the Management
>> Studio tool?
> The executable is sqlwb.exe. However, the full name should be in a
> shortcut on your start menu.
>|||>I do not have this executable. So I put the CD back in and do what?
Since you already have the server installed, then open the CD, go to the
tools folder, run setup.exe, and when you get to the screen that asks which
components you want to install, slow down. First you'll go through these
steps:
(a) check "I accept the licensing terms and conditions"
(b) hit " Next > "
(c) wait for prerequisites to be installed (yes it will have to do this
every time)
(d) hit " Next > "
Now you will be at "Welcome to the Microsoft SQL Server Installation Wizard.
(a) hit " Next > "
(b) as long as you don't have any errors on the config check, hit " Next > "
(c) enter your name and company (or leave blank if desired)
(d) hit " Next > "
(e) on the feature selection page, expand Client Components
(f) I would select Connectivity Components and Management Tools (you may
choose others if you wish)
(to select a component, you click on the down arrow next to a component,
and choose "Will be installed on local hard drive")
(g) if you want sample database and/or Books Online, expand the
Documentation, Samples... node
(h) hit " Next > " ... I assume you'll be okay without assistance from here?
> Why does Microsoft have to make this so hard?
I don't think they made it as hard as you make it out to be. And be honest,
did you read "ReadmeSQL2005.htm" and setup instructions, and pay attention
to all screens while you were installing the product?|||Thank you!
To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
simply expect the products to have the same tools in the same places as the
previous versions. We're all too busy in this life to have company software
throw us curveballs. I think MS should recognize that everyone is busy and
have products be intuitive enough to the point where you don't have to RTM.
Well, maybe RTM is a good thing b/c it keep us IT people in a job! Well,
it's off to the manual and this thing now. :)
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucElrmKfHHA.2376@.TK2MSFTNGP04.phx.gbl...
> >I do not have this executable. So I put the CD back in and do what?
> Since you already have the server installed, then open the CD, go to the
> tools folder, run setup.exe, and when you get to the screen that asks
> which components you want to install, slow down. First you'll go through
> these steps:
> (a) check "I accept the licensing terms and conditions"
> (b) hit " Next > "
> (c) wait for prerequisites to be installed (yes it will have to do this
> every time)
> (d) hit " Next > "
> Now you will be at "Welcome to the Microsoft SQL Server Installation
> Wizard.
> (a) hit " Next > "
> (b) as long as you don't have any errors on the config check, hit " Next >
> "
> (c) enter your name and company (or leave blank if desired)
> (d) hit " Next > "
> (e) on the feature selection page, expand Client Components
> (f) I would select Connectivity Components and Management Tools (you may
> choose others if you wish)
> (to select a component, you click on the down arrow next to a
> component, and choose "Will be installed on local hard drive")
> (g) if you want sample database and/or Books Online, expand the
> Documentation, Samples... node
> (h) hit " Next > " ... I assume you'll be okay without assistance from
> here?
>> Why does Microsoft have to make this so hard?
> I don't think they made it as hard as you make it out to be. And be
> honest, did you read "ReadmeSQL2005.htm" and setup instructions, and pay
> attention to all screens while you were installing the product?
>|||> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
> simply expect the products to have the same tools in the same places as
> the previous versions.
I don't think this expectation is very realistic. If a product does not
evolve, then don't bother upgrading beyond v1.0.
A|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
>> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
>> simply expect the products to have the same tools in the same places as
>> the previous versions.
> I don't think this expectation is very realistic. If a product does not
> evolve, then don't bother upgrading beyond v1.0.
> A
You're right, I was just b%tching and moaning, trying to get my voice heard
by Microsoft. Thanks for listening.|||Aaron, that tip worked btw! Nice job!
"Spin" <Spin@.spin.com> wrote in message
news:586md5F2ftkduU1@.mid.individual.net...
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
>> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all,
>> I simply expect the products to have the same tools in the same places
>> as the previous versions.
>> I don't think this expectation is very realistic. If a product does not
>> evolve, then don't bother upgrading beyond v1.0.
>> A
> You're right, I was just b%tching and moaning, trying to get my voice
> heard by Microsoft. Thanks for listening.sql
Installed SQL 2005 for the first time. I noticed Enterprise Manager is
missing. So I went into Configuration Manager since it sounded similar and
low and behold I discovered that all the databases that get created in SQL
Server 2000 like Master, Model, Northwind, etc are missing. My question is
are they actually missing or do I need to install an add-on to see them?
--
Spin> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
> missing.
It is not Enterprise Manager anymore. EM & Query Analyzer have been
combined into a single GUI tool called Management Studio. It should be
under the program files folder for SQL Server 2005, and if not, perhaps you
didn't pay close attention during install. You need to specify that
Management Studio is to be installed by going into Workstation Components.
> low and behold I discovered that all the databases that get created in SQL
> Server 2000 like Master, Model, Northwind, etc are missing.
Well, master and model are certainly there. What does "missing" mean? I
think you need to get Management Studio up and running before you can make
any judgment calls on what's there and what's not.
Oh, and Northwind is no longer a database that ships with SQL Server (same
as pubs). You can install AdventureWorks which is found under Sample
Databases in setup.|||What is the name of the file that I click on to bring up the Management
Studio tool?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uGwi7MEfHHA.1220@.TK2MSFTNGP03.phx.gbl...
>> Installed SQL 2005 for the first time. I noticed Enterprise Manager is
>> missing.
> It is not Enterprise Manager anymore. EM & Query Analyzer have been
> combined into a single GUI tool called Management Studio. It should be
> under the program files folder for SQL Server 2005, and if not, perhaps
> you didn't pay close attention during install. You need to specify that
> Management Studio is to be installed by going into Workstation Components.
>> low and behold I discovered that all the databases that get created in
>> SQL Server 2000 like Master, Model, Northwind, etc are missing.
> Well, master and model are certainly there. What does "missing" mean? I
> think you need to get Management Studio up and running before you can make
> any judgment calls on what's there and what's not.
> Oh, and Northwind is no longer a database that ships with SQL Server (same
> as pubs). You can install AdventureWorks which is found under Sample
> Databases in setup.
>|||> What is the name of the file that I click on to bring up the Management
> Studio tool?
The executable is sqlwb.exe. However, the full name should be in a shortcut
on your start menu.|||I do not have this executable. So I put the CD back in and do what?
Why does Microsoft have to make this so hard?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OY4FPGFfHHA.1244@.TK2MSFTNGP04.phx.gbl...
>> What is the name of the file that I click on to bring up the Management
>> Studio tool?
> The executable is sqlwb.exe. However, the full name should be in a
> shortcut on your start menu.
>|||>I do not have this executable. So I put the CD back in and do what?
Since you already have the server installed, then open the CD, go to the
tools folder, run setup.exe, and when you get to the screen that asks which
components you want to install, slow down. First you'll go through these
steps:
(a) check "I accept the licensing terms and conditions"
(b) hit " Next > "
(c) wait for prerequisites to be installed (yes it will have to do this
every time)
(d) hit " Next > "
Now you will be at "Welcome to the Microsoft SQL Server Installation Wizard.
(a) hit " Next > "
(b) as long as you don't have any errors on the config check, hit " Next > "
(c) enter your name and company (or leave blank if desired)
(d) hit " Next > "
(e) on the feature selection page, expand Client Components
(f) I would select Connectivity Components and Management Tools (you may
choose others if you wish)
(to select a component, you click on the down arrow next to a component,
and choose "Will be installed on local hard drive")
(g) if you want sample database and/or Books Online, expand the
Documentation, Samples... node
(h) hit " Next > " ... I assume you'll be okay without assistance from here?
> Why does Microsoft have to make this so hard?
I don't think they made it as hard as you make it out to be. And be honest,
did you read "ReadmeSQL2005.htm" and setup instructions, and pay attention
to all screens while you were installing the product?|||Thank you!
To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
simply expect the products to have the same tools in the same places as the
previous versions. We're all too busy in this life to have company software
throw us curveballs. I think MS should recognize that everyone is busy and
have products be intuitive enough to the point where you don't have to RTM.
Well, maybe RTM is a good thing b/c it keep us IT people in a job! Well,
it's off to the manual and this thing now. :)
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ucElrmKfHHA.2376@.TK2MSFTNGP04.phx.gbl...
> >I do not have this executable. So I put the CD back in and do what?
> Since you already have the server installed, then open the CD, go to the
> tools folder, run setup.exe, and when you get to the screen that asks
> which components you want to install, slow down. First you'll go through
> these steps:
> (a) check "I accept the licensing terms and conditions"
> (b) hit " Next > "
> (c) wait for prerequisites to be installed (yes it will have to do this
> every time)
> (d) hit " Next > "
> Now you will be at "Welcome to the Microsoft SQL Server Installation
> Wizard.
> (a) hit " Next > "
> (b) as long as you don't have any errors on the config check, hit " Next >
> "
> (c) enter your name and company (or leave blank if desired)
> (d) hit " Next > "
> (e) on the feature selection page, expand Client Components
> (f) I would select Connectivity Components and Management Tools (you may
> choose others if you wish)
> (to select a component, you click on the down arrow next to a
> component, and choose "Will be installed on local hard drive")
> (g) if you want sample database and/or Books Online, expand the
> Documentation, Samples... node
> (h) hit " Next > " ... I assume you'll be okay without assistance from
> here?
>> Why does Microsoft have to make this so hard?
> I don't think they made it as hard as you make it out to be. And be
> honest, did you read "ReadmeSQL2005.htm" and setup instructions, and pay
> attention to all screens while you were installing the product?
>|||> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
> simply expect the products to have the same tools in the same places as
> the previous versions.
I don't think this expectation is very realistic. If a product does not
evolve, then don't bother upgrading beyond v1.0.
A|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
>> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all, I
>> simply expect the products to have the same tools in the same places as
>> the previous versions.
> I don't think this expectation is very realistic. If a product does not
> evolve, then don't bother upgrading beyond v1.0.
> A
You're right, I was just b%tching and moaning, trying to get my voice heard
by Microsoft. Thanks for listening.|||Aaron, that tip worked btw! Nice job!
"Spin" <Spin@.spin.com> wrote in message
news:586md5F2ftkduU1@.mid.individual.net...
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:OD8dnuPfHHA.1216@.TK2MSFTNGP03.phx.gbl...
>> To be honest back, I never read ReadmeSQL2005.htm. I never RTM at all,
>> I simply expect the products to have the same tools in the same places
>> as the previous versions.
>> I don't think this expectation is very realistic. If a product does not
>> evolve, then don't bother upgrading beyond v1.0.
>> A
> You're right, I was just b%tching and moaning, trying to get my voice
> heard by Microsoft. Thanks for listening.sql
Installed SQL 2005, but where is the management tools?
I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
Jason
What edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/d...displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
Jason
What edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/d...displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>
Installed SQL 2005, but where is the management tools?
I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/...&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/...&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>
Installed SQL 2005, but where is the management tools?
I installed the SQL2005, but cannot find the management tools like
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>sql
Enterprise Manager in 2000
During Installation, i selected advanced
and select to install
all in Database Service,
all in Client Components and
the SQL BOL in Documentation, Sample, and Sample Database.
But after the installation complete, I cannot locate the SQL Management
Studio
In my program list, it only has
SQL Server 2005\Configuration Tools
SQL Server 2005\Documentation and Tutorials
I checked the Add/Remove Program in Control Panel, it show followings are
installed
MS SQL Server 2005
MS SQL Server 2005 Backward compatibility
MS SQL Server 2005 BOL (English)
MS SQL Server Natvie Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
but no any manager tools.
I tried to insert to dvd again and select to install the Client Component
but the wizard said the component i choose is already installed.
So what is the problem?
P.S. OS WinXP SP2
already have SQL 2000 Dev Ed installed with Enterprise Manager.
Any Help?
Thanks in Advanced
JasonWhat edition did you install?
--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||You need to install the workstation tools if you installed the standard or
enterprise edition.
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||This [1] is the only current option for SQL Express.
<%= Clinton Gallagher
[1]
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en
"Jason Chan" <no@.email.com> wrote in message
news:ugcrTXT6FHA.2036@.TK2MSFTNGP14.phx.gbl...
>I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>|||Do you have Internet Explorer 6 SP1 or higher on the machine?
"Jason Chan" wrote:
> I installed the SQL2005, but cannot find the management tools like
> Enterprise Manager in 2000
> During Installation, i selected advanced
> and select to install
> all in Database Service,
> all in Client Components and
> the SQL BOL in Documentation, Sample, and Sample Database.
> But after the installation complete, I cannot locate the SQL Management
> Studio
> In my program list, it only has
> SQL Server 2005\Configuration Tools
> SQL Server 2005\Documentation and Tutorials
> I checked the Add/Remove Program in Control Panel, it show followings are
> installed
> MS SQL Server 2005
> MS SQL Server 2005 Backward compatibility
> MS SQL Server 2005 BOL (English)
> MS SQL Server Natvie Client
> MS SQL Server Setup Support Files
> MS SQL Server VSS Writer
> but no any manager tools.
> I tried to insert to dvd again and select to install the Client Component
> but the wizard said the component i choose is already installed.
> So what is the problem?
> P.S. OS WinXP SP2
> already have SQL 2000 Dev Ed installed with Enterprise Manager.
> Any Help?
> Thanks in Advanced
> Jason
>
>sql
installed msde database server desktop edition and well...
its sql server 7.0 and im looking for the service network utility and service manager that it didnt come with.. where can i download it?Did you install MSDE 1.0? That is indeed SQL Server 7.0. You should have instead installed MSDE 2000 which is the more recent version and is SQL Server 2000.
Monday, March 19, 2012
Installation trouble again...
Hi All
Now I got the right order and installed vs net and then rep s.
Now I have the report builder.....but when starting report manager I have
no toolbar ?
Any ideas...?
I think I've seen this error before when trying to install - don't remember
the solution though...
/Michael V.Had enabled anonymous ... removed that and now it works...
"Michael Vardinghus" <michaelvardinghus@.hotmail.com> wrote in message
news:eY0aCSHgFHA.3936@.tk2msftngp13.phx.gbl...
> Hi All
> Now I got the right order and installed vs net and then rep s.
> Now I have the report builder.....but when starting report manager I have
> no toolbar ?
> Any ideas...?
> I think I've seen this error before when trying to install - don't
remember
> the solution though...
> /Michael V.
>
Now I got the right order and installed vs net and then rep s.
Now I have the report builder.....but when starting report manager I have
no toolbar ?
Any ideas...?
I think I've seen this error before when trying to install - don't remember
the solution though...
/Michael V.Had enabled anonymous ... removed that and now it works...
"Michael Vardinghus" <michaelvardinghus@.hotmail.com> wrote in message
news:eY0aCSHgFHA.3936@.tk2msftngp13.phx.gbl...
> Hi All
> Now I got the right order and installed vs net and then rep s.
> Now I have the report builder.....but when starting report manager I have
> no toolbar ?
> Any ideas...?
> I think I've seen this error before when trying to install - don't
remember
> the solution though...
> /Michael V.
>
Friday, February 24, 2012
Installation issues with MS Server 2003
okay,
so I've installed reporting services using mostley default configuration... but when you navigate to the report manager you get a 404 error.
any thoughts?
thanks in advance
Kay so it turned out that when we re-installed IIS on MS Server 2003 it set the .NET version to 1.0 as a default... change to 2.0 and its alll gravy.Installation Issues
I have installed MSDE2000A on both 2000 and XP Pro machines, the install
appears to go fine. After the reboot, the service manager icon is empty,
when I look for the services in the drop down in the Service Manager it is
empty. In the system services screen, I have made sure all three services
are running. I cannot restore a database on this machine or connect to it
with Enterprise Manager. Any thoughts or help is appreciated.
Hi ,
First of all when you say the msde installtion "appears" to be installed
fine , have you verified the setup log file to see if the msde did indeed
install sucessfully or if there are any messages
Please follow the steps mentioned below to solve the problem:
1) verify the setup log for any error messages (most probably the msde
wasnever installed properly in the first place)
2) Can you see the msde services in the services . Try to start them
manually
3) Connect to the instance locally with the followong command
<installdrive>\program files\microsoft sql server\80\tools\binn \osql -E
-Sservername\instancename
do not use the -S parameter if default instance is used.
4) If you connect successfully then the msde is correctly installed.
5) Ensure that the tcp/ip is enabled using the client configuration tool
(cliconfg.exe) and also the server network utility (svrnetcn.exe )
6) try manually typing the server name in the service manager when it comes
out empty and then try to connect
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I have seen this on Win 2003 where MSDE-Rel A is installed using an Instance
Name and there is no default instance.
Tim Morrison
"GrumpyOldMan" <GrumpyOldMan@.discussions.microsoft.com> wrote in message
news:7D74D170-FE18-4DAB-870C-DDCD89422968@.microsoft.com...
>I have installed MSDE2000A on both 2000 and XP Pro machines, the install
> appears to go fine. After the reboot, the service manager icon is empty,
> when I look for the services in the drop down in the Service Manager it is
> empty. In the system services screen, I have made sure all three services
> are running. I cannot restore a database on this machine or connect to it
> with Enterprise Manager. Any thoughts or help is appreciated.
appears to go fine. After the reboot, the service manager icon is empty,
when I look for the services in the drop down in the Service Manager it is
empty. In the system services screen, I have made sure all three services
are running. I cannot restore a database on this machine or connect to it
with Enterprise Manager. Any thoughts or help is appreciated.
Hi ,
First of all when you say the msde installtion "appears" to be installed
fine , have you verified the setup log file to see if the msde did indeed
install sucessfully or if there are any messages
Please follow the steps mentioned below to solve the problem:
1) verify the setup log for any error messages (most probably the msde
wasnever installed properly in the first place)
2) Can you see the msde services in the services . Try to start them
manually
3) Connect to the instance locally with the followong command
<installdrive>\program files\microsoft sql server\80\tools\binn \osql -E
-Sservername\instancename
do not use the -S parameter if default instance is used.
4) If you connect successfully then the msde is correctly installed.
5) Ensure that the tcp/ip is enabled using the client configuration tool
(cliconfg.exe) and also the server network utility (svrnetcn.exe )
6) try manually typing the server name in the service manager when it comes
out empty and then try to connect
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||I have seen this on Win 2003 where MSDE-Rel A is installed using an Instance
Name and there is no default instance.
Tim Morrison
"GrumpyOldMan" <GrumpyOldMan@.discussions.microsoft.com> wrote in message
news:7D74D170-FE18-4DAB-870C-DDCD89422968@.microsoft.com...
>I have installed MSDE2000A on both 2000 and XP Pro machines, the install
> appears to go fine. After the reboot, the service manager icon is empty,
> when I look for the services in the drop down in the Service Manager it is
> empty. In the system services screen, I have made sure all three services
> are running. I cannot restore a database on this machine or connect to it
> with Enterprise Manager. Any thoughts or help is appreciated.
Sunday, February 19, 2012
Installation Error on MSDE
I am trying to install MSDE on a Win2K machine. The installation appears to go successfully, but when the Sql Server Service Manager tries to start, I get the error "The specified service does not exist as an installed service". Sure enough, when I go to the servcies, the MSSQL service is not in the list. I have tried to install twice with the same results. I was thinking about self registering the service, but I do not know what service is causing the problem. Anyone can think of anything?Read the sqlstp.log file - this should give you some information as to why it failed.|||Thanks, I forgot about the log file.|||Check it out and reply back.|||I did a search for the file and it was not created. Any other ideas?|||Check Services applet and see if you have a named instance-based service. I may be wrong but I think that's the default for MSDE.|||When you mentioned that the installation appeared to go successfully - what feedback did the process give you ?|||The process goes throguh the install and then prompts to reboot the computer. I do that and a message comes up registery services, that is when the error first appears. I am not using a named instance, so if I am not mistaken the instace then comes from the local computer name. THe computers name is "server" (unique, huh?).|||Do you see msde in the control panel under Add/Remove programs ?|||No, but we do have a Microsoft Sql Server folder created under Program Files.|||Does this folder exist due to the installation process or do you have sql server installed ?|||This computer does not have Sql Server installed|||Look for sqlsp/sqlstp/setup log files in your \winnt directory. Also, see if an errorlog exists under the sql server directory.|||Did not find any of these log files. Could they be in the System32 folder?|||Enable verbose logging when you install.|||Also, make sure that your server service is started before you install.
Subscribe to:
Posts (Atom)