I am in the process of migrating a website running ASP with SQL Server 2000 to SQL Server 2005 Express.
I have installed the data, and fixed the problems with orphaned users (I think).
I can access the data using SQL Server Management Studio Express
However I cannot establish a connection from any of the ASP or ASP.NET applications. At first I thought it was just the connection string (using SQLOLEDB) but then I tried to set up a data source using ODBC with either the SQL Server or SQL Native
Client driver. I have tried this on a remote machine (it is set up to allow remote connections), and also on the local server. The "Create a New Data Source" returns with the error "Specified SQL Server Not Found"
I am using (IPAddress)/SQLEXPRESS as the server name (I have also tried localhost and 127.0.0.1 when trying to connect locally.
When using the "Create New Data Source" locally I have tried connecting as one of the database users, and as sa, and using the local network account (which is used to run SQL Server Management Studio Express.
I have disabled the firewall.
I have checked that TCP/IP is enabled using SQL Server Configuration Manager
Port 1433 is open.
Could anyone assist me in this ?
Thank you in advance
View Complete Post