I'm new to SQL, so forgive me if this issue is noobish.
The problem I'm having, after after installing SQL Express 2008 is setting up the ODBC info. Using the System DSN tab I choose SQL Server, fill in all the applicable info, and when I hit "Next" after the authentication method is set I get the following:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
The SQL server that I'm trying to connect to is the same server that I'm setting this up on (app that requires SQL is on the same box -- didn't want to use a production SQL box).
Any help will be appreciated.
Thanks
The problem I'm having, after after installing SQL Express 2008 is setting up the ODBC info. Using the System DSN tab I choose SQL Server, fill in all the applicable info, and when I hit "Next" after the authentication method is set I get the following:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
The SQL server that I'm trying to connect to is the same server that I'm setting this up on (app that requires SQL is on the same box -- didn't want to use a production SQL box).
Any help will be appreciated.
Thanks