Re: SSMS problem PS

Connect using SQLCMD and use below commands:
CREATE LOGIN
CREATE USER

--
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:46b6e5ea$0$28684$4c368faf@xxxxxxxxxxxxxxxxx
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: problem with query moving data from 1 dbase to another.
    ... You register a SQL Server instance, where such an instance can have several databases. ... Tibor Karaszi, SQL Server MVP ... > you know how to connect to an existing database, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: error 80020009 HELP!!!
    ... Check your SQL Server event logs for any problems. ... Mike Epprecht, Microsoft SQL Server MVP ... > when they try to access the database through a web browser. ... > info by performing a database restore? ...
    (microsoft.public.sqlserver.server)
  • Re: View Security
    ... SQL Server MVP ... Columnist, SQL Server Professional ... The user can see list of other users who can login into the database. ... able to see all database structue such as view/table/sp definitions. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I Allow SQL DB dump job through a firewall?
    ... I'll try to setup a process that grabs the database on a regular basis after ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Use SQL to get Filename...
    ... "Mandy" wrote in message ... >> SQL Server MVP ... >>>> Take a look at the sysfiles table, available in each database. ...
    (microsoft.public.sqlserver.server)