Windows Forum

Ask something
Discussion Locked

cannot log to sqlserver 7.0 using sa

0 helpful
3 replies

by rhiegen

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear Friends,

During the installation of SMS 2.0 in a Server running Win 2k server as I went to the step where SMS would create the database it needs to work, I mention the user sa and the password. When I proceeded received the message saying sacouldn?t log to sqlserver, which is installed in the same server I tried to install SMS, and the sa password was created by myself. Is there any configuration I must make in SQL server 7.0 or SMS 2.0 in order to permit this logging and database creation?
Any ideas?

Thanks a lot in advance,

Paulo

3 replies

by joseph moore

No, as long as the SMS server can reach port 1433 on the SQL Server, then you should be able to log in using the SA account.
Now, you do know the password for the SA account, right? And are you sure you were not hit by the Spiga worm that started going around a few weeks ago? That worm was able to change the password for the SA account IF the SA account had a blank password. The worm changed the password to a random 4-digit number.
So, make sure you can connect on the SQL Server itself with the SA account and whatever the password is. If you can, and if the SMS box can hit port 1433 on the SQL Server box, then you should be able to log in from SMS also.

hope this helps

by joseph moore

You can set up an ODBC connection from the SMS server to the SQL Server.
Click on Start -> Settings -> Control Panel -> Administrative Tools -> Data Source (ODBC)
Click the System DSN tab, then click the Add button.
Select the SQL Server driver.
You will then have a wizard start that will ask you for the SQL Server name (put either the machine name or IP address for the SQL Server), the database name and a description. Fill all that in.
The next page will ask you for what kind of authentication you want to use. Select SQL Server Authentication. A login and password boxes come up. Put in SA for the login, and the password for the SA account.
The next page, you should click the drop-down and select the database on the SQL Server you want to connect to.
The last page is irrelevant (imo).
You then should see a button called Verify Connection. Click it. If everything was filled out right, you should get a Success message.
Click OK.

That's it.

From that point on, just reference the System DSN ODBC connection from the SMS box to connect to the SQL Server.

This discussion is closed to new replies.