Gone through already

Connecting with SQL Authentication.

Account : sa account and sysadmin account.

Please post suggestions and thoughts if any.

Yes,

All the services are running...

Its a lot of hectic from past 2 days.....

When i tried connectiing then server through Query Analyzer there is an error:

Server: Msg 17, Level 16, State 1

[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied.

<<< Edited - changes done >>>

1. we have three SQL Server 2005 Instances (one default instance and two named instance) - 3439, 4312, 1413

2. Then we installed SQL Server 2000...

SQL Server 2005 instances has different port numbers

SQL 2000 is using 1433

Could you please confirm the following:

1. SQL Browser service is running on the server.

2. On the firewall put the exception for sqlbrowser.exe and/or UDP port 1433.

3. Can you get to...

Yes.

Its already selected.

Anyone faced this issue ?

Can anyone help on this... Suggestions appreciated.

Did all the things..

We have SQL 2005 installed already with two instances. After then for one of our processes we need SQL 2000.

We installed SQL 2000 with SP4 - Enterprise...

1. Take a backup and do adding the log file to another disk drive.

2. Increase the log file autogrowth to 10% if have space.

3. shrink log file after taking a...

http://support.verio.com/documents/view_article.cfm?doc_id=3696

Hi,

How about this ?

http://technet.microsoft.com/en-us/library/ms175495.aspx

Sorry to all,

Was out of station.

Yes its an application which runs on .NET and Framework.

Table has one cluster(PK) and one non cluster index. For every user this table hits by...