Is My Sql Server Installed Properly..? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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)

Is My Sql Server Installed Properly..?

Author

Topic

Ashfaque_Online
Starting Member

6 Posts

Posted - 2005-02-23 : 03:32:09

Hi,

I am new to MSDE. B4 I was dealing with only Access mdb files. There is no problem for me on this issue. But as a part of my little improvement I am tyring to use MSDE2000A as my back end and so ADP would be my FE.

I installed MSDE2000A on my pc (i am one of our network user in my company). While installation I used following command line.
setup.exe SAPWD="my password"
I didnt used complete syntax like
setup.exe SAPWD="my password" SECURITYMODE=SQL

Then I entered in Binn of MSSQL thru command prompt to run sqlserver.exe. It gives me error like follows;

'sqlserver.exe' is not recognized as an internal or external command, operable program or batch file.

But an icon of server is appreared at bottom line of my desktop showing that "Running-\\Ashfaquepc - MSSQL Server"

I successfully exported a trial ADP db to the MSSQL server as a practice. Created one form to see the data. But did not drag any command button over the form as they are not working like MS Access mdb forms.

1. How can I add records in table thru form's command button? I mean where to write the code?

2. To run osql sa mypassword, what should I do now? Please advice

With kind regards,

Ashfaque

Ashfaque_Online
Starting Member

6 Posts

Posted - 2005-02-27 : 01:10:11

An icon of server is appreared at bottom line of my desktop showing that "Running-\\Ashfaquepc - MSSQL Server"

Does it mean that MSSQL Server is installed in proper way? If not what should I take step to run osql?

Please advise. Badly waiting for reply.

with kind regards,
Ashfaque

andy8979
Starting Member

36 Posts

Posted - 2005-04-05 : 07:17:33

Try the following command on the command prompt--
Run this command only after starting the sqlservice manager.
osql -L
Check if the list shows you your server name ie "Ashfaquepc"
If your server name is listed in the list means your sql server is installed properly

For logging in check the following steps.

if not then check if the sqlserver is stopped or running.

then
run - osql -SAshfaquepc -E

Check if you get connected to the sql server if no then try

osql -SAshfaquepc -Usa -P"your sql password"

if the gets connected then your sql is installed properly.

Then you can connect to the msde as you get connected to the sql server -- ie through the connection string.

Anuj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources