June 1, 2011 at 10:00 pm
We have a SQL Server 2000 Enterprise Edition in our domain server.When I Connect this Server from SQL Server 2005 Management Studio,it takes long time to connect and very slow.pls advise how to solve this problem.
June 1, 2011 at 10:27 pm
the issue is not with sql but with network, thats what i can think of here.
Are both box in same domain or in different domain? what authentication you are using in connecting from 2005?
If possible just for testing, configure one sql user in 2000 and connect from 2005 using that sql user. Any difference?
----------
Ashish
June 1, 2011 at 10:44 pm
I am working as same domain and same user for sql 2000 and sql server 2005 and authentication is Windows authentication
June 1, 2011 at 11:43 pm
Check all the privileges are correct and go to the low level and check the things like configuration manager stc..and for testing purposes take the backup in 2000 and restore into 2005.
June 2, 2011 at 4:11 am
How many datatabase you have in SQL Server 2000?
Check your SSMS's Object Explorer
It gathers lot of information while you connect a database. Right click on header fields and select only required field to display.
Ram
MSSQL DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply