Hi all. I have tried to install this on the machine I am running my tv server on and another server I have on my network. Both machines are server 2k3 boxes. The flavor of sql I am using is sql 2005. The sql 2005 server is running on the same machine as my tv server. I created my new database user account in the sql database and it tested fine when I logged on using it. After installing the web server on the same machine as my sql server and tv server, I configured the database page as instructed. I then tested the connection and received an error logging on. The error mentions named pipe provider:could not open a connection to sql server. The other machine immediately generates an error that says the data source name nofound and no default driver specified. I am just new enough to sql to be unsure as to how to proceed. Any insight would be appreciated.
Hi Im getting the same error.
Error Connecting to TV Server Database
Failed with the following message:
[Anydac][Phys][ODBC][Microsoft][ODBC Driver Manager] Data Source Name Not Found and no default driver specified.
This is on a Win2K Small Business Server which is running SQL2000. THe TV Server is on another machine running SQL2005 Express.
Everything installs OK on the TV Server itself, but for me to access the machine from the internet, be handy to be able to installon the SBS machine.
Anyone have an idea on how to overcome this?
On my SBS2000 server there is SQL 2000, which Im guessing is causing a problem?
Ive updated the MDAC to 2.8, and a clean install of the Web Interface, but still no go and get the same error.