Previous Thread:   CLR Table Valued Function

2/23/2006 10:56:30 AM    Problem setting up ODBC DSN for SQL Server Express
I have successfully installed MS SQL Server 2005 Express. I can open the  
  
databases in SQL Server Management Studio.  
  
But when I try to set up a DSN in the ODBC administrator, I get this error  
  
message (my translation):  
  
Error on Connection:  
  
SQLState: '01000'  
  
SQL Server Error: 2  
  
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())  
  
Error on Connection:  
  
SQLState: '08001'  
  
SQL Server Error: 17  
  
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist  
  
or Access denied.  
  
<<  
  
What's going wrong? I checked in the task manager, SQLservr.exe is running.  
  
Any help would be appreciated.  
  
Roland



2/23/2006 4:26:21 PM    Re: Problem setting up ODBC DSN for SQL Server Express
Roland Wingerter wrote  
  
------  
  
Problem solved, for ODBC I had to enable TCP/IP as described here  
  
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp  
  
Roland