What do you mean by "osql -U sa -P password ?"

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

MSDE (2000)

What do you mean by "osql -U sa -P password ?"

Author

Topic

Ashfaque_Online
Starting Member

6 Posts

Posted - 2005-09-18 : 07:00:05

Hi gents,

i installed MSDERelA on my pc and depoloyed some of the tables from MS Access successfully. They are dummy tables just for testing.

I entered in Cd>program files>Microsoft SQL Server>MSSQL>Binn
and at the command prompt I tneet to get log in as per the above format which is :

osql -U sa -P password

My password of msde is let us say "nissan" and my user id is let us say "XXX" so do what would be he correct format .?

Kindly help, bcz after success it should bring up "1>" but it give -1.

Any help would highly appreciated.

Regards,

Ashfaque

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-09-18 : 14:21:36

You sure you typed in the right username and password? Are there multiple MSSQL services running on this box (you can check in services)? Have you tried using the -E switch?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Ashfaque_Online
Starting Member

6 Posts

Posted - 2005-09-19 : 01:54:12

Thanks derrickleggett,

I am sure I typed correct username and password. To be honest I am new bee to MSDE.
No I did not try using the -E switch.

Regards,
Ashfaque

Ashfaque_Online
Starting Member

6 Posts

Posted - 2005-09-19 : 02:20:04

Hi again derrickleggett,,

As there were no important data kept, I removed my MSDE from control panel--add remove programs and then re-installed as follows. Please correct me if I am wrong:

From the command prompt in Binn directory of MSSQL I typed the following command line:

setup.exe SAPWD="since1965" SECURITYMODE=SQL

It installed smoothly and a server icon appeared on right side down of my monitor after reboot. When keep curson over icon it displays "Running - \\ASHFAQUEPC - MSSQLServer"

Upto here (as per Mr. Kristen's article displayed in this forum under Getting Starged (MSDE)) its ok.. I again from the command prompt entered in Binn directory and typed as follows:

sqlserver.exe {enter}

It says 'sqlserver.exe' is not recongnized as internal or external command, operable program or batch file.

NOW WHAT NEXT ?

Please advice me step-by-step with your valued guidelines.

With kind regards,
Ashfaque
XP User

p.s. The sa password is real one I mentioned above.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources