Re: SSMS problem PS

Could you tell me how to get a user accounts back on SQL 2005?
I see no way of doing it and I got a web site that hs been down for 2 days because it no longer has a user account for the database.

I cant find anything on google.

Thanks

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:E43E1B32-4066-43A0-B7CA-3EA2FA4A6BBD@xxxxxxxxxxxxxxxx
I've never installed from DC so I don't know which disc it is on. But if you start setup, you will find that SSMS is installed in "Client Components" (or some similar name).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"GeekBoy" <nobody@xxxxxxxxxxx> wrote in message news:46b6d9e7$0$20582$4c368faf@xxxxxxxxxxxxxxxxx

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:A946D969-7DDD-4C1B-8005-911F49D8437E@xxxxxxxxxxxxxxxx
I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database.

No, that is not the case. I have both VS and SSMS on a number of machines, and I don't use VS to manage my databases. I'd check of you have the exe file for SSMS installed. The name of the file is SqlWb.exe. And the full path (on my machine) is:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe




I searched all of the Program Files folders and cannot find any such file named that.

Is SSMS on disc one or two?
I installed All I could on disc one

Thanks for the reponse

--




Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"GeekBoy" <geek@xxxxxxx> wrote in message news:46b67c6f$0$8913$4c368faf@xxxxxxxxxxxxxxxxx
Doing some reading and.
I found out that the reason SSMS is not showing up is because Visual Studio 2005 is installed and you have to use its software to deal with the database.


However I have run into two problems.
First is modifying the data. I want to insert more data into the tables, but cannot.

The other problem is adding a new user to SQL server for the purpose of having a web site that uses that database.
In 2000 version , one only needed to use Enterprise Manager

How can I do both?

Thanks


"GeekBoy" <geek@xxxxxxx> wrote in message news:46b65e81$0$30655$4c368faf@xxxxxxxxxxxxxxxxx
I finally got my other problems corrected, but a new one has popped up.

SSMS is installed, but does not show up in the START menu in the SQL 2005 group as it is suppose to.

Any other way of executing it?

Thanks






.

Relevant Pages

  • Re: Enterprise Manager Newbie Question
    ... "Remember password" option when running SSMS? ... Tibor Karaszi, SQL Server MVP ... why don't you write a short backup script using the SQLCMD utility ... Senior Database Administrator ...
    (microsoft.public.sqlserver.tools)
  • Re: VPN over wireless
    ... Do you want to give the students user accounts so that they can access LAN ... Is the database forms they input to connected to the SQL server? ... I am setting up a separate network for Guest access using a wireless ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000 EM vs. SQL Server 2005 MS
    ... Of course, SSMS will mature over time, for instance based on feedback at http://connect.microsoft.com/sqlserver. ... Tibor Karaszi, SQL Server MVP ... > database properties' selection. ... not work with some functionality in SQL Server. ...
    (microsoft.public.sqlserver.tools)
  • Re: Export AD information into a SQL Database
    ... We're looking to import user and computer information from AD into an SQL ... Database. ... We currently have in excess of 900 user accounts and need to check ... See tip 7714 » What attribute names can I use with the user filtered dsquery command? ...
    (microsoft.public.windows.server.active_directory)
  • Re: Strange - grant alter on role = cannot see securables for user
    ... "alter role" on a new db role developed for the app hitting the database. ... My SQL 2005 clustered instance is at Svc Pack 2, ... SSMS client is at Svc pack 3. ...
    (microsoft.public.sqlserver.security)
Loading