SQL Server 2000 - "SQL Server does not exist or access denied"
Posted on 2006-06-20
Ok, I am relatively new to SQL Server. I just installed SQL Server 2000 Developer Edition on my development workstation, which is XP Pro SP2. In my ASP.NET application I get the error "SQL Server does not exist or access denied." I have done some troubleshooting, looking at other questions here, microsoft, etc., but no luck. I have disabled the windows firewall and I am not running any other firewall on this box.
I moved this project from a different dev box running XP Pro SP2 with a local SQL Server 2000 instance, and it was working fine. I used the import/export wizard to transfer my database to the new box. I believe my connectionstring is OK, but I'll post it here anyway:
data source=localhost;integrated security=false;uid=mt_master;pwd=********;database=MT_Calc
mt_master is a sql server login.
I am running SQL Server 2000 SP4. I can use Enterprise Manager fine, and I can connect to the instance fine using Query Analyzer, choosing my server, etc. It just doesn't work from my application. The error occurs when it tries to open the connection. I have compared my SQL Server logins on the new dev box to those on the old and everything seems to match. I am plum out of idea!
Any help would be greatly appreciated!