Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
554
Views
5
Helpful
5
Replies

Installing ART

l.kellett
Level 1
Level 1

‎08-09-2002 02:28 AM - edited ‎03-12-2019 08:17 PM

Whilst installing ART, when it asks for a 'Login Name' and 'Password', to connect to the SQL server, it comes back with a message 'Unable to connect to the SQL Server', I have used the following accounts to try and connect, sa,administrator and SQLSvc. Is there a particular account I need to use ?

Labels:
0 Helpful
5 Replies 5

mimckee
Level 1
Level 1

‎08-09-2002 07:32 AM

You need to use sa and the sa password. You can verify you have the correct sa password by going to start -> programs -> microsoft sql 7.0 -> query analyzer. Select SQL server authentication and put sa as the user and the password you think it is. If you get connected you have the correct password.

Thank you,

-Mckee

0 Helpful

l.kellett
Level 1
Level 1
In response to mimckee

‎08-12-2002 12:55 AM

Thanks for your reply. I can successfully connect to the SQL server using query analyzer, but I still get the error mesage 'Login for user sa failed. Setup couldn't connect to the SQL server'. Are there any traces I can do on the SQL server to see why the login is failing ?

0 Helpful

bphelps
Level 2
Level 2
In response to mimckee

‎01-15-2003 02:13 PM

And what if you cannot remember this name and password? Is there a way to retrieve it, reset it? Anything? Can I reinstall SQL to reset the password without screwing up the data?

0 Helpful

asparrowhawk
Level 1
Level 1

‎08-12-2002 01:03 AM

I've come across this a couple of times, below is the workaround from TAC - you may have to run through this several times before the correct file location is picked up.

This bug is a duplicate of CSCdv34563. The osql.exe is getting backed up in temporary location during SQL Service Pack3 installation. The same has been verified by the following steps by the submitter.

a) Run the ART installation.

b) When you get the Logon failure error, do not click OK or cancel.

c) Open the file "C:\Ciscowebs\art\tempfiles\sqlbat.bat", and check the first

line in the file.

d) It has the path to osql.exe being used by the installation. In case it is

not "C:\MSSQL\binn\osql.exe" then, open the folder as mentioned in the file

and change the property of the folder to show hidden files and folders.

e) Rename the osql.exe file.

f) Cancel the ART installation and restart the installation.

The steps can be continued till the installation goes through successfully.

h.chia
Level 1
Level 1
In response to asparrowhawk

‎12-03-2002 03:37 AM

Thank you for pointing me in the right direction.

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents