I have osql utility in my client version, but i need to have sqlcmd utility.
Please advice how do I install sqlcmd.exe in my SQL Server client?SQLCMD was introduced in SQL Server 2005. For SQL Server 200, you can either use the OSQL.exe or the ISQL.exe tool.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
From everything I read SQL Server Management Studio is only installed when you install SQL 2005 server.
I am using SQL Server 2000 sp3 so I have the Enterprise Manager.
Is there a way to install it or some other tool I can use to manage/view my sql everywhere database?
You could install the SQL Express management Tools and try them.
|||I figured it out and forgot to post the solution. On the SQL Server 2005 install cd you can install the tools.sqlHi All,
I'm pretty new to SQL anything... I'm wondering if there is a way to install just Enterprise Manager on my local workstation so I can open it up and manage or at least look at all of the SQL db's that are spread out on various servers - all in one place?
1. How can I install just Enterprise Manager (if possible). I ran setup on SQL2000 Personal Addition and it didn't look like it was going to get to a 'custom setup' screen so I cancelled, it looked like it was going to install SQL Server 2000 and all components (maybe this is what I have to do, I don't know).
2. If I install SQL2000 Enterprise Manager, am I able to access and view SQL 6.5 and SQL 7.0 and SQL 2000 databases all together?
Thanks so much.
Chris
You could install EM only with other client tools: the option is presented in the installer.
|||FYI Em does not support SQL 6.5 or SQL 2005, it does support 7 and 2000|||Thanks everyone! I found them.|||Where did you find them?|||Just keep going through the install of SQL server and it will either bring you to a custom option (where you can choose just the utilities) or it will bring you to a page that you can check a radio button to just install the utilities.
|||Got it thanks!To add an instance you need to run setup and choose a named instance to install.
Svrnetcn.exe is (quoting BOL 2000) “The Server Network utility is used to manage the server Net-Libraries”. On SQL 2005 similar functionality is provided by SQL Server Configuration Manager: http://msdn2.microsoft.com/en-US/library/ms174212.aspx
Regards,
Boris.
|||So far I have only found how to add already existing instances, I have to actually create one.|||Could you please give more details?
Is running setup, selecting install SQL Server Database Engine and then Advanced, then Named instance and giving it a new name does not work for you? If not, why not?
Boris.
|||Sorry Boris, my browser setting weren't letting me run the auto setup. the new dvd is a little different and the setup.exe I was choosing in the explorer window wasn't installing the engine. I found the right one though.
I still have a question from this experience, is there no way to do this from a command line like we did with the msde instance?
|||Take a look at this topic:
How to: Install SQL Server 2005 from the Command Prompt
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Regards,
Boris.
|||Thanks for the helpquote:
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
quote:|||it came on a separate CD purchased in 2001, don't know how it is now.
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>
quote:
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
quote:
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
up on my taskbar. I didn't install SQL Server. The icon
starting showing up after I ran Windows Update. SQL Server is not
listed in my Add/Remove programs, and I can't seem to find the
application anywhere on my laptop. I have a new (less than 6
months old) Dell laptop running WinXP Professional. I seem to
have lost my Internet connectivity at about the same time this icon
showed up. I did a system restore back to before I installed the
Windows Update, and the icon disappeared. However, it has now
shown up again. Anybody know what's going on with this?
Does some other app use SQL server? I really need to fix this
problem.
Thx,
j
See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005
http://msdn2.microsoft.com/en-us/library/aa337087.aspx
|||
Hi
By reading at your description, I can't really tell what has happen to your machine.
But please try the following:
1. From your desktop, right click on "my computer" icon.
2. Select "manage" from the pop-up menu.
3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.
4. select "Services" node
5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"
If there are any listed, could you please post the list for furthur analysis?
Thank you. :-)
|||I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.
Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?
Thx,
|||Hi,
Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.
Hemantgiri S. Goswami
but I need to do either a Silent or Unattended install.
Does anyone know how to do this? Does anyone know the
command-line command to do this?
I tried using...
sql70sp4.exe -a -f1 "unattend.iss"
....but that didn't work. It popped up a window asking where I
should extract the contents of the .exe (that shouldn't be appearing
either) and then after it extracted it didn't do anything else.
Any help is greatly appreciated.
see if this helps
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q233312
I have a Systema that uses a DataBase an I Want to Install y other machines, I need to Install a Visual Studio Program that uses a Database, How do I Install The Visual Studio Program, the Sql Server Express, and the existing DataBase.
Thanks in Advance, Santiago
Visual Studio can be installed using the appropiate installer from the VS disks, SQL Server comes with the Visual Studio, so you either use the shipped version with Visual Studio and update it laterone with the SP2 Service Pack or leave the SQL Server Express edition out and install it seperately by using the most recent download from Microsoft. The database can be distributed by using SQL Backup and Restore (Backup the databases on the source server and restore them on the other clients)
Jens K. Suessmeyer
http://www.sqlserver2005.de
Perhaps these resources will help:
SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648
I have a Systema that uses a DataBase an I Want to Install y other machines, I need to Install a Visual Studio Program that uses a Database, How do I Install The Visual Studio Program, the Sql Server Express, and the existing DataBase.
Thanks in Advance, Santiago
Visual Studio can be installed using the appropiate installer from the VS disks, SQL Server comes with the Visual Studio, so you either use the shipped version with Visual Studio and update it laterone with the SP2 Service Pack or leave the SQL Server Express edition out and install it seperately by using the most recent download from Microsoft. The database can be distributed by using SQL Backup and Restore (Backup the databases on the source server and restore them on the other clients)
Jens K. Suessmeyer
http://www.sqlserver2005.de
Perhaps these resources will help:
SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648
