Discussion Locked

SQL 2000 server/ODBC

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hello. I have installed SQL server 2000 personal edition on a desktop PC to establish a local SQL server for databases connecting via ODBC data source. When I attempt to SQL server verify authenticity of the databases login id, it tells me "connection failed"...SQL server error 11001...SQL server error:6 I attempted to work with the vendor who provided my company with this s/w and advised that sql server 2000 needs to be used, but, have no idea as to how it should be set up?? Any ideas as to what I should do? Please e-mail me at rcelentano@hertz.com

2 replies

by dr. soft

You didn't mention the tool you are using for administrating you SQL server. Something like 'Enterprise Manager' that only ships with a full blown lisnced version of SQL Server 2000.
If you don't have any thing to manage the sql server then proceed as follow;
Un-install your current server installation and restart the PC. Re-install the SQL Server and at its step-7 titled 'Services Accounts' check the Radio-button 'use the same account for each service' and under the 'Service Settings' heading, check the radio-button 'Use the local system account'. Thats all what is needed.

by chandrasekar.vijayakumar

INSTALLATION PROCEDURE FOR SQL SERVER:

Run SQL_Standard_2000\setup.bat from CD.

Click Next

Select Local Computer option and Click Next

Select create a new instance of SQLServer or Install Client Tool option and click Next

Select Server and Client Tool option and click Next

I have mailed u to your e mail id too

Click Next by selecting Default option

Select Custom option and click Next

Click Next by Default Seletion.

Click Next by selecting the option as shown

Select Mixed mode option and enter pwd ?? and click Next

Select Collation Designator Option, select Latin1_General from the dropdown List Box and Check the Binary Option from the Sort Order
In order to set the collation as Latin1_general_BIN.

Click Next

Click Next

Select per seat for option, devices=50 and click Continue.

Service Pack Install

Run \SQL_Standard_SP3A\SP3A\setup.bat from CD to install servicepack3

Click Next

Click Next

Enter PWD ?? and Click Next

Click Continue by selecting the option as Shown

Click OK

This discussion is closed to new replies.